Ledger Stat Allocation Calculating YTD Incorrectly for Average Balance (FE 140)
(Doc ID 310790.1)
Last updated on MARCH 22, 2019
Applies to:Oracle Profitability Manager - Version 4.5 to 4.5.39 [Release 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 (Year To Date) 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;
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