My Oracle Support Banner

Object Registration Fails with 'ORA-00001: unique constraint (<atomic>.PK_REV_TAB_REF_CONSTRAINTS) violated' (Doc ID 2544868.1)

Last updated on FEBRUARY 12, 2021

Applies to:

Oracle Financial Services Data Foundation - Version 8.0.7 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

For Oracle Financial Services Data Foundation (FSDF) 8.0.7.1, when attempting to upload the data model, the model upload is successful but the Object Registration fails with the following error:

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

Object Registration Failed.
Object Registration Failed.
java.lang.Exception: Error while Executing queries for Object Registration----------------------------------------------

As a result of this error, the data model metadata is not inserted completely.

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.