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 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

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

Changes

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.

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