How-toOracle E-Business SuiteInventory / Master Items

How to Create an Item in Oracle EBS

Question
how to create item in oracle ebs

Also searched as

  • oracle ebs create inventory item master organization
  • oracle ebs item template assign to organization
  • oracle ebs item creation steps
  • oracle inventory item attributes setup

Short answer

In Oracle EBS you create an item in the Master Items form (Inventory > Items > Master Items) while in the item master organization. Enter the item number and description, apply a template, set attributes on the tabs, save, then use Tools > Organization Assignment to enable the item in the child organizations that will stock, buy or build it.

Applies to: Oracle E-Business Suite R12.1 and 12.2 Inventory. Menu paths depend on the responsibility; some sites use Engineering or Product Hub forms.

Steps to create an inventory item

  1. 1Choose an Inventory responsibility and switch to the master organization (Change Organization). Item definition is done there; attributes controlled at master level cannot be set in child organizations.
  2. 2Open Inventory > Items > Master Items.
  3. 3Enter the item number (built from the Item flexfield segments) and description.
  4. 4Apply a template from the Tools menu (Copy From or Template). Templates such as Purchased Item, Finished Good or Phantom preset many attributes at once.
  5. 5Review attributes across the tabs: Main (primary unit of measure, item status, user item type), Inventory, Bills of Material, Costing, Purchasing, Receiving, Physical, Planning, Lead Times, Work in Process, Order Management and Invoicing.
  6. 6Assign the item to categories in the required category sets (Tools > Categories). Mandatory category sets must be satisfied.
  7. 7Save, then choose Tools > Organization Assignment and tick the organizations that should use the item.
  8. 8Verify in a child organization that the item shows the expected status and subinventory defaults, and check for an item import or sync to other systems.

Master organization and child organizations

EBS uses a two-level model. The master organization defines the item once, with its core definition such as unit of measure and many global attributes. Child organizations (plants, warehouses) then adopt the item through assignment, where some attributes can be overridden locally, such as planning parameters, depending on whether each attribute is controlled at master or organization level.

Item control levels are set in the Item Attribute Controls form. Changing them after items exist is restricted, so design the controls before loading data.

Templates, status and categories

Templates save time and consistency: they set the flags that make an item stockable, purchasable, buildable, transactable or customer-orderable. Create your own templates rather than ticking dozens of attributes per item. Keep in mind that a template overwrites only the attributes it specifies.

Item status controls which transactions are allowed, and category sets drive reporting, costing categories and sourcing. An item missing from a mandatory category set often cannot be saved or cannot be enabled in an organization.

Creating many items and common errors

For bulk creation use the Item Open Interface: load rows into MTL_SYSTEM_ITEMS_INTERFACE, then run the Import Items concurrent program, and review MTL_INTERFACE_ERRORS for rejected rows. Public PL/SQL item APIs listed in the Integration Repository are the other option for single-record integrations.

Typical errors involve duplicate item numbers, invalid unit of measure or status, inconsistent attribute combinations (for example, a stockable item that is not transactable, or costing enabled without the right inventory flags), and organization assignment failures when the child organization lacks a required category or cost setup.

-- Rejected item import rows
SELECT transaction_id, error_message, column_name
FROM   mtl_interface_errors
WHERE  request_id = :request_id

Try it here, free

Oracle EBS Item Attribute Template Worksheet

Open full tool

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

Common pitfalls

  • !Trying to create the item in a child organization instead of the master.
  • !Forgetting to assign the item to child organizations, so purchasing or WIP cannot see it.
  • !Hand-setting dozens of attributes instead of using a template, giving inconsistent items.
  • !Changing attribute control levels after items exist.
  • !Leaving mandatory category sets blank and getting save or assignment errors.

How an ERP-grounded AI assistant handles this

An assistant grounded in EBS item data (ERPray, read-only by default) can check a proposed item for duplicates, compare its attributes with similar items and list items missing from a category set or organization. Creation itself should stay with a human or the open interface, with approval for any write. For on-premises EBS, a locally hosted model keeps part numbers and design data inside the network. If you create a handful of items a week, the form and templates are enough.

See ERPray

Frequently asked questions

What is the master organization in Oracle EBS?

It is the organization where items are defined. Child organizations adopt items through organization assignment. Attributes with master-level control are set only in the master, while others can differ per organization.

How do I assign an item to another organization?

In the Master Items form, with the item queried, choose Tools > Organization Assignment and tick the organizations. Save, then verify in the child organization. The organization must have the setup the item needs, such as categories and costing.

Can I create items in bulk in Oracle EBS?

Yes. Load the Item Open Interface table MTL_SYSTEM_ITEMS_INTERFACE and run the Import Items program, or use the supported item APIs. Review MTL_INTERFACE_ERRORS for rejected rows after each run.

Why can I not change an item attribute?

Likely the attribute is controlled at master level and you are in a child organization, or the item status or transactions prevent the change. Check the Item Attribute Controls and switch to the master organization.

Related

Error fix

Fix Oracle EBS MTL_TRANSACTIONS_INTERFACE Rows Stuck With PROCESS_FLAG = 3

A row in MTL_TRANSACTIONS_INTERFACE with PROCESS_FLAG = 3 failed validation or processing in the Inventory Transaction Manager. The reason is written to ERROR_CODE and ERROR_EXPLANATION on that row. Correct the data (item, subinventory, locator, period, lot or serial), set PROCESS_FLAG back to 1 and let the Process transaction interface program or the Transaction Manager pick it up again.

How-to

Oracle EBS REST API: Integrated SOA Gateway and PL/SQL APIs

Oracle E-Business Suite exposes APIs through the Integration Repository, which catalogs PL/SQL public APIs, open interfaces, business events and web services. Integrated SOA Gateway (ISG) can deploy selected interface definitions as REST or SOAP services. You find the API, deploy it, grant a user access, and call it over HTTPS with the right application context.

How-to

How to Create ERP Items from CAD Automatically

Generate the part number once, in one place (usually PDM or PLM), carry the attributes as CAD properties, and push a released item to the ERP item master through its import interface with validation. Retyping parts into ERP is the main source of duplicates, wrong units and missing make or buy codes.

How-to

How to Close an Inventory Accounting Period in Oracle EBS

Before closing an Inventory period, run the Pending Transactions report to clear every uncosted or erroring material transaction, then close through Inventory > Accounting Close Cycle > Inventory Accounting Periods. Inventory will refuse to close while pending transactions remain, and any that get force-closed into the next period will misstate both months' costed inventory value.

Error fix

Fix FRM-40735: WHEN-VALIDATE-RECORD Trigger Raised Unhandled Exception ORA-06508

FRM-40735 with ORA-06508 almost always means a PL/SQL package used by the form was recompiled while your session still held the old cached state, or the trigger's own exception handling does not trap a real data error. Exit the form completely and re-enter it; if the error repeats for all users, recompile invalid objects on the database and check for a bad custom trigger.

Error fix

Oracle EBS Concurrent Manager Will Not Start: How to Fix It

A concurrent manager that will not start in Oracle EBS is almost always one of three things: the node registered in FND_NODES no longer matches the actual hostname (common after cloning), stale OS processes are blocking a fresh start, or the database and listener the manager connects to are unreachable. Check the internal manager log, verify the node name, clear stale processes, and restart with adcmctl.sh.

AI for ERP

AI for Oracle E-Business Suite, Without Leaving On-Prem

Hosting 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 ERP

A Private LLM Grounded on Your ERP Data

How a private LLM answers questions on your ERP data: RAG plus text-to-SQL, role-based permissions inherited from the ERP, and where each fits.

Stuck on Oracle E-Business Suite?

Talk to engineers who work inside Oracle E-Business Suite every week, and who build private AI that answers these questions from your own ERP data.

Talk to an ERP engineerBrowse ERP Help
All ERP Help articles

Keep exploring

Free tools

ERP fixes and how-tos

Runs with your ERP

AI on your ERP

Integrations

Software

TermsOracle EBS Concurrent Program