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 FEBRUARY 03, 2019
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 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.
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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!