INCOIN Poor Performance

(Doc ID 2314126.1)

Last updated on OCTOBER 09, 2017

Applies to:

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

Symptoms

On : 12.2.6 version,

ACTUAL BEHAVIOR
---------------
Item Import (INCOIN) Poor Performance

EXPECTED BEHAVIOR
-----------------------
Expectation is for the item import to complete in under 1 minute for a batch of 1000 items.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Populates the mtl_system_items_interface. Records are batched in 1000 items by setting a unique "set_process_id".

2. Submit the Item Import for each unique set_process_id.


Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms