Undo of a Prior Month Allocation Changes All Later YTD Columns to Zero (Doc ID 1282514.1)

Last updated on JANUARY 23, 2011

Applies to:

Oracle Profitability Manager - Version: 4.5.39 and later   [Release: 4.5 and later ]
Oracle Financial Data Manager - Version: 4.5.39 and later    [Release: 4.5 and later]
Information in this document applies to any platform.
Oracle Financial Services Applications (OFSA) 4.5
Oracle Performance Analyzer - Version: 4.5.39

Symptoms

In Oracle Performance Analyzer (PA) 4.5, you have balances in LEDGER_STAT for MONTH_01 through MONTH_12 and YTD_01 through YTD_12.  After a re-statement is made, you need to re-run an Allocation calculation for a prior month (ex. March, MONTH_03/YTD_03).  However, when you undo the Allocation and re-run the Allocation for that month, you see that all YTD columns after that month (ex. after March) are set to zero after the undo.  The YTD columns after that month (ex. YTD_04, YTD_05, YTD_06, etc.) are not re-populated when the allocation is re-run.  As a result, all of the later YTD columns are 0 when they need to contain valid YTD values.

Example:

Before running Undo on March:

YTD_03
YTD_04
YTD_05
YTD_06
YTD_07
110.00
150.00
175.00
180.00
210.00


Undo is run for Allocation for March:

YTD_03
YTD_04
YTD_05
YTD_06
YTD_07
0
0
0
0
0


After backdated re-run of Allocation for March after re-statement:

YTD_03
YTD_04
YTD_05
YTD_06
YTD_07
135.00
0
0
0
0


After the allocation is re-run, you expect to have valid balances in YTD_04, YTD_05, YTD_06, YTD_07, etc.

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