R12: AP: ZX: Cannot Apply Foreign Prepayment: APP-SQLAP-10000:For the currency XX,there is occurred in Apply_Prepay_Line...Call to calculate tax

(Doc ID 2356427.1)

Last updated on FEBRUARY 01, 2018

Applies to:

Oracle Payables - Version 12.0.0 and later
Information in this document applies to any platform.


On : 12.1.3 version, Cannot Apply Prepayment: Error: "APP-SQLAP-10000: occurred in Apply_Prepay_Line


1. Create a prepayment ,validate it and pay it
2. Create a standard invoice and validate
3. Apply prepayment


APP-SQLAP-10000 :
For the currency USD, there is occurred in Apply_Prepay_Line <-
Apply Prepayment Form with parameters (&PARAMETERS) while performing the following operation: Call to calculate tax


Example Invoices(Prepayment) :


  Prepayment Invoice : Currency=USD , EXCHANGE_RATE_TYPE=User

  Standard Invoice:Currency=USD, EXCHANGE_RATE_TYPE=User,EXCHANGE_RATE_,DATE=31-Dec-2017,INVOICE_DATE=25-Nov-2017





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