Ledger Stat Allocation Calculating YTD Incorrectly for Average Balance (FE 140) (Doc ID 310790.1)

Last updated on FEBRUARY 17, 2017

Applies to:

Oracle Profitability Manager - Version: 4.5 to 4.5.39 - Release: 4.5 to 4.5
Information in this document applies to any platform.
Oracle Financial Services Applications (OFSA) 4.5
Oracle Performance Analyzer 4.5
Checked for relevance on 14-Jan-2010.

Symptoms

In Oracle Performance Analyzer (PA) 4.5, an instrument table to LEDGER_STAT table allocation is calculating the YTD balances outputted to LEDGER_STAT incorrectly for the Average Balance Financial Element (FE 140).  The Aggregation Method for FE 140 is currently set to 110 (Average by Days Weighted) in the OFSA_DETAIL_ELEM view but the YTD results do not match the Average by Days Weighted calculation.

The Fiscal Year does not begin in January.
(START_MONTH <> 1 in OFSA_FISCAL_YEAR_INFO)

The WEIGHTING_FE column in OFSA_DETAIL_ELEM is currently set to a not null value for FE 140 and the following query returns one row:

select * from ofsa_detail_elem where leaf_node = 140 and weighting_fe is not null;

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