Item Number (Segment1) Does Not Update Through Item Import (INCOIN) Process

(Doc ID 1581745.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Inventory Management - Version and later
Information in this document applies to any platform.


 INCOIN program does not update Item Number (Segment1) through Item Open Interface (IOI)


Added code in IOI packages to identify and handle item number update.                                                  
 INVPOPIF.UPDATE_SYNC_RECORDS - converts SYNC records to UPDATE and checks for item number update.

Executes validations  
1. Item Number Updateable profile                              
2. Item Number not updateable in child organization            
. Update leading to duplicate item number INVUPD2B  
- identifies successful rows in MSII and   executes an UPDATE statement on using inventory_item_id as predicate to update ITEM
 NUMBER across organization hierarchies.


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