Cannot Change a Dimension Member from Leaf to Non-Leaf - Option is Disabled
Last updated on AUGUST 19, 2015
Applies to:Oracle Financial Services Analytical Applications Infrastructure - Version 7.2 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
In Oracle Financial Services Analytical Applications (OFSAA) infrastructure, after you load a new member into a dimension using the fn_drmDataLoader program and the STG_tables, you cannot change the member from a Leaf to a non-Leaf. When you go to Dimension Management > Members and edit the dimension member, you cannot change the "Is Leaf" setting to "No". This option is disabled.
If you create a new dimension member using the interface, you can change the member from a Leaf to a non-Leaf successfully. The issue only occurs for members created using the staging tables.
Steps to Reproduce:
- Populate the STG_<dimension>_x_INTF tables (Set V_LEAF_ONLY_FLAG = 'Y')
- Run fn_drmDataLoader to load the dimension members
- Go to Master Maintenance
- Go to Dimension Management > Members
- Search for a the loaded dimension member
The "Is Leaf" option is greyed out.
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