Initiating Quote Approval Error: "APP-236138: Error returned in ASO_APR_INT.GET_ALL_APPROVERS APP-236139: ORA-20001: No rate exists between the two currencies for the given date and conversion type" (Doc ID 434087.1)

Last updated on APRIL 28, 2017

Applies to:

Oracle Quoting - Version 11.5.10.2 to 12.1.3 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.

Symptoms

When attempting to initiate approval for a quote in Forms Quoting, the following error occurs:

Error

APP-236138: Error returned in ASO_APR_INT.GET_ALL_APPROVERS

APP-236139: ORA-20001: No rate exists between the two currencies for the given date and conversion type. The from currency was USD. The CAD. The conversion type was . The conversion date was &SYSDATE.

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