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 OCTOBER 13, 2022
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,
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!