Pending Resource Transactions Stuck With Error CURRENCY_CONVERSION_RATE

(Doc ID 2093447.1)

Last updated on JUNE 15, 2018

Applies to:

Oracle Work in Process - Version 12.1.3 and later
Information in this document applies to any platform.


Find Resource Pending transactions stuck with following error:

Error message: Exchange rate is missing for this foreign currency transaction.
When the interfaced transaction is in a currency code that is not the same as the currency code of the organization, the currency exchange rate (CURRENCY_CONVERSION_RATE) must be populated.
Since the interface validation does not check against the Oracle General Ledger rate table (GL_DAILY_TRANSLATION_RATES) this rate may be from any source.
However, all Oracle Purchasing transactions in a foreign currency will have a exchange rate.
Action: Please populate the CURRENCY_CONVERSION_RATE in the interface table.


1. Review pending transactions.
2. See record stuck in error preventing period close.




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