INCOIN Import Items Fails with INV_IOI_PROCESS_SUP_LOC_ID or INV_IOI_PROCESS_YLD_LOC_ID When Item Locator Control "Prespecified"
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.
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 MESSAGE Name: INV_IOI_PROCESS_SUP_LOC_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
ERROR_MESSAGE:The process yield locator specified is not a valid locator for this subinventory & organization.
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
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