Static Table Driver Allocation Outputs Unnecessary and Excessive Zero Rows (Doc ID 1564090.1)

Last updated on NOVEMBER 08, 2016

Applies to:

Oracle Financial Services Profitability Management - Version 5.2 to 6.1 [Release 5 to 6]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

In Oracle Financial Services Profitability Management (PFT), a Static Table Driver Allocation that moves balances from an instrument table to LEDGER_STAT and from one product to another product is outputting zero balance rows in addition to the correct Static Table Driver output rows.

For example, the Static Table Driver outputs balances to a new Product ID using a coefficient of 1:

Product Node 1 is mapped to Product 4001 with a coefficient of 1.
Product Node 2 is mapped to Product 4002 with a coefficient of 1.
Product Node 3 is mapped to Product 4003 with a coefficient of 1.
Product Node 4 is mapped to Product 4004 with a coefficient of 1.

For a source Product ID that exists under "Product Node 1", the following Product rows are output:

4001 = 1945.86
4002 = 0
4003 = 0
4004 = 0

You only expect it to output the one row with Product 4001 = 1945.86.  The Allocation should not be outputting the additional 0 balance rows.

Steps to Reproduce:

1. Go to Profitability Management
2. Go to Rule Specification > Static Table Driver
3. Create a Static Table Driver with a Source dimension of Product ID and a Target dimension of Product ID.

Map each source Product to a different target product. Use a coefficient of 1.

4. Go to Rule Specification > Allocation Specification
5. Create a Static Table Driver Allocation with the Static Table Driver created in Step 3.
6. Execute the Allocation

Rows are output to LEDGER_STAT with 0 balances in addition to the correct output.

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