RFI CurrencyRate Adapter Raises ORA-01795 Error When Processing More Than 1000 Currency Rates from EBS

(Doc ID 2044706.1)

Last updated on AUGUST 17, 2016

Applies to:

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

Symptoms

The Retail Financial Integration (RFI) CurrencyRate adapter raises ORA-01795 (maximum number of expressions in a list is 1000) when processing more than 1000 currency rates from EBS.


Steps to Reproduce:

  1. Create more than 1000 currency rates in EBS.
  2. Confirm that there are more than 1000 records in RFI_CURR_RATE_STAGE table where IS_DATA_PROCESSED = 'N'.
  3. When RFI CurrencyRate adapter tries to process more than 1000 currency rates, it fails to update processed currency records, raising ORA-01795: maximum number of expressions in a list is 1000.
    Issue seems to be with the following Java class: com.oracle.retail.rfi.dataaccess.dao.RfiServiceOracleDao.updateProcessedCurrencyRecords(RfiServiceOracleDao.java:52).

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