No Attributes Listed for User Defined Dimension After Leaf Registration

(Doc ID 1484795.1)

Last updated on JULY 28, 2017

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 Service Analytical Applications (OFSAA), a custom / user defined dimension to be used as the "product" in ALM or FTP does not have any attributes after registering it using the Leaf Registration procedure.  When you create or view a dimension member value, there are no attributes listed under "Member Attributes".  They are missing.

Additionally, there are no rows in REV_DIM_ATTRIBUTES_B and REV_DIM_ATTRIBUTES_TL for the dimension's DIMENSION_ID value. 

As a result of this issue, the dimension's values cannot be assigned an appropriate Account Type value.  The Account Type is usually assigned through the an attribute called "COMMON COA ID".  The dimension values are assigned the same Account Type as the referenced COMMON_COA_ID.

Steps to Reproduce:

  1. Go to Master Maintenance > Dimension Management > Member
  2. Select the dimension
  3. Create or edit a member

No attributes are listed on the member definition screen.

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