Object Registration Failed - ORA-01400 Cannot Insert Null Into (REV_TAB_REF_CONSTRAINTS.CONSTRAINT_NAME)
(Doc ID 2339356.1)
Last updated on SEPTEMBER 12, 2023
Applies to:
Oracle Financial Services Asset Liability Management - Version 8.0.4 and laterOracle 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.
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 |