Object Registration Failed With Table Leaf Column Is Missing or Incorrectly Registered (Doc ID 1599964.1)

Last updated on JULY 20, 2017

Applies to:

Oracle Financial Services Asset Liability Management - Version 6.0 and later
Oracle Financial Services Funds Transfer Pricing - Version 5.2.2 and later
Oracle Financial Services Profitability Management - Version 6.0 and later
Oracle Financial Services Analytical Applications Infrastructure - Version 7.3.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

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