Receivables Customer UI Does Not Allow Duplicate Orig_system_reference Created For Customer Site
(Doc ID 2301907.1)
Last updated on FEBRUARY 18, 2019
Applies to:Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.
On : 12.1.3 version, Customers Module
When attempting to create a customer site using the existing Reference Number, the following error occurs.
Value for orig_system_reference must be unique.
Per Bug 26558634, The TCA API Validation is all depend on mapping values. Review HZ_ORIG_SYS_MAPPING table data for owner_table_name = 'HZ_CUST_SITE_USES_ALL'.
If multiple_flag is 'Y' then system will allow duplicate orig_system_reference values.
This validation does NOT work from UI:
HZ_ORIG_SYS_MAPPING.MULTIPLE_FLAG is set to Y
The issue can be reproduced at will with the following steps:
1. Query up a customer in Receivables
2. This customer already has sites exist, using one of the existing reference number to create a new site
3. The system errors
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