Incorrect Allocation Multicurrency Results Due to Incorrect Exchange Rates Used by PFT Engine
Last updated on DECEMBER 28, 2016
Applies to:Oracle Financial Services Profitability Management - Version 126.96.36.199 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Profitability Management (PFT)
On PFT 188.8.131.52, it appears that incorrect exchange rates are being picked up from the fsi_exchng_rate_direct_access table when running an allocation.
Allocation Source :Ledger_stat table
Driver : Volume in transaction table
Output : Cost column in transaction table
The issue arise when allocating expense from ledger_stat table TO Transaction table based on volume of transaction table which include multiple currencies records.
The output results of cost column in transaction table provide inaccurate results due to the amount in ledger stat table not convert correctly to transactions table currencies.
Allocation reading from ledger_stat and allocating results to transaction table is using end of October exchange rates whereas the as_of_date is 30-11-2016. Attached is the allocation log and the exchange rates used in the merge statement are the rates from the wrong date. On production environment (not upgraded) the allocation is running correctly and using end of November exchange rates.
On UAT environment, this issue did not appear because previous month and current month rates were the same.
Expect correct exchange rates to be used when running allocations.
change the EFF_TO_DATE on fsi_exchng_rate_direct_access to be 29/11/2016 instead of 30/11/2016 and the calculation runs correctly and the data come correct. Note: AS_O_DATE = 30/11/2016 not 29/11/2016
The issue can be reproduced at will with the following steps:
1. Run multi-currency allocation reading from ledger_stat and allocating results to transaction is using end of October exchange rates
2. Check generated results and generated merge statement in the PFT debug log
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