My Oracle Support Banner

Import Items (INCOIN) Should Honor '!' To Set Defect_tracking_on_flag = Null Values (Doc ID 1982036.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

ACTUAL BEHAVIOR
 
Customer uses a custom process to load items from a source child organization into the mtl_system_items_interface table with a new organization_id so that the target organization receives the organization controlled attributes from the source child organization rather than the master organization item.

The Master Item has a non-null value in DEFECT_TRACKING_ON_FLAG. In order match the NULL value in the source child organization, the customer populates DEFECT_TRACKING_ON_FLAG with an '!' in the MTL_SYSTEM_ITEMS_INTERFACE TABLE.

INCOIN does not honor the '!' functionality to set the attribute to NULL Values. Instead it populates the attribute with an exclamation mark. '!'


EXPECTED BEHAVIOR
 
Expect that "!" will result in null values for DEFECT_TRACKING_ON_FLAG.



STEPS
 
The issue can be reproduced at will with the following steps:
1. Insert row into MTL_SYSTEM_ITEMS_INTERFACE where DEFAULT_TRACKING_ON_FLAG is populated with exclamation mark (!)
2. Execute Import Items
3. View results. DEFAULT_TRACKING_ON_FLAG is populated with ! in MTL_SYSTEM_ITEMS_B



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.