PFT Null Balance Output From Allocation Which Output in Instrument Table (Doc ID 1414886.1)

Last updated on FEBRUARY 15, 2012

Applies to:

Oracle Financial Services Profitability Management - Version: 5.6 and later   [Release: 5 and later ]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI) - Version 7.2
Oracle Financial Services Analytical Applications (OFSAA) - Version 5.x
OFSPM

Symptoms

On Oracle Financial Services Profitability Management (PFT) 5.6, a dynamic driver percent distribution ledger to instrument allocation does not produce the correct results.  Null balances are being output to the target instrument column.

ACTUAL BEHAVIOR
Generated MERGE QUERY SQL is causing output of null balances to the target instrument column:


Module Logging OFS Access module data: MERGE INTO RI_ACCT TARGET USING (SELECT SUM
(IVW_SOURCE.IVW_TARGET_AMOUNT) TARGET_AMOUNT , IDENTITY_CODE,
ID_NUMBER
FROM (
SELECT ( Src.SOURCE_AMOUNT * Drv.drv_factor) IVW_TARGET_AMOUNT ,
Drv.IDENTITY_CODE , Drv.ID_NUMBER
FROM (SELECT SUM(DECODE(a.year_s, 2010, a.month_08, 0) )
. . .
WHERE IVW_TARGET_AMOUNT <> 0
GROUP BY IDENTITY_CODE , ID_NUMBER ) SOURCE ON
(SOURCE.IDENTITY_CODE = TARGET.IDENTITY_CODE
AND SOURCE.ID_NUMBER = TARGET.ID_NUMBER ) WHEN MATCHED THEN
UPDATE
SET IDENTITY_CODE_CHG = 13678.000000 , TARGET.BANKING_TAX =
DECODE(identity_code_chg, 13678.000000, BANKING_TAX, 0)+
(SOURCE.TARGET_AMOUNT * 1)

Module Logging OFS Access module data: MERGE QUERY END TIME :::: 02/ 13/ 2012 17:50:11


EXPECTED BEHAVIOR
Expect the correct balances to be output from the allocation, not null balances.

STEPS
The issue can be reproduced at will with the following steps:
1. Create a dynamic driver percent distribution allocation - Source: Ledger, Output: Instrument table
2. Check the generated log file and results in target instrument table.

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