My Oracle Support Banner

Object Registration Failed - ORA-01400 Cannot Insert Null Into (REV_TAB_REF_CONSTRAINTS.CONSTRAINT_NAME) (Doc ID 2339356.1)

Last updated on AUGUST 19, 2020

Applies to:

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

Symptoms

On 8.0.4 version, when running model upload, the model upload is successful but Object Registration failed with below error:

Error:

MODEL UPLOAD COMPLETED AT Fri Dec 01 15:56:09 CST 2017
----------------------------------------------
OBJECT REGISTRATION STARTED AS PART OF MODEL UPLOAD AT Fri Dec 01 15:56:09 CST 2017
----------------------------------------------
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 Fri Dec 01 15:58:34 CST 2017 
 

Steps to Replicate:
1. Model upload was successful but noticed in custom instrument tables all the columns has the "DEFAULT NULL" option. Example:

    ACCRUAL_BASIS_CD NUMBER (5,0) DEFAULT NULL
    BREAKAGE_TYPE_CD NUMBER (5,0) DEFAULT NULL
    ACCOUNT_CONTRIB_AFTER_TAX NUMBER (14,2) DEFAULT NULL
    etc

2. Set default global setting in Erwin model properties:

   Model Properties: Default
   Non-Key Attributes Null Option: Not Null
   Non-Identifying Relationship Null Option: Nulls Allowed

3. Perform Model Upload and found error above on 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.