R12: AP Cannot Initiate Approval or Open Invoice Approval History Due to Error ORA-20202: No Rate Exists
(Doc ID 1680915.1)
Last updated on FEBRUARY 08, 2019
Applies to:Oracle Payables - Version 12.0.1 and later
Information in this document applies to any platform.
- When attempting to initiate workflow or open Invoice Approval history form, the following error occurs, for other currencies (like JPY) except functional currency (GBP):
APP-SQLAP-10000: ORA-20202: No rate exists between the two currencies for the given date and conversion type. The from currency was JPY. The to currency was AED.
The conversion type was 1060. The conversion date was 06-MAR-14. occurred in
with parameters (&PARAMETERS)
while performing the following operation:
set variables from workflow;
- User expects system not to look for AED currency conversion when AED is not used on this invoice.
- Business do not want to setup currency conversion for currency AED when it is not used on transaction.
AP_INVOICES_ALL.INVOICE_CURRENCY_CODE = JPY
AP_SUPPLIERS.INVOICE_CURRENCY_CODE and PAYMENT_CURRENCY_CODE= USD
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