My Oracle Support Banner

Posting Batch Is Getting Results Error Like UPDATE_CURRENCY_EXCHANGE_RATE (Doc ID 2826243.1)

Last updated on APRIL 11, 2022

Applies to:

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

Symptoms

Posting results in error in UPDATE_CURRENCY_EXCHANGE_RATE.

Sets To Recreate :

1. Create an Invoice with Purchase Order which is created using different from base currency.
2. Execute REIM_POSTING_JOB.
3. Select the entries from the JOB_AUDIT_LOGS related to the job execution.
4. Observe the following error:
Execution of stored procedure / function : REIM_POSTING_SQL.CALC_RESOLUTION_DOC_DETAIL_AMT failed with the following error message:
@0PACKAGE_ERROR@1ORA-30926: unable to get a stable set of rows in the source tables@2REIM_POSTING_SQL.UPDATE_CURRENCY_EXCHANGE_RATE

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.