Ledger Stat Allocation Calculating YTD Incorrectly for Average Balance (FE 140)
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.
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;
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