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