My Oracle Support Banner

How to Import Subinventory Items Relationship Using Table MTL_ITEM_SUB_INVS_INTERFACE (Doc ID 263649.1)

Last updated on AUGUST 11, 2023

Applies to:

Oracle Inventory Management - Version 11.5.10.2 and later
Information in this document applies to any platform.

Goal

Q1. Explaining the use of table MTL_ITEM_SUB_INVS_INTERFACE to assign items to subinventories.

Q2: The issue is that we need to create thousands of organizations assigned to relevant
sub-inventories. Normally creation of org items are being done by the item interface table and it
would be possible to update thousands or even millions of items with the sub-inventories.
How can i load these dynamically? 
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.