Oracle EBS Item Attribute Template Worksheet
Item templates in Oracle Inventory let you apply a consistent set of attributes to every new item of a given class. This worksheet helps your team agree the values and owners before anyone loads thousands of items.
| Attribute | MTL_SYSTEM_ITEMS_B column | Control level | Template value | Rationale or decision owner | |
|---|---|---|---|---|---|
Use this to agree template values before loading items. Control level (master or organization) is defined in Item Attribute Controls and may be customized. Verify codes against the Oracle Inventory User Guide for your release.
Item master quality scan
Optional: we can profile your MTL_SYSTEM_ITEMS_B data for conflicting attributes.
Optional. The tool and every export work without this. No spam.
How to use this worksheet
Start from the eight example rows, then add a row for every attribute your template will set, such as costing, shelf life, serial control or planning time fences. Record the intended value and who owns the decision. Export to Excel, circulate it to planning, purchasing and finance, and use the signed-off version as the source for the Item Templates window or your item load script.
Master versus organization control
Some attributes are controlled at the master organization and copied to child organizations, while others are set per organization. Make or buy and the MRP planning method are examples of values set by organization. This matters in a multi-plant rollout, where you can end up with the same item set to Make in one plant and Buy in another.
- Master controlled: UOM, lot and serial control, item type
- Org controlled: planning method, lead times, supply type
- Check Item Attribute Controls for any local changes
- Document exceptions per plant
Attributes that are hard to change later
Primary unit of measure, lot control, serial control and costing flags are difficult or impossible to change once there is on-hand or open transactions. Treat these as design decisions that require review, not as defaults. The cost of fixing them afterwards typically involves transferring stock into a new item.
Common mistakes
A frequent mistake is copying an existing template without reviewing hidden attributes, so every new item inherits an outdated lead time or supply type. Another is leaving Build in WIP off for manufactured parts, which blocks job creation. Check a sample item in the Master Items form before loading in bulk.
Frequently Asked Questions
What is an item template in Oracle EBS?
An item template is a saved set of attribute values that you apply when creating an item or to existing items. It speeds up setup and keeps attributes consistent for a class of items.
Which table holds item attributes?
Most attributes live in MTL_SYSTEM_ITEMS_B, with one row per item per organization. Translated descriptions are in MTL_SYSTEM_ITEMS_TL, and categories are stored in separate category tables.
Can I change lot control after transactions exist?
Generally no, or only with restrictions. Oracle blocks many such changes when on-hand or open documents exist, so decide at item creation and test in a non-production instance.
Should template values differ by plant?
Only where the business differs, such as lead times or make or buy choice. Keep master-controlled attributes identical, and document each plant exception.
If you are cleaning item master data ahead of a migration or upgrade, we can help profile the attributes in your EBS database and flag inconsistent items.
Related Tools
Oracle EBS BOM Interface Load Worksheet
Stage BOM component rows with the columns used by the Oracle BOM open interface, then export to Excel for loading.
OracleOracle EBS MRP Exception Messages Reference
What each Oracle MRP exception message means, why it appears and what a planner usually does about it.
Developer ToolsOracle EBS SQL Query Generator for Items and WIP Jobs
Build ready-to-run SELECT statements over MTL_SYSTEM_ITEMS_B, WIP_DISCRETE_JOBS and on-hand quantity tables.
OracleOracle EBS WIP Accounting Class Reference
Understand Oracle WIP accounting class types and which valuation and variance accounts each class uses.
More Oracle tools
See all- Oracle EBS Discrete Job Statuses Reference
- Oracle EBS Inventory Transaction Types Reference
- Oracle EBS Inventory Period Close Checklist
- Oracle EBS Cycle Count Setup Worksheet
- Oracle EBS WIP Job Close Variance Worksheet
- Oracle EBS Routing and Operations Load Worksheet
- Oracle EBS Inventory Organization Parameters Setup Template
- Oracle EBS Item Cost Update Request Form
- Oracle EBS Engineering Change Order Request Template
New to Oracle E-Business Suite? Start with the Oracle E-Business Suite guide and toolkit, or plan with Oracle EBS Roadmap Planner, Training Path Builder, ERP Certification Study Planner.
Keep exploring
Free tools
- Oracle EBS Item Cost Update Request FormFill-in form to request and approve a standard cost change with reason, impact and sign-off lines for the audit file.
- Oracle EBS Item Lead Time CalculatorCompute total planning lead time for a make or buy item from preprocessing, fixed, variable and postprocessing days.
- Oracle EBS Item Import Script Generator (MTL_SYSTEM_ITEMS_INTERFACE and INCOIN)Generates interface inserts for a master and child organization, the Import Items (INCOIN) submission, error SQL against MTL_INTERFACE_ERRORS and a check query for created items.
ERP fixes and how-tos
- How to Create an Item in Oracle EBSCreate an inventory item in Oracle EBS: Master Items form, master organization, templates, attributes, organization assignment, categories and common errors.
- Oracle Workflow error: Attribute does not exist for item typeFix Oracle Workflow's Attribute does not exist for item type error in EBS by checking the item type's attribute definitions in Workflow Builder against every activity and message referencing it, including custom customizations.
- Oracle EBS Outside Processing and Production SchedulingSet up outside processing in Oracle EBS WIP and Purchasing: OSP items, resources, departments, routing and requisitions, plus how discrete job scheduling works.
Runs with your ERP
- Esker Order Management and Oracle E-Business SuiteHow Esker captures customer POs from email, fax and PDF and creates sales orders in Oracle EBS: integration, data flows, setup, pitfalls and a private AI layer.
- Cloud Inventory (DSI) with Oracle E-Business Suite: Mobile Barcode InventoryCloud Inventory, formerly DSI, adds offline mobile barcode inventory to Oracle E-Business Suite and JD Edwards. Data flows, setup steps, pitfalls and AI notes.
- BarTender and Oracle E-Business Suite: Label Printing from OracleHow BarTender prints labels from Oracle EBS using Oracle XML print requests and Integration Builder: methods, data flows, setup steps, pitfalls and AI help.
AI on your ERP
- AI for Oracle E-Business Suite, Without Leaving On-PremHosting Oracle EBS 12.2 on-prem or in a private cloud? Add a private LLM over concurrent programs, interface tables and AP/PO data without moving to Fusion.
- AI for Oracle EBS in Industrial Manufacturing: WIP, MRP, and BOM Questions Answered DirectlyAI for Oracle E-Business Suite in industrial manufacturing: WIP jobs, BOMs, MRP, inventory and purchasing answered in plain English, private and read-only.
Integrations
- How to use ChatGPT with Oracle E-Business SuiteUsing ChatGPT with Oracle E-Business Suite: export vs live access, custom GPT actions over ISG REST, enterprise data controls and when to keep data on-prem.
- How to connect Claude to Oracle E-Business SuiteConnect Claude to Oracle E-Business Suite via MCP, the Anthropic API, AWS Bedrock or Vertex, and know when an on-prem open-weight model is the better fit.