Customer Interface Exception: "Customer record for insert must have validated profile record defined in the RA_CUSTOMER_PROFILES_INTERFACE table"
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.
Customer Interface (RACUST) fails with message:
Customer record for insert must have validated profile record defined in the RA_CUSTOMER_PROFILES_INTERFACE table.
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:
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,
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