CurrencyRate Data Is Not Publishing from RFI to RMS CURRENCY_RATES Table (Doc ID 1948215.1)

Last updated on JULY 01, 2016

Applies to:

Oracle Retail Financial Integration - Version 14.0 and later
Information in this document applies to any platform.

Goal

While loading Currency Rate data from E-Business Suite (EBS) to Retail Financial Integration (RFI), data is not published into the Retail Merchandising System (RMS) CURRENCY_RATES table for the records which have 'from_currency' other than the primary currency of RMS.

The following are the steps executed for this case:

  1. Run currency_initial_load.sh from the application server where ORFI is installed, =OR= publish any currency rate from the EBS System which has 'from_currency' other than the primary currency of RMS.
  2. Data gets copied from the EBS database to the staging table RFI_CURR_RATE_STAGE of ORFI database.
  3. RFI_CURR_RATE_STAGE table column IS_DATA_PROCESSED gets updated to 'Y'.
  4. Message consumption is seen successfully from rib-rfi CurrencyRate Subscriber adapter log.
  5. Message consumption is seen successfully even in the rib-rms CurrencyRate Subscriber adapter log.
  6. However, CurrencyRate data is not found on the RMS-side CURRENCY_RATES table, and there are no failure reasons. 

What could be the discrepancy here?

Solution

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