PFT Simple Distribution Allocation is Not Allocating Correctly and Dividing By Factor Not Specified in the Allocation
(Doc ID 2377581.1)
Last updated on DECEMBER 03, 2019
Applies to:Oracle Financial Services Profitability Management - Version 8.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Profitability Management (PFT)
Percent % Distribution
On PFT 8.0.2, it appears that all Dynamic Driver Simple Distribution allocations are not allocating correctly. All results are being divided by a factor 69.5. The merge statement in the PFT debug log shows the same:
MERGE INTO LEDGER_STAT TARGET USING (SELECT *
FROM (SELECT (SUM (IVW_SOURCE.IVWSRC_AMOUNT) * 1/ 69.5 )
BALANCE_AMOUNT, ORG_UNIT_ID, GL_ACCOUNT_ID, COMMON_COA_ID,
Expect the results to not be divided by a factor not specified in the allocation.
The issue can be reproduced at will with the following steps:
1. Run any simple distribution allocation.
2. Check generated PFT debug log for merge statement
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