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

Last updated on AUGUST 27, 2014

Applies to:

Oracle Payables - Version 12.0.1 and later
Information in this document applies to any platform.
Payables Invoices Entry form - APXINWKB


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


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