Item Master Organization

Item Master Organization
 
An item master organization is a logical entity that you use to define items. You use the other organizations to store and transact inventory. After you define an item in the item master, you can assign it to any number of other organizations.

There is no functional or technical difference between the item master organization and other organizations; however, it is recommended that you limit the item master to an item definition organization.

You should also define one item master organization per implementation. You can use the same item master for child organizations across different ledgers. Item masters are distinct entities with no relationship to each other. You cannot associate items in one item master organization with another item master organization. You cannot copy items across item master organizations.

Defining the Item Master Organization

You create the item master organization in the same way that you create other inventory organizations.

• You use  the Organization window to create the item master organization. 
• Use the Organization Parameters window to specify the organization as the Item Master.
• You assign child organizations to the item master organization.

Note that the item master uses itself as its item master.

Item Mater

Always define items in the master organization. When you define an item, Oracle automatically changes your current organization to the master organization. You may enable your new items in as many child organizations as needed.

Before defining items, 1st we will create custom responsibility for inventory.

Define Custom Responsibility for Inventory

Navigation: System Administrator > Security > Responsibility > Define.

Enter the values as per the below screen shot and save the changes.

Backend Tables for Responsibility:

SELECT * FROM FND_RESPONSIBILITY WHERE RESPONSIBILITY_KEY='MCR INV'

SELECT * FROM FND_RESPONSIBILITY_TL WHERE RESPONSIBILITY_ID= 66034

Define User and Assign MCR INV to defined user.

Navigation: Sys Admin > Security > User > Define.

Enter the values as per the below screen shot and assign the MCR INV Responsibility and save the changes.

 

Backend Tables for Users:

SELECT * FROM FND_USER WHERE USER_NAME='CHARAN'

Organization Access

Organization Access is feature which is used to restrict specific Inventory Organization to a responsibility.

Navigation: Inventory > Setup > Organizations > Organization Access

Enter the values as per the below screen shot and save the changes.

Now only mcr inv Responsibility can access these (MIH, MIP and MIB) three Inv. Organizations and other responsibility can’t access these Inv. Organizations.

Backend Table for Organizations Access

SELECT * FROM ORG_ACCESS WHERE RESPONSIBILITY_ID =66034

What is an Item?

An item is a part or service you:

·         Purchase

·         Sell

·         Plan

·         Manufacture

·         Stock

·         Distribute

·         Prototype

Items can also be containers for items as well as components you build into other items.

Define Items in Master Organization

Navigation: mcr inv à Items à Master Items à MIH (Inv. Org.)

Enter the values as per the below screen shot and save the changes.

Go to Inventory Tab check the below check box as per the screen shot.

Go to Purchase Tab check the below check box and list price as per the screen shot.

To assign the item MI-FG to member Organizations go to Tools à Organization Assignments. Check the assigned check box for MIP and MIB and save the changes.

Note: Once we assigned an item to member organization we can’t unassigned to from 
member organization.

Back-End table for items

SELECT MP.MASTER_ORGANIZATION_ID,

              OOD.ORGANIZATION_ID,

              OOD.ORGANIZATION_NAME,

              MSI.SEGMENT1

    FROM MTL_SYSTEM_ITEMS_B MSI,

              ORG_ORGANIZATION_DEFINITIONS OOD,

              MTL_PARAMETERS MP

 WHERE MSI.ORGANIZATION_ID=OOD.ORGANIZATION_ID

      AND OOD.ORGANIZATION_ID=MP.ORGANIZATION_ID

      AND MSI.SEGMENT1='MIH-FG'