INCOIN Import Items Fails with INV_IOI_PROCESS_SUP_LOC_ID or INV_IOI_PROCESS_YLD_LOC_ID When Item Locator Control "Prespecified" (Doc ID 1592221.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

On : 12.1.3 version, Item Issues

When attempting to update items with import items, the following errors occur, IF:
a) Locator control for the items is set to Prespecified
b) The PROCESS_SUPPLY_SUBINVENTORY and / or PROCESS_YIELD_SUBINVENTORY fields are populated with a Subinventory that has Locator Control = None

NOTE: the same change can be performed and saved in the User Interface in the Organization Items Form.

ERROR
 
ERROR MESSAGE Name: INV_IOI_PROCESS_SUP_LOC_ID
COLUMN_NAME: PROCESS_SUPPLY_LOCATOR_ID
ERROR_MESSAGE:The process supply locator specified is not a valid locator for this subinventory & organization.

ERROR MESSAGE Name: INV_IOI_PROCESS_YLD_LOC_ID
COLUMN_NAME: PROCESS_YIELD_LOCATOR_ID
ERROR_MESSAGE:The process yield locator specified is not a valid locator for this subinventory & organization.


STEPS

The issue can be reproduced at will with the following steps:
1. Create an item and assign it to a Process Manufacturing Organization.
2. Set Locator control = Prespecified
3. Populate Supply Subinventory and or Yield Subinventory with a Subinventory that has Locator Control set to None.
4. Insert one UPDATE transaction into the MTL_SYSTEM_ITEMS_INTERFACE table with any change for the organization / Item mentioned above.
5. Launch import items
6. View log file

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