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

(Doc ID 2339356.1)

Last updated on DECEMBER 18, 2017

Applies to:

Oracle Financial Services Funds Transfer Pricing - Version 8.0.4 and later
Oracle Financial Services Profitability Management - Version 8.0.4 and later
Oracle Financial Services Asset Liability Management - 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, Install and Upgrade Issues

When running model upload, the model upload is successful but Object Registration failed with below error:

Error:


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.

Changes

 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms