If an item is already in one inventory organization, then you can copy same item in other oragnization using Item Import
Program. You have to populate the copy_organization_id and copy_item_id columns to copy an item. You have to run the item import interface after loading these values into interface table. You can also change the values of an item attribute by
populating a value for that attribute in interface table. If a value is assigned to an attribute, then interface will use the
new value instead of the value in MTL_SYSTEM_ITEMS for that item in old organization.

Prevent transactions in Master Inventory Organization

There are two ways to control access transaction in Master Oranization:

1. Do not open any Inventory Accounting periods in the Master Organization. This will prevent any transactions from happening in Master organization.

2. The other way to restrict Inventory organizations by responsibility.
Navigate to Organization Access menu option under Setup->Organizations->Organization Access to restrict a responsibility to a organization from.

Return to : Oracle Database, SQL, Application, Programming Tips