Incorrect Allocation Multicurrency Results Due to Incorrect Exchange Rates Used by PFT Engine (Doc ID 2218494.1)

Last updated on DECEMBER 28, 2016

Applies to:

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

Symptoms

On PFT 6.1.1.1, it appears that incorrect exchange rates are being picked up from the fsi_exchng_rate_direct_access table when running an allocation.

ACTUAL BEHAVIOR
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.

EXPECTED BEHAVIOR
Expect correct exchange rates to be used when running allocations.

WORKAROUND
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

Cause

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