My Oracle Support Banner

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.




To view full details, 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 a vibrant support community of peers and Oracle experts.