My Oracle Support Banner

Import Items Performance Issue On Update (Doc ID 1956955.1)

Last updated on AUGUST 04, 2024

Applies to:

Oracle Item Master - Version 12.1.3 and later
Oracle Inventory Management - Version 12.2.4 to 12.2.4 [Release 12.2]
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
 
The concurrent Import Items hangs for hours when it update the table mtl_system_items_interface.
* The database session shows that the activity was for seconds.
* There is no error, but the concurrent takes hours for complete normal.

EXPECTED BEHAVIOR
 
Expect the import to finish in a few minutes, not hours.

STEPS
 
1. Insert interface records.
2. Run concurrent program.
3. Takes too long.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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