My Oracle Support Banner

Incorrect Results From Leaf Management Allocations for LAST_MO_AMOUNT in Different Fiscal Year (Doc ID 2663971.1)

Last updated on MAY 05, 2020

Applies to:

Oracle Financial Services Profitability Management - Version 8.0.6.1.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Profitability Management (PFT)
Oracle Financial Services Enterprise Performance Management (EPM)

Symptoms

On PFT 8.0.6.1.0, Leaf Management Ledger allocations which source previous period from previous fiscal year (i.e. Dec 2020) and driver for current period (i.e. Jan 2021) output incorrect results for the current period. The same allocations give expected results if the previous and current periods are in the same fiscal year.  This issue only appeared after using the solution from Document 2587131.1 Field Allocation Wiht Zero Driver Does Not Produce Result

The issue can be reproduced at will with the following steps.
1. Load records for two periods into FSI_D_MANAGEMENT_LEDGER
2. Create leaf allocation with Source: Management Ledger <[Last Mo Amount]> and Driver Management Ledger <[Current Amount]>. Credit to Management Ledger <[Current Amount]>
3. Run allocation for current period and check results

SOURCE ROWS:

FINANCIAL_ELEM_ID  IDENTITY_CODE FISCAL_MONTH FISCAL_YEAR AS_OF_DATE PRODUCT_ID  ENTERED_BALANCE
100 999999 12 2020 31-Dec-20 502 1000
100 999999 12 2020 31-Dec-20 501 100
100 999999 1 2021 31-Jan-21 503 500
100 999999 1 2021 31-Jan-21 501 50

GENERATED ROWS:

FINANCIAL_ELEM_ID  IDENTITY_CODE FISCAL_MONTH FISCAL_YEAR AS_OF_DATE PRODUCT_ID  ENTERED_BALANCE
30150 362 1 2021 31-Jan-21 501 50
30150 362 1 2021 31-Jan-21 503 500


EXPECTED RESULTS:

FINANCIAL_ELEM_ID  IDENTITY_CODE FISCAL_MONTH FISCAL_YEAR AS_OF_DATE PRODUCT_ID  ENTERED_BALANCE EXPECTED CALC (CUR_MO - LAST_MO)
30150 362 1 2021 31-Jan-21 501 -50 (50-100)
30150 362 1 2021 31-Jan-21 502 -1000 (0-1000)
30150 362 1 2021 31-Jan-21 503 500 (500-0)

Cause

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.