Incorrect Aggregation Method Attributes Assigned While Creating or Editing Financial Element Dimension Members (Doc ID 1645304.1)

Last updated on DECEMBER 08, 2015

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.3.2 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Oracle Financial Services Analytical Applications (OFSAA)
Reverse Population

Symptoms

On OFSAAI 7.3.2/6.0, when creating a new Financial Element dimension member or editing an existing member, it appears that the reverse population is choosing an incorrect AGGREGATE METHOD in OFSA_DETAIL_ELEM_B.

ACTUAL BEHAVIOR
When defining a new MEMBER or EDITing an existing MEMBER for Financial Element Dimension, selecting AGGREGATE_METHOD as 'ADD'. However, the reverse population is inserting the value as 0 instead of 100 in OFSA_DETAIL_ELEM_B table for that LEAF_NODE. Correct attribute value is being written to DIM_FINANCIAL_ELEM_ATTR.

EXPECTED BEHAVIOR
Expect values in DIM_FINANCIAL_ELEM_ATTR to be correctly populated to the Reverse Population table: OFSA_DETAIL_ELEM_B.

When running reverse population function manually all AGGREGATE_METHOD in OFSA_DETAIL_ELEM_B for all financial elements gets updated to 0.

Steps to reproduce
The issue can be reproduced at will with the following steps:

1. Create a new MEMBER or EDITing an existing MEMBER for Financial Element Dimension, selecting AGGREGATE_METHOD as 'ADD'
2. Save
3. Check DIM_FINANCIAL_ELEM_ATTR and find correct aggregate method specified, check OFSA_DETAIL_ELEM_B and find incorrect values

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