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 FEBRUARY 03, 2019

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

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
Changes
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.