My Oracle Support Banner

Reverse Population Not Working for User Defined Dimension (Doc ID 1272904.1)

Last updated on MARCH 31, 2021

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.1 to 7.2.3 [Release 7]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA) - Version 5.1 thru 5.2.0.


In Oracle Financial Services Analytical Applications (OFSAA) Infrastructure 7.1, Reverse Population does not work for user defined dimensions (leaf) with a DIMENSION_TYPE_CODE of "OTHER" in REV_DIMENSIONS_B.  After creating the user defined dimension with a DIMENSION_TYPE_CODE of "OTHER" and entering dimension values in Dimension Management, you run the fsi_batchMemberLoad function (Batch_Member_Load) to execute Reverse Population.  The function executes successfully.  Example:

SQL> set serveroutput on
SQL> Declare
2 num number;
3 Begin
4 num := fsi_batchMemberLoad('REVERSE_POP_20100812_1', '20100812',655,null,1);
5 End;
6 /

PL/SQL procedure successfully completed.

However, when you check OFSA_LEAF_DESC and OFSA_DETAIL_OTHER_COA, there are no rows inserted into the tables for the user defined dimension.  Rows do exist in the DIM_xxxxxx_B and DIM_xxxxxx_TL tables.


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.