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:

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

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