My Oracle Support Banner

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

Last updated on MARCH 18, 2019

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.
Checked for relevance on 01-Jul-2012.


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.

Steps to Replicate:

  1. Create a user defined dimension with DIMENSION_TYPE_CODE = 'OTHER'
  2. Add dimension values to the user defined dimension in Master Maintenance > Dimension Management > Members
  3. Review the values in the FEM_xxxxxx_B and FEM_xxxxxx_TL tables
  4. Run the Reverse Populate function fsi_batchMemberLoad
  5. Check for the user defined dimension values in OFSA_LEAF_DESC and OFSA_DETAIL_OTHER_COA.

No rows exist in OFSA_LEAF_DESC and OFSA_DETAIL_OTHER_COA for the user defined dimension.




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.