Incorrect Results Generated by Ledger_Stat to Instrument Table Credit Side Allocation
Last updated on OCTOBER 20, 2016
Applies to:Oracle Financial Services Profitability Management - Version 220.127.116.11 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
On Oracle Financial Services Profitability Management (PFT) 18.104.22.168, when running a Ledger to Instrument allocation having both debit and credit side, the credit side of the allocation generates incorrect results.
It appears that the allocation multiplies the initial sum to be allocated with the number of rows updated in the instrument table. In this way, there are resulting larger sums written on the credit side.
When using Credit side results for a Percent distribution allocation, it is expected to find the exact same credit amount as written on the debit side but with reversed sign.
The issue can be reproduced at will with the following steps:
1. Create new percent distribution allocation with both credit and debit, source Ledger_Stat output to Instrument table.
2. Run the allocation
3. Check generated credit and debit balances.
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