My Oracle Support Banner

Understanding Item Import and Debugging Problems with Item Import (Doc ID 268968.1)

Last updated on JUNE 08, 2023

Applies to:

Oracle Item Master - Version and later
Information in this document applies to any platform.
This document is for all users of Oracle EBS 11i and R12 and later


Item Import Overview
Use the item import process to import items from your legacy system or PDM system. You can import items from any source into Oracle Inventory and Oracle Engineering.

When you import items through the Item Interface, you create new items in your Item Master organization or assign existing items to additional organizations. You can specify values for all the item attributes, or you can specify just a few attributes and let the remainder default or remain Null. You can also specify an item template for each item and inherit attribute values from the template. The Item Interface also lets you import revision details, including past and future revisions and effectivity dates. Validation of imported items is done using the same rules as the item definition forms, so you are insured of valid items.

The Item Interface reads data from two tables for importing items and item details. You use the MTL_SYSTEMS_ITEM_INTERFACE table for new item numbers and all item attributes. This is the main item interface table, and can be the only table you choose to use. If you are importing revision details for
new items, you can use the MTL_ITEM_REVISIONS_INTERFACE table.

A third table, MTL_INTERFACE_ERRORS, is used for error tracking of all items that the Item Interface fails. You can import item categories using interface table called as MTL_ITEM_CATEGORIES_INTERFACE.

Before you use the Item Interface, you must write and run a custom program that extracts item information from your source system and inserts it into the MTL_SYSTEM_ITEM_INTERFACE table, and (if revision detail is included) the MTL_ITEMS_REVISIONS_INTERFACE table. After you load the items into these interface tables, you run the Item Interface to import the data. The Item Interface assigns defaults, validates data you include, and then imports the new items. You may also specify an item template for each item being imported.

You must import items into the Item Master organization before you import items into additional organizations. You can accomplish this by specifying only your Item Master organization on first run of the Item Interface. Once this has completed, you can run the Item Interface again, this time specifying an
additional or all organizations. You can also use the Item Interface to import a single item material cost and material overhead, and revision details.

Below we will walk through few scenarios of item import and provide answers to frequently asked questions.


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

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

In this Document
 Scenario 1: Testing the basic item import with minimum columns populated
 Scenario 2: To import items and use item templates
 Scenario 3: To import items and material cost associated to it.
 Scenario 4: To import item and revisions associated to it
 Scenario 5: Import more than two revisions along with item creation
 Scenario 6: Import item categories along with items.
 Scenario 7: Import item catalogs along with items.
 Scenario 8: How to update existing items.
 Scenario 9: How to populate character and number columns and make it null
 Frequently Asked Questions (FAQ):
 a. How do I know what error has occurred?
 b. What things should I check if I getting errors?
 c. I run item import but records are not getting processed. The process_flag is still 1.
 d. What do I do to check more in to errors and see where the import is failing?
 e. 11.5.9 Item import issues and patches to be applied.
 f. List of documents required while logging a tar on item import.
 g. Some examples of errors and what it might mean
 h. Is there an API for Item creation and updation?

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