My Oracle Support Banner

FAQ for Item Import (Doc ID 109628.1)

Last updated on APRIL 18, 2023

Applies to:

Oracle Item Master - Version 11.5.10.2 and later
Oracle Product Hub - Version 11.5.10.2 and later
Information in this document applies to any platform.

Purpose

This document consolidates all the FAQs on Item Import Issues.

Questions and Answers

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
Purpose
Questions and Answers
 After importing items, they can't be seen in the Master Item form. Querying the items return "No Items Found".
 While importing items from a legacy system into the mtl_transactions_interface table, during the validation process an error occurs: 'oracle error 1426 in inltev' cause: inltev failed due to ora - 01426 numeric overflow. The sql statement being executed at the time of the error was update mtl_transaction_interface mti set last_update_date= sysdate, l and was executed...
 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:
 Item import process appears to have run successfully. There are no errors in the mtl_interface_errors table. The log file contains no warnings or error messages. The System_items_interface table still contains the items and the process_flag is still at 1. It is as if the process has never been run.
 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?

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