R12 - RACUST Errors 'Customer Record For Insert Must Have Validated Profile Record Defined in RA_CUSTOMER_PROFILES_INTERFACE table' (Doc ID 577294.1)

Last updated on JULY 12, 2017

Applies to:

Oracle Trading Community - Version 12.0.4 and later
Information in this document applies to any platform.
RACUST - Customer Interface


Symptoms

When attempting to run Customer Interface in R12 instance, the following error occurs in the Customer Interface Transfer Report:

ERROR
Customer record for insert must have validated profile record defined in the RA_CUSTOMER_PROFILES_INTERFACE table.

If inserting the data into RA_CUSTOMER_PROFILES_INTERFACE table, then the following error is received:


Error: ORA-28115
Text: policy with check option violation
---------------------------------------------------------------------------
Cause: Policy predicate was evaluated to FALSE with the updated values.


 

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