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)
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:
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
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.
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