# Oracle EBS Item Attribute Template Worksheet

> Source: https://netray.co/tools/oracle-ebs-item-attribute-template-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Plan item master attribute values for a new item template, with the underlying MTL_SYSTEM_ITEMS_B column for each attribute.

## Category

oracle

## Erp

Oracle E-Business Suite

## Industry

Discrete Manufacturing

## Audience

- Oracle EBS consultant
- Item master data steward
- Data migration lead

## Tool

**Kind:** worksheet

**Mode:** editable

**Columns:**

#### Attribute

**Key:** attribute

**Type:** text

#### MTL_SYSTEM_ITEMS_B column

**Key:** column

**Type:** text

#### Control level

**Key:** level

**Type:** select

**Options:**

- Master
- Org
- Either

#### Template value

**Key:** value

**Type:** text

#### Rationale or decision owner

**Key:** note

**Type:** text

**Rows:**

**Attribute:** Make or Buy

**Column:** PLANNING_MAKE_BUY_CODE

**Level:** Org

**Value:** 1 (Make)

**Note:** Make = 1, Buy = 2. Planning owns the decision.

**Attribute:** MRP Planning Method

**Column:** MRP_PLANNING_CODE

**Level:** Org

**Value:** 3 (MRP planning)

**Note:** Other values include MPS and Not planned.

**Attribute:** Inventory Item

**Column:** INVENTORY_ITEM_FLAG

**Level:** Master

**Value:** Y

**Note:** Required to stock the item.

**Attribute:** Build in WIP

**Column:** BUILD_IN_WIP_FLAG

**Level:** Org

**Value:** Y

**Note:** Needed to create discrete jobs.

**Attribute:** BOM Allowed

**Column:** BOM_ENABLED_FLAG

**Level:** Master

**Value:** Y

**Note:** Needed to carry a bill of material.

**Attribute:** WIP Supply Type

**Column:** WIP_SUPPLY_TYPE

**Level:** Org

**Value:** 1 (Push)

**Note:** Push, assembly pull, operation pull, bulk, supplier or phantom.

**Attribute:** Lot Control

**Column:** LOT_CONTROL_CODE

**Level:** Master

**Value:** 1 (No control)

**Note:** Set to 2 for full lot control. Hard to change after transactions.

**Attribute:** Primary UOM

**Column:** PRIMARY_UOM_CODE

**Level:** Master

**Value:** EA

**Note:** Cannot be freely changed once transacted.

**Notes:** 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.

## Content

**Intro:** 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.

**Sections:**

#### How to use this worksheet

**Body:** 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

**Body:** 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.

**Bullets:**

- 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

**Body:** 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

**Body:** 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.

**Cta:** 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.

**Faq:**

#### What is an item template in Oracle EBS?

**Answer:** 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?

**Answer:** 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?

**Answer:** 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?

**Answer:** Only where the business differs, such as lead times or make or buy choice. Keep master-controlled attributes identical, and document each plant exception.

## Search terms

oracle ebs item template, item attribute worksheet oracle inventory, mtl_system_items_b columns, oracle item master template excel, planning_make_buy_code values, mrp_planning_code oracle, wip_supply_type values

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json