My Oracle Support Banner

8.0.2 OFSAA Model Object Registration Fails with ORA-01400: cannot insert NULL into ("<atomic>"."REV_TAB_REF_CONSTRAINTS"."CONSTRAINT_NAME") (Doc ID 2715507.1)

Last updated on OCTOBER 14, 2020

Applies to:

Oracle Financial Services Funds Transfer Pricing - Version 8.0.2 to 8.0.2 [Release 8]
Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.2 to 8.0.2 [Release 8]
Oracle Financial Services Asset Liability Management - Version 8.0.2 to 8.0.2 [Release 8]
Oracle Financial Services Profitability Management - Version 8.0.2 to 8.0.2 [Release 8]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)

Symptoms

When attempting to upload the data model in the an environment, the model upload completes successfully but the Object Registration fails.  The error below is in the Model Upload log in /<ftpshare>/<infodom>/logs:

----------------------------------------------
OBJECT REGISTRATION STARTED AS PART OF MODEL UPLOAD AT Wed Jul 29 16:21:32 PDT 2020
----------------------------------------------
Error while executing the query Failed Executing Batch: error occurred during batching: ORA-01400: cannot insert NULL into ("<atomic>"."REV_TAB_REF_CONSTRAINTS"."CONSTRAINT_NAME")

Object Registration Failed.
Object Registration Failed.
java.lang.Exception: Error while Executing queries for Object Registration----------------------------------------------
OBJECT REGISTRATION COMPLETED AT Wed Jul 29 16:28:31 PDT 2020
----------------------------------------------

As a result, you cannot complete the model upload process.

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.