Incorrect Results for 'Simple' Dynamic Driver Ledger Stat Allocation with Expression in Driver
(Doc ID 2247749.1)
Last updated on MARCH 27, 2019
Applies to:
Oracle Financial Services Profitability Management - Version 6.1.1.1 and laterInformation in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Symptoms
In Oracle Financial Services Profitability Management (PFT) 6.1.1.1, 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":
Sum(
ABS(
Loan Contracts.cap_instr_long
)
+
ABS(
Loan Contracts.cap_instr_short
)
)
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.
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 |