After Patch 19971487, No Time Stamp Added to Hz_cust_acct_sites_all.orig_system_reference When Using the Duplicate Value for System Reference via TCA API hz_cust_account_site_v2pub.create_cust_acct_site (Doc ID 2023670.1)

Last updated on OCTOBER 20, 2016

Applies to:

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

Symptoms

On : 12.2.3 version, APIs

When attempting to create customer site using existing orig_system_reference
the following error occurs.

ERROR
-----------------------
Value for orig_system_reference must be unique.


The system should add the time stamp to the existing orig_system_reference
when multiple_flag in table HZ_ORIG_SYS_MAPPING is set to Y

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Using TCA API hz_cust_account_site_v2pub.create_cust_acct_site
to create a customer site using existing orig_system_reference value

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot use the same value for the orig_system_reference

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