My Oracle Support Banner

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.


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

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);


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.