Cannot Change a Dimension Member from Leaf to Non-Leaf - Option is Disabled

(Doc ID 1459145.1)

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)

Symptoms

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:

  1. Populate the STG_<dimension>_x_INTF tables (Set V_LEAF_ONLY_FLAG = 'Y')
  2. Run fn_drmDataLoader to load the dimension members
  3. Go to Master Maintenance
  4. Go to Dimension Management > Members
  5. Search for a the loaded dimension member
  6. Edit

The "Is Leaf" option is greyed out.

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