Receivables Customer UI Does Not Allow Duplicate Orig_system_reference Created For Customer Site
Last updated on AUGUST 29, 2017
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
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