RFI Does Not Integrate the Latest Exchange Rate from Oracle EBS into RMS (Doc ID 2415795.1)

Last updated on MARCH 09, 2023

Applies to:

Symptoms

Exchange rate update does 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

Changes

Cause

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