Customer Interface is Importing Duplicate Customer Account Reference or Address Reference with a Timestamp, Instead of Error or Warning (Doc ID 1904172.1)

Last updated on JULY 31, 2017

Applies to:

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

Symptoms

Release 12.1.3

You are using Customer Interface to import Customer data and are able to update another record in the UI with the same orig_system_refrerence (HZ_CUST_ACCT_SITES_ALL.orig_system_reference) without error.

The system should not allow duplicates to be created, but saves with same orig_system_reference and with a timestamp.

For Example:
1. Company ABC Operations Limited
Account_number 64210

HZ_CUST_ACCT_SITES_ALL
CUST_ACCT_SITE_ID CUST_ACCOUNT_ID PARTY_SITE_ID
90081 462829 1125642

Currently has the Orig_system_reference  = E00086A15 <--- NOTE:  E00086A15

2. Now go into another customer and enter the same orig system reference
Example:

Company DEF Operations Limited
party_id 1368053
account_number 78359

and enter the same orig_system_reference E00086A15 (This was used for Company ABC Operations Limited above #1)

HZ_CUST_ACCT_SITES_ALL
CUST_ACCT_SITE_ID CUST_ACCOUNT_ID PARTY_SITE_ID
118066 495678 1172347

Orig_system_reference = E00086A15#@18-APR-2013 11:02:20 <--- Notice how it is appended. (You do not want this)

The system should give a warning that this orig_system_reference is already in use.

If you create a new customer in the UI and then add another customer, with the same HZ_CUST_ACCT_SITES_ALL.Orig_system_reference, the system will not allow the same.
The system will warn you, in the front end of the application, since HZ_ORIG_SYS_MAPPING by updating the multiple_flag to N (N indicates to not allow duplicate 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