R12: Unable To Apply A Prepayment: APP-SQLAP-10000 Error In Apply_Prepay_Line (Doc ID 1315896.1)

Last updated on DECEMBER 07, 2023

Applies to:

Symptoms

OA release 12 - Apply/Unapply Prepayments

While applying a Prepayment, following error is poping up:

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

FND Debug shows following messages:   

     ZX_TDS_UTILITIES_PKG.populate_tax_cache(+)tax_id :=
     tax_id cannot be null
     APP-SQLAP-10000: An unexpected error has occurr occurred in
     Apply_Prepay_Line<-Apply Prepayment Form
     with parameters (&PARAMETERS)
     while performing the following operation:
     Call to calculate tax

**Steps to reproduce:
        1. Responsibility: Oracle Payables
      2. Path: Invoices -> Entry -> Invoices
      3. Create a Prepayment and pay it to get it as available
      4. Create an Invoice and apply the recently created Prepayment
      5. Validate the invoice
             APP-SQLAP-10000 error message arises

Changes

Cause

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