My Oracle Support Banner

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

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.