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


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

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.



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