My Oracle Support Banner

TCA: The Value for SITE_USE_ID in the Tables AR_CUSTOMER_PROFILES and AR_CUST_PROFILE_AMTS is INVALID (Doc ID 871233.1)

Last updated on OCTOBER 13, 2022

Applies to:

Oracle Trading Community - Version 11.5.10 and later
Oracle Receivables - Version 11.5.10.0 and later
Information in this document applies to any platform.

Symptoms

Account Profiles ( HZ_CUSTOMER_PROFILES and HZ_CUST_PROFILE_AMTS)  may be assigned to only three different site uses (SITE_USE_CODE).
Incorrect billing or other errors may occur if the value in HZ_CUSTOMER_PROFILES.SITE_USE_ID does not belong to a correct site use (HZ_CUST_SITE_USES_ALL.SITE_USE_CODE) value. 

The site uses (SITE_USE_CODE) allowed to have an account profile associated with the address are Bill To, Statements, and Marketing.    (BILL_TO, STMTS, MARKET)

An example of a problem that can occur because of a profile existing with an invalid valid for site use is a credit check at customer site level not working because the value in HZ_CUSTOMER_PROFILES.SITE_USE_ID is associated
to a DUNNING site use.   

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.