HZ_CUST_ACCOUNT_SITE_V2PUB.create_cust_site_use Allows Entry of Duplicate ORIG_SYSTEM_REFERENCE Values (Doc ID 2294038.1)

Last updated on MARCH 09, 2023

Applies to:

Symptoms

On : 12.1.3 version, APIs

ACTUAL BEHAVIOR
---------------
hz_cust_account_site_v2pub.create_cust_site_use allows duplicate ORIG_SYSTEM_REFERENCE

EXPECTED BEHAVIOR
-----------------------
hz_cust_account_site_v2pub.create_cust_site_use should NOT allow duplicate ORIG_SYSTEM_REFERENCE

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

SQL> select text from dba_source where line=2 and name='HZ_CUST_ACCOUNT_SITE_V2PUB';

TEXT
--------------------------------------------------------------------------------
/*$Header: ARH2CSSS.pls 120.10 2006/08/17 10:16:59 idali ship $ */
/*$Header: ARH2CSSB.pls 120.41.12010000.13 2015/08/25 08:24:54 nsinghai ship $ */

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users run into the problem documented in
Customer Form Error: You cannot update the value because more than one ID exists for the source system reference. Column: orig_system+orig_system_reference (Doc ID 1357137.1)

Changes

Cause

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