Incorrect Results for 'Simple' Dynamic Driver Ledger Stat Allocation with Expression in Driver
Last updated on APRIL 14, 2017
Applies to:Oracle Financial Services Profitability Management - Version 18.104.22.168 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
In Oracle Financial Services Profitability Management (PFT) 22.214.171.124, when you create a Dynamic Driver Allocation which uses Ledger Stat as the source and target and uses an Expression on an instrument table as the driver, the Allocation engine generates the wrong code which results in too many records being output.
The Expression used in the driver performs a calculation using "SUM":
But Allocation creates the following code for the Expression:
SELECT (Sum(Abs(NVL(a.cap_instr_long, 0))+
Abs(NVL(a.cap_instr_short, 0))) over())ColVal , (1)mTotal
This code results in the source balance being multiplied by all records in the driver resulting in 125 records being output which is incorrect. You expect only one record as the output.
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