RFI Does Not Integrate the Latest Exchange Rate from Oracle EBS into RMS
Last updated on JULY 02, 2018
Applies to:Oracle Retail Financial Integration - Version 15.0.1 to 15.0.1 [Release 15.0]
Information in this document applies to any platform.
Exchange rate update do not work correctly between Oracle EBS and RMS. Whenever an exchange rate is updated more than once within the scheduled time interval for the RFI schedule to process the records from RFI staging table, RFI integrates the old exchange rate details to RMS, by overwriting the latest exchange rate.
Steps to Recreate:
Following data represents an amendment done in EBS within the the scheduled interval for RFI processing:
1. Firstly, user defined 0.9 as FX rate between GBP to EUR
2. After that, changed it to 0.91 for same GBP to EUR for the same effective date before the first RFI record is processed for RMS.
3. Following is the data in the RFI staging tables before the web service for RMS is called:
CREATION_DATE ID FROM_CURR TO_CURR CONVERSION_DATE CONVERSION_TYPE CONVERSION_RATE CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE STATUS IS_DATA_PROCESSED
10-04-2018 15:04 11604 GBP EUR 10-APR-18 Corporate 0.9 System 10-APR-18 System 10-APR-18 NEW N
10-04-2018 15:25 11605 GBP EUR 10-APR-18 Corporate 0.91 System 10-APR-18 System 10-APR-18 NEW N
4. The expectation on RMS side is to see the latest value entered. However, due to incorrect “ORDER BY” clause, the record processing order is:
10-04-2018 15:25 0.91
10-04-2018 15:04 0.9
5 Finally, the rate stored in RMS will be 0.9, which is wrong.
CURRENCY_CODE EFFECTIVE_DATE EXCHANGE_TYPE EXCHANGE_RATE CREATE_ID CREATE_DATETIME
EUR 10-APR-18 O 0.9 RMS 11-APR-18
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