My Oracle Support Banner

Unable To Import a NULL Value Using TCA Bulk Import (Doc ID 1487226.1)

Last updated on MAY 31, 2019

Applies to:

Oracle Trading Community - Version 12.0 and later
Information in this document applies to any platform.

Symptoms

Attempting to update a value, such as KNOWN_AS or ATTRIBUTE2 to NULL by using the interface table (HZ_IMP_PARTIES_INT) and find the value is it is not getting replaced by NULL.
When the value is replaced with another value, the change takes place properly.

Is there any approach to update to NULL using the interface table or API usage is the only solution?

Changes

 

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
Changes
Cause
Solution
 1. Bug Summary
 2. Fixed File(s)
 3. Recommended Patch(es)
 4. Solution Steps
 5. After Applying the Patch, Instead of Using NULL As a Value, Use a '!'
 6. Run TCA Bulk Import again
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.