Data Fix for Obsolete PICKING_RULE_ID in MTL_SYSTEM_ITEMS_B Causing INV_IOI_MASTER_CHILD_4J and INV_IOI_ERR Errors (Doc ID 2076484.1)

Last updated on AUGUST 21, 2016

Applies to:

Oracle Item Master - Version 12.1.3 and later
Information in this document applies to any platform.
Obsolete PICKING_RULE_ID in MTL_SYSTEM_ITEMS_B Causing INV_IOI_MASTER_CHILD_4J and INV_IOI_ERR

Symptoms

On : 12.1.N

When attempting to update organization controlled account numbers, Import items fails with master child errors on picking_rule_id (INV_IOI_MASTER_CHILD_4J).

When attempting to update master controlled PICKING_RULE_ID, Import items fails for invalid values on account numbers at the child organization level (INV_IOI_ERR) for each of the invalid account numbers.

DATAFIX REQUEST:

THEREFORE the customer is requesting a data fix to set OBSOLETE attribute PICKING_RULE_ID to NULL values for all items in the MTL_SYSTEM_ITEMS_B table.



ERROR

INV_IOI_MASTER_CHILD_4J
INV_IOI_ERR



STEPS

The issue can be reproduced at will with the following steps:
1. Load transactions in MTL_SYSTEM_ITEMS_INTERFACE (MSII) to fix organization controlled attributes and get          INV_IOI_MASTER_CHILD_4J on PICKING_RULE_ID


2. Load transactions in MSII to fix PICKING_RULE_ID and get INV_IOI_ERR on invalid organization controlled attributes.



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