How to Define Oracle Inventory Organization

Optional step before defining inventory organization

Define Location.

1. Now In Inventory responsibility navigate to

    Setup -> Organizations -> Organizations

Enter organization name and type from pre defined list.

In this case this organization is defined as Master Org.

2. To define a location navigate to

     Setup -> Organizations -> locations

Oracle APPS Supply Chain Tables ERD PART-1

Oracle inventory main reporting tables.
--------------------------------------------------------------------------------

MTL_MATERIAL_TRANSACTIONS

Base table for all transactions (etc RCV,Issuance,Sub Inv Transfer,Inter Org Transfer,Misl Transactions...).

MTL_SYSTEM_ITEMS

Table contains all System items organization wise. It is Base table for items.

This table holds the definitions for inventory items, engineering items, and purchasing items. The flexfield code is MSTK. The primary key for an item is the INVENTORY_ITEM_ID and the ORGANIZATION_ID. The same item could be defined in more than one organization. Each row represents an item in an organization.