OFSA 4.5 Leaf Column Is Not Registered As FDM Data Type='LEAF' Error During Leaf Registration of Key Leaf
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:
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);
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