My Oracle Support Banner

R12: EBTAX/AP : Error While Applying Prepayment - "APP-SQLAP-10000: An unexpected error has occurred in Apply_Prepay_Line" (Doc ID 2933946.1)

Last updated on MARCH 10, 2023

Applies to:

Oracle Payables - Version 12.2.5 to 12.2.12 [Release 12.2]
Oracle Payables - Version 12.2 and later
Information in this document applies to any platform.


Error While Applying a Prepayment invoice to a Standard invoice  - 

APP-SQLAP-10000: An unexpected error has occurred in Apply_Prepay_Line <- Apply Prepayment Form with parameters (&PARAMETERS) while performing the following operations: Call to calculate tax.

Error associated with FND Debug log:

AP.PLSQL.AP_ETAX_UTILITY_PKG.Return_Error_Messages1  "The system could not determine the applicable Tax Rate for Tax XXXX and Tax Status XXXX. Please contact your Tax Administrator to ensure that either a default Tax Rate Code that is effective on &DATE is specified for this Tax Status or appropriate Rate Determination Rules are defined."


Steps to reproduce the Issue:

  1. Create a Standard Invoice(N: SuperUser - Invoices - Entry), Validate and Account
  2. Create a Prepayment Invoice
  3. Click Actions-> Apply/Unapply Prepayment-> Select the prepayment to be applied -> Error message






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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.