My Oracle Support Banner

Incorrect Allocation Results When Aggregating Record Count on Management Ledger with Statistical Currency (Doc ID 2203748.1)

Last updated on MARCH 18, 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)


On PFT 8.0.1 the generated results for an Instrument to Management Ledger allocation which aggregates record count appear to be incorrect.


Facing the following issue: as indicated in the latest Profitability Management User Guide, for aggregating Record Count from the Instrument Tables to Management Ledger, have used in Output a "Statistic" Column Property Financial Element and the Statistical Currency ‘002’, for the output value not to be translated from the deal currency to the functional currency. However, the Source values were still converted when using Management Ledger, and the same allocation wrote the results correctly when using Ledger Stat; therefore, it appears that it is a Management Ledger related issue.

Have designed the following two allocations:

1) Sys ID 206477
Aggregating Record Count from Loan Contracts in Ledger Stat
Output: FE 50300 statistical and currency 002
Status: successful, and the results written were correct meaning that 12 records were aggregated (please find attached an export from Loan Contracts)

2) Sys ID 206468
Aggregating Record Count from Loan Contracts in Management Ledger
Output: FE 50300 statistical and currency 002
Status: successful, but the results written were not correct as the source values were converted to the functional currency USD

Have noticed that in the debug PFT FusionApps Log file, the SQL code created for Management Ledger takes into consideration every currency the amount converted into USD; example: DECODE(mv.ISO_CURRENCY_CD, 'LBP', mv.RECORD_COUNT/ 1509, mv.RECORD_COUNT)RECORD_COUNT, where 1509 is the exchange rate 1 USD = 1509 LBP.  This is not expected functionality.

Expect that record count is aggregated from the instrument tables to Management Ledger using statistical currency without the source amounts to be converted.

The issue can be reproduced at will with the following steps:
1. Define two allocations as specified above
2. Run them
3. See the results and compare the differences


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.