FAQ for Item Import
(Doc ID 109628.1)
Last updated on JULY 08, 2020
Applies to:Oracle Item Master - Version 220.127.116.11 and later
Oracle Product Hub - Version 18.104.22.168 and later
Information in this document applies to any platform.
This document consolidates all the FAQs on Item Import Issues.
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
|Questions and Answers|
|After importing items, they can't be seen in the Master Item form. Querying the items return "No Items Found".|
|Master items have been successfully imported into the MTL_SYSTEM_ITEMS table. Now the import process is being run to insert the items into the "Child" organizations. The following error messages are occurring:|
|Running the Import Customer Items process INVCIINT finshes with status = 'Error' with no error_code or error_explanation populated in mtl_ci_interface.|
|When trying to insert records in the MTL_SYSTEM_ITEMS_INTERFACE_TABLE, getting an error: ORA-00001: unique constraint (INV.MTL_SYSTEM_ITEMS_INTERFACE_U2) violated|
|While populating MTL_ITEM_REVISIONS_INTERFACE to import revisions for existing items, getting the following error:|
|The following errors occur in the concurrent request log after an unsuccessful attempt at item import:|
|Override functionalities of attributes and Descriptive Flexfields:|
|Running INCOIN (Item Import) with a shared install of Inventory produces the following error message:|
|What are the required key flexfields in Oracle Inventory?|