My Oracle Support Banner

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 JUNE 25, 2018

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.


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

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

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)

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).


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps

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