HZ_CUST_ACCOUNT_SITE_V2PUB.create_cust_site_use Allows Duplicate ORIG_SYSTEM_REFERENCE (Doc ID 2294038.1)

Last updated on AUGUST 04, 2017

Applies to:

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

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)

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