E.4 Using the Undo Function with a Fiscal Year Configuration

The allocation UNDO function removes the results of allocations from the Management Ledger table. The database function that operates against may be either an UPDATE or a DELETE. In other words, the UNDO function operates as follows:

• Examine each row generated by the allocation rule a specific month of which we intend to UNDO.
• For each row, determine how many MTD columns in months other than the month currently being UNDONE contain non-zero values.
• If the answer is zero, delete the row. If the answer is not zero, update the MTD column that is to be UNDONE with a value of zero and re-set all YTD columns in the fiscal period of the month we are UNDOING.

Examples:

The following examples assume you have run an allocation rule that posts data to the Management Ledger for January, February, and March. When you perform an UNDO operation on the March execution:

• • For any row in which either the January MTD column or the February MTD column contains a non-zero value.
  • The engine updates the March MTD column with a value of zero.
  • The engine re-sets (update) the YTD columns for each YTD column within the fiscal period of the month being UNDONE.
• The engine deletes any row in which neither the January MTD column nor the February MTD column contains a non-zero value.

With a Calendar Year configuration or with a Fiscal Year configuration, the re-setting of the YTD columns will affect all 12 YTD columns. However, with a Fiscal Period configuration (a configuration in which the Fiscal Period column in FSI_FISCAL_YEAR_INFO/ LEDGER_CCY_AND_FISCAL_YR_INFO is set to 1, 2, 3, 4, or 6), the re-setting of YTD columns only affects the YTD columns. This falls within the same fiscal period as the month of the allocation that is being UNDONE.