My Oracle Support Banner

Incorrect Results for 'Simple' Dynamic Driver Ledger Stat Allocation with Expression in Driver (Doc ID 2247749.1)

Last updated on APRIL 14, 2017

Applies to:

Oracle Financial Services Profitability Management - Version 6.1.1.1 and later
Information 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!

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