Receivables Customer UI Does Not Allow Duplicate Orig_system_reference Created For Customer Site (Doc ID 2301907.1)

Last updated on AUGUST 29, 2017

Applies to:

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

Symptoms

On : 12.1.3 version, Customers Module

When attempting to create a customer site using the existing Reference Number, the following error occurs.

ERROR
-----------------------
Error
Value for orig_system_reference must be unique.

NOTE:
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




STEPS
-----------------------
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

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