2.0 Create Item in Master Organization


  • Form Application: Inventory
  • Form Name: INVIDITM
  • Form Path: /oracle/apps/r12/visr12/apps/apps_st/appl/inv/12.0.0/forms/US/INVIDITM.fmx

Item Master is one of the core focus areas of any ERP system. An item is goods or services offered by any business to make revenue. Items/Services are created in ITEM MASTER first. Item Master consists of Item, description and associated attributes required for each function of business e.g. sales, marketing, purchasing, planning, finance.

In Oracle Items are created first in Item Master Organization and then enabled in other local organizations. Master organization can be dummy or physical organization. Item attributes can be controlled at master level or organization level. Master controlled attributes are always set and managed at item master organization. Organizational item attributes can be set differently in each local organizations.

Create Item in Master Organization - Oracle Inventory
Creating Items in Item master is one one of the fundamental step in Oracle Inventory, this is also core of entire Oracle Apps ERP. Item master is referred in all other modules.
Item must be created in item master (master inventory organization) before it is assigned to any local inventory organizations.
For detailed tutorial on how to create item in master inventory organization visit us at http://oracleappscommunity.com/oracle/blog/2030/create-item-in-master-organization/


Inventory responsibility -> Items -> Master Items

  1. Enter Item Number/name. This must be unique number/name.
  2. Enter Item description.

Navigate to different tabs of Item master grouped by function to set different item attributes. While you are in item master organization you can set any item attributes, if you are in local organization you can only set organizational controlled attributes.

Create Item in Master Organization

Create Item in Master Organization


  1. MAIN – Set item attributes Primary unit of measure (UOM), Item Type, Item status, log description
  2. INVENTORY – Inventory Item, stockable, transactable, reservable, revision control, cycle count, Lot control, serial control, shelf life.
  3. BILLS OF MATERIAL – BOM allowed, BOM Item Type
  4. ASSET MANAGEMENT – Asset Item type
  5. COSTING – Costing enabled, Inventory Asset value, Include in roll-up, Cost Of Goods (COGS) account.
  6. PURCHASING – Purchased, Purchasable, Use Approved Supplier, Default buyer, list price, Out Side Processing item
  7. RECEIVING – Receipt date controls, Overreceipt quality control, receipt routing
  8. PHYSICAL ATTRIBUTES – Weight, Volume, Dimensions, Container
  9. GENERAL PLANNING – Inventory planning method, subcontracting item, Make or Buy, default planner, Min-max quantity, safety stock, sourcing rules, order modifiers, vendor managed inventory
  10. MPS MRP PLANNING – Planning method, forecast control, pegging, exception set, Time fences.
  11. LEAD TIMES – Preprocessing, processing, post processing, Fixed, variable, Cumulative Manufacturing, cumulative total, lead time lot size.
  12. WORK IN PROCESS – Build in WIP, Supply Type, Over Completion
  13. ORDER MANAGEMENT – Customer Order enabled, Internal order enabled, Shippable, Pick Components, Assemble to order, ship model complete, returnable, RMA inspection required, Check ATP, ATP rules, Shipping tolerances
  14. INVOICING – Invoice enabled, Invoiceable item, accounting rule, invoicing rule, sales account, payment terms.
  15. PROCESS MANUFACTURING – Process quality enabled, process costing enabled, recipe enables, hazardous material, process execution enabled
  16. SERVICE – Service request enabled, service contracts, Install base, Debrief and charges

Save the item details entered. This will create a new item in master organization.


Leave a reply

Your email address will not be published. Required fields are marked *