Static Driver Allocation with Add or Subtract Constant Produces Wrong Results (Doc ID 2255312.1)

Last updated on MAY 18, 2017

Applies to:

Oracle Financial Services Profitability Management - Version 8.0.2.0.4 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

On : 8.0.2.0.4 version, Calculation Engine

Static Driver allocation type with arithmetic operator '+' (add) or '-' (subtraction) of a constant value gives wrong results when the specifications of 'Source' tab does not fetch any record.

Steps:
1. Created a static driver allocation on Management Ledger on Current Amount
2. Specify criteria of Allocation source
3. In Operator choose Arithmetic operator '-'
    Specify a constant amount - 20000
4. Specify output - Management ledger and output dimension values

Data Criteria
Have records meeting the source specification for fiscal year - 2016 and fiscal month = 01 (only for fiscal month 01)

5. Execute this allocation for the month of 31 Aug 2016 - Results are incorrect

Expected result - no records to be produced (should produce 0 records)
Actual result - a record with <Entered_balance> of -20000

It produces the above wrong result for any month for that fiscal year(since there is no data for this source criteria except January).

6. Additional observation:
When the above rule is executed for a fiscal year where there is no data for the entire year the results are fine.


Cause

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