My Oracle Support Banner

No Attributes Listed for User Defined Dimension After Leaf Registration (Doc ID 1484795.1)

Last updated on APRIL 26, 2023

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 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.


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.