Coping Items using Item Interface

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.

Have a Oracle Question
Do you have an Oracle Question?

Oracle Books
Oracle Certification, Database Administration, SQL, Application, Programming Reference Books

Oracle Application
Oracle Application Hints and Tips

Oracle Home
Oracle Database, SQL, Application, Programming Tips

All the site contents are Copyright © www.erpgreat.com and the content authors. All rights reserved.
All product names are trademarks of their respective companies.
The site www.erpgreat.com is not affiliated with or endorsed by any company listed at this site.
Every effort is made to ensure the content integrity.  Information used on this site is at your own risk.
 The content on this site may not be reproduced or redistributed without the express written permission of
www.erpgreat.com or the content authors.