OFSA 4.5 Leaf Column Is Not Registered As FDM Data Type='LEAF' Error During Leaf Registration of Key Leaf (Doc ID 352706.1)

Last updated on JULY 28, 2017

Applies to:

Oracle Financial Data Manager - Version 4.5.39 to 4.5.41
Information in this document applies to any platform.
Oracle Risk Manager - Version: 4.5.39
Oracle Financial Services Applications (OFSA) - Version 4.5
Note: All OFSA 4.5 products have reached sustaining support.

Symptoms

On OFSA 4.5.39 when attempting to register a leaf field the following error occurs:

ERROR
Registration Error

Leaf column registration failed.

The Leaf column is not registered as FDM Data Type='LEAF' on tales of the following Table
Classifications 50, 200, 210, 300, 310, 350, 360, 370.

The issue can be reproduced at will with the following steps:
1. Login to Financial Data Manager Administration
2. FDM Objects
3. Register new key leaf

The following query referenced from the Oracle Financial Services Installation and Configuration Guide, Release 4.5, Page 17-8: Leaf Column is not registered as FDM Data Type LEAF returns no rows:

For B (All) Leaves:
    select table_name from ofsa_table_class_assignment
    where table_classification_cd in (50, 200, 210, 300, 310, 351, 360, 370)
    and table_name not in (select table_name from ofsa_tab_columns
    where column_name = <leaf_column_name>
    and ofsa_data_type_cd = 10);

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