The combination of columns CUST_SITEUSE_ORIG_SYSTEM and CUST_SITEUSE_ORIG_SYS_REF must be unique in table HZ_IMP_ACCTSITEUSES_T

(Doc ID 2372305.1)

Last updated on MARCH 12, 2018

Applies to:

Oracle Fusion Receivables Cloud Service - Version 11.13.17.09.0 and later
Information in this document applies to any platform.

Goal

Error massage for SHIP_TO site purpose line: "The combination of columns SITEUSE_ORIG_SYSTEM and SITEUSE_ORIG_SYSTEM_REF must be unique in table HZ_IMP_PARTYSITEUSES_T."

It is asking for unique name which is not possible because our requirement is to create additional site purpose for a single customer site.

If we create new SITEUSE_ORIG_SYSTEM, SITEUSE_ORIG_SYSTEM_REF, then, we have to create new customer (i.e. not our requirement).

In addition, when we create SHIP_TO site purpose for a single customer site manually, system ask for the attribute "Bill to site" which is not available in the template.

 

Solution

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