My Oracle Support Banner

Object Registration Fails With 'ORA-00001: unique constraint (PK_REV_TAB_REF_CONSTRAINTS) violated' and Several Tables Have Duplicate FKs (Doc ID 2770629.1)

Last updated on MAY 03, 2021

Applies to:

Oracle Financial Services Funds Transfer Pricing - Version 8.0.0 and later
Oracle Financial Services Asset Liability Management - Version 8.0.0 and later
Oracle Financial Services Profitability Management - Version 8.0.0 and later
Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

After merging a new data model with your custom data model, you get the following error during the Object Registration step of the Model Upload process:

Error while executing the query Failed Executing Batch: error occurred during batching: ORA-00001: unique constraint (<ATOMIC SCHEMA>.PK_REV_TAB_REF_CONSTRAINTS) violated

If you disable the constraints to identify objects with the issue as described in Document 2544868.1, there are one or two tables getting duplicate foreign key constraints assigned to them.

Example:

TABLE - FOREIGN KEY CONSTRAINT - PARENT TABLE
FCT_TRANSACTION_SUMMARY - FK_1972_5 - DIM_CUSTOMER
FCT_TRANSACTION_SUMMARY - FK_1972_5 - DIM_CUSTOMER
FCT_COMMON_ACCOUNT_SUMMARY - FK_181_30 - DIM_ORG_STRUCTURE
FCT_COMMON_ACCOUNT_SUMMARY - FK_181_30 - DIM_ORG_STRUCTURE
FCT_COMMON_ACCOUNT_SUMMARY - FK_181_30 - DIM_ORG_STRUCTURE

These duplicates prevent you from completing the Object Registration.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.