My Oracle Support Banner

ReIM Posting Batch Fails With Error 'Unable to get a stable set of rows in the source @ tables@2REIM_POSTING_SQL.UPDATE_CURRENCY_EXCHANGE_RATE' (Doc ID 1602442.1)

Last updated on FEBRUARY 10, 2021

Applies to:

Oracle Retail Invoice Matching - Version 13.2.5 and later
Information in this document applies to any platform.

Symptoms

REIMPOSTING batch program fails with the following error message:


Steps to Reproduce:

  1. Make sure that currency rates are set up whereby there are 2 records per date with the same rate; just different exchange types ('O' and 'C').
  2. Create a Purchase Order (PO); ship and receive it.
  3. Create an Exact Match Invoice.
  4. Run REIMAUTOMATCH batch program.
  5. Run REIMPOSTING batch program. The posting batch fails with the error message “Unable to get a stable set of rows in the source  tables@2REIM_POSTING_SQL.UPDATE_CURRENCY_EXCHANGE_RATE” error.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


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