Transaction Workbench Error: Unable To Save Transaction With Foreign Currency, Raises Error: "For the Currency USD, There Is Either No Exchange Rate For Currency EUR Defined Or Is Not Applicable"

(Doc ID 834317.1)

Last updated on OCTOBER 09, 2017

Applies to:

Oracle Receivables - Version 12.0.5 and later
Information in this document applies to any platform.
Form:ARXTWMAI.FMB - Transactions


Symptoms

Transaction with foreign currency can't be saved, even if you enter the rate correctly it raises the error:
For the currency USD, there is either no exchange rate for currency EUR defined or is not applicable to 20-APR-11

The trace file shows:  


PARSING IN CURSOR #358
INSERT INTO ZX_DETAIL_TAX_LINES_GT VALUES
(:B1 ,:B2 ,:B3 ...:B310 )

BINDS #358:
...
Bind#16
value="DE_TAX_REGIME" ==> TAX_REGIME_CODE
Bind#18
value="DE_VAT" ==> TAX
Bind#20
value="DE O FULL" ==> TAX_STATUS_CODE
Bind#22
value="DE O FULL" ==> TAX_RATE_CODE
Bind#23
value=19 ==> TAX_RATE

...
Bind#43
value="4/29/2011 0:0:0" ==> CURRENCY_CONVERSION_DATE
Bind#44
value="User" ==> CURRENCY_CONVERSION_TYPE
Bind#45
value=1.3 ==> CURRENCY_CONVERSION_RATE
Bind#46
value="4/29/2011 0:0:0" ==> TAX_CURRENCY_CONVERSION_DATE



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