Define Member/Child Inventory Organization

Defining Member/Child Inventory Organization (MIP) to Master Inventory Organization (MIH)

Define Location

Navigation: Inventory >  Setup > Organizations > Locations

Enter the values as per the below screen shot for location and address and save the changes and close the form.

Define Member/Child Inventory Organization (MIP)

Navigation: Inventory > Setup > Organizations > Organizations > New (B)

Enter the values as per the below screen shot for Inventory Organization and check the enable check box and save the changes.

Click on others button and select Accounting Information from list and click on OK button.

Enter the values as per the below screen shot for Accounting Information and save the changes and click on OK button.

Click on others button again and select Inventory Information from list and click on OK button.

Enter the values as per the below screen shot for Inventory Parameters or copy the previous inventory organization values through Tools > Copy Organizations

Select the inventory Organization which you we need to copy the Costing Information, Revision, Lot, Serial and LPN and Other Accounts tabs.

Once we select the mcr Indus hyd organization system will copy the Costing Information, Revision, Lot, Serial and LPN and Other Accounts tabs information from mcr Indus hyd organization except Organization Code and Item Master Organization.

Here we should give Organization Code for member organization code like mip (mcr Indus pune) and Item Master Organization as mcr Indus hyd like below screen shot. Now mip organization will be a member to the mih (mcr Indus hyd Master Organization).

Check all three tabs whether values have been copied from mcr Indus hyd to mcr Indus pune.

Click on others button again and select Receiving Information from list and click on OK button. Enter the mandatory/required (* specified) field values as per the below screen shot for Receiving Information and click on save button.

Create new member organization from existing member organization by using Copy Organization feature

We can create new inventory organizations or copy an existing organization. We must establish a model organization to use as a baseline for new organizations. This model organization must be a transnational organization and not an item master organization. We can copy only organizations within the same operating unit. The system creates the new organizations under the same business group to which the model organization belongs, and assigns the new organizations to the same operating unit, legal entity, and ledger as the model organization.

When we copy organizations you specify which information to copy from the model organization. You can choose to copy the following information from the model organization:

·         Organization definition

·         Shipping networks

·         Hierarchy assignments

·         Bills of material and bills of material parameters

·         Departments, resources, and routings

·         Item information

When we copy a model organization the system automatically copies the following information:

·         Sub-Inventories

·         Locators

·         Work in Process parameters

·         Work in Process accounting classes

·         Planning parameters

·         Shipping parameters

Note: The system does not copy organization-specific data including: cost type, cost sub-element, Process Manufacturing Enabled, Oracle Warehouse Management enabled, and cost-sharing entities. 

Define Location for B’lore

Navigation: Inventory  > Setup > Organizations > Locations

Enter the values as per the below screen shot for location and address and save the changes and close the form.

To create Copy Organization for new Member/Child Organization

Navigation: Inventory > Setup > Organizations > Organization Copy > Maintain Interface à New

Enter the values as per the below screen shot and click on Populate Interface Table button

Data will be populated into Table MTL_COPY_ORG_INTERFACE

SELECT * FROM MTL_COPY_ORG_INTERFACE WHERE GROUP_CODE='migrp1'

Now go to Launch Organization Copy

Navigation: Setup > Organizations > Organization Copy > Launch Organization Copy

Pass the parameters as below screen shot and click on OK button.

Click on Submit Button

Request has been submitted successfully.

Now we can go and check for member organization mcr Indus blore.

Navigation: Setup > Organizations > Organizations > Query for mcr Indus blore organization.

Member organization mcr Indus blore has been created with all Accounting, Inventory and Receiving information.

Backend Tables for master and member Inventory Organizations:

SELECT MP.MASTER_ORGANIZATION_ID,

             OOD.ORGANIZATION_ID,

             OOD.ORGANIZATION_NAME,

             MP.ORGANIZATION_CODE,

             OOD.INVENTORY_ENABLED_FLAG

   FROM ORG_ORGANIZATION_DEFINITIONS OOD,

             MTL_PARAMETERS MP

WHERE MP.ORGANIZATION_ID=OOD.ORGANIZATION_ID

     AND OOD.ORGANIZATION_NAME LIKE 'mcr%'