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