Item Import (INCOIN) And Item Form (INVIDITM) Locking Conflicts (Doc ID 1361369.1)

Last updated on DECEMBER 07, 2015

Applies to:

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


Symptoms

The whole batch of item import ends in error when an item is kept open in the Items form and simultaneously the request "Import Items" is submitted.

STEPS

1. Open an Item in Items form.
2. Insert some items in mtl_system_items_interface which includes the same item locked by step 1
3. Run the item import program.
4. Find none of the items got updated as expected. You expect that only the locked item will have a problem.

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