Object Registration Failed With Table Leaf Column Is Missing or Incorrectly Registered
(Doc ID 1599964.1)
Last updated on DECEMBER 06, 2022
Applies to:
Oracle Financial Services Profitability Management - Version 6.0 and laterOracle Financial Services Asset Liability Management - Version 6.0 and later
Oracle Financial Services Analytical Applications Infrastructure - Version 7.3.2 and later
Oracle Financial Services Funds Transfer Pricing - Version 5.2.2 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Symptoms
When attempting to complete Instrument Table Validation - Batch_Table_Class_Req, the process failed with the following errors.
Error:
FAILED: Table FSI_D_MORTGAGES. Leaf Column "ACC_CLASS_ID" missing or incorrectly registered. Data Type must be NUMBER and FDM Data Type must be LEAF
FAILED: Table FSI_D_MM_CONTRACTS. Leaf Column "ACC_CLASS_ID" missing or incorrectly registered. Data Type must be NUMBER and FDM Data Type must be LEAF
FAILED: Table FSI_D_MM_CONTRACTS. Leaf Column "ACC_CLASS_ID" missing or incorrectly registered. Data Type must be NUMBER and FDM Data Type must be LEAF
..etc
Steps:
1. Add ACC_CLASS_ID dimension in Erwin.
2. Perform model upload successfully.
3. Run Instrument Table Validation - Batch_Table_Class_Req and the process gave the above error.
4. Check Erwin Model Naming Options --> for Object Type Case and acc_class_id is in lower case.
Changes
Add a new dimension in Erwin data model.
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 |