Upload Inventory Item Information

Because Item Wizard now has five different modes, it utilizes different interfaces to load data into Oracle E-Business Suite.

The primary ‘Items’ mode uses the following interface tables:

MTL_SYSTEM_ITEMS_INTERFACE, MTL_ITEM_REVISIONS_INTERFACE, MTL_ITEM_CATAGORIES_INTERFACE and MTL_DESC_ELEM_VAL_INTERFACE

To upload data into Oracle via these interfaces it requires a two step process:

1. Load all data into the Interface Tables.

2. Import the data from the Interface Table(s) into Oracle Inventory, Submit Item Import Concurrent Program(s). Once this step has completed successfully you are able to view the Item’s in Oracle Inventory.

Whereas the other four modes in the Wizard (UDA’s, Languages, Categories and Org Assignments) use public Oracle API’s. These are submitted differently and do not require Concurrent program submission.

Note - These instructions do not cover the uploading of attachments.

Refer to our Common User Instructions: Upload Attachments for details on how to upload attachments or refer to section: Attachments

Refer to section:

Upload an Item(s) - Items Mode

Error Handling and Validation

Submit Item Import Concurrent Program(s)

Upload Columns - Create Vs Update