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.
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
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