Pending Resource Transactions Stuck With Error CURRENCY_CONVERSION_RATE (Doc ID 2093447.1)

Last updated on FEBRUARY 01, 2017

Applies to:

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

Symptoms

Find Resource Pending transactions stuck with following error:

CST_TXN_RATE_VALIDATION 
Error message: Exchange rate is missing for this foreign currency transaction.
Cause:
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.

 


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

Cause

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