R12: AP Cannot Initiate Approval or Open Invoice Approval History Due to Error ORA-20202: No Rate Exists
Last updated on AUGUST 07, 2014
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
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