Updates to Orig System References from Customers Online Causes PARTY_ID COLUMN in HZ_ORIG_SYS_REFERENCES Table to be Null
Last updated on APRIL 21, 2017
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.
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