My Oracle Support Banner

Entered Balance And Functional Balance Values Are Reversed For PFT Static Driver Allocation Where Expression Is Used In Source (Doc ID 2957266.1)

Last updated on JUNE 26, 2023

Applies to:

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

Symptoms

On PFT 8.0.7 version, when running Static Driver Allocation rule having Source as Portfolio table wherein expression is also used, values for Functional Balance and Entered Balance columns are reversed in the obtained results.

Example of fsi_d_management_ledger output showing such incorrect balances:

FINANCIAL_ELEM_ID PRODUCT_ID ISO_CURRENCY_CD BALANCE_TYPE_CD ENTERED_BALANCE FUNCTIONAL_BALANCE
170 1000001 USD 101 200 200
170 1000001 AUD 101 2000 200
170 1000001 LBP 101 316000 200
170 1000001 EUR 101 400 200
170 1000001 AUD 102 -2000 -200
170 1000001 LBP 102 -316000 -200
170 1000001 EUR 102 -400 -200
170 1000001 USD 102 -200 -200

 

These values are not reversed when you use a column instead of expression, in the Source tab of the same allocation.

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.