My Oracle Support Banner

Updates to Orig System References from Customers Online Causes PARTY_ID COLUMN in HZ_ORIG_SYS_REFERENCES Table to be Null (Doc ID 1177306.1)

Last updated on JULY 10, 2020

Applies to:

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


Oracle Customers Online Source Systems screen allows updates to the Orig System Reference (OSR) records when the profile option "HZ: Source System Mapping Access" is set as "Create and Update".
When the OSR records are updated from this screen, it properly inactivates the current one and creates a new OSR record with Active status, but the PARTY_ID on the new record is incorrectly set to NULL.

This NULL PARTY_ID causes issues at multiple places wherever the PARTY_ID is referenced from the HZ_ORIG_SYS_REFERENCES table.


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
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps

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