My Oracle Support Banner

Incorrect Results Generated by Ledger_Stat to Instrument Table Credit Side Allocation (Doc ID 1941809.1)

Last updated on MARCH 19, 2019

Applies to:

Oracle Financial Services Profitability Management - Version and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)


On Oracle Financial Services Profitability Management (PFT), 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.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.