RFI CurrencyRate Adapter Raises ORA-01795 Error When Processing More Than 1000 Currency Rates from EBS
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.
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:
- Create more than 1000 currency rates in EBS.
- Confirm that there are more than 1000 records in RFI_CURR_RATE_STAGE table where IS_DATA_PROCESSED = 'N'.
- 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).
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