Customer Interface Exception: "Customer record for insert must have validated profile record defined in the RA_CUSTOMER_PROFILES_INTERFACE table" (Doc ID 1319755.1)

Last updated on JULY 12, 2017

Applies to:

Oracle Trading Community - Version 12 to 12 [Release 12]
Information in this document applies to any platform.

Symptoms


Customer Interface (RACUST) fails with message:

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

Changes

This issue happens in R12, and not in R11i.

This is due to unpublished Bug 4425217 - R12-MOAC: SCRIPT REVIEW MODIFY EXISTING RECORDS IN RA_CUSTOMERS_INTERFACE_ALL:

"REQUIREMENT:
As part of MOAC changes we have to make the org_id column as NOT NULL
that was previously null in these 'Customer Interface'
interface tables: RA_CUSTOMERS_INTERFACE_ALL,
RA_CUSTOMER_PROFILES_INT_ALL,
RA_CONTACT_PHONES_INT_ALL,
RA_CUSTOMER_BANKS_INT_ALL,
RA_CUST_PAY_METHOD_INT_ALL
"

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