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