My Oracle Support Banner

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 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)


In Oracle Financial Services Profitability Management (PFT), 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":

  Loan Contracts.cap_instr_long
  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.


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

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