Static Table Driver Allocation Outputs Unnecessary and Excessive Zero Rows
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)
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms