My Oracle Support Banner

GST: Prepayment Application Giving Error "APP-SQLAP-1000" While Applying on Standard Invoice (Doc ID 3009021.1)

Last updated on MARCH 14, 2024

Applies to:

Oracle Financials for India - Version 12.1.1 and later
Information in this document applies to any platform.


Error encountered on Invoice Workbench while applying prepayment on standard Payables invoice.

Unexpected error occurred during Tax calculation Exception : user-defined exception. Please correct the problem or contact your system administrator.
APP-SQLAP-1000: occurred Apply_Prepay_Line<-Apply Prepayment Form with parameters(&Parameters) while performing the following operation; Distribute Tax

Additionally below error is observed in FND Debug log:

JAI.PLSQL.JAI_TAX_PROCESSING_PKG.DETERMINE_RECOVERY,Encountered an error in JAI_AP_IDA_TRIGGER_DTC_PKG.BRIUD_DTC_T1 Error on ap_invoice_distributions_all : ORA-20007: Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : Application cannot be done as thier is no TDS attached in Prepayment invoice

The issue can be reproduced at will with the following steps:
1. Navigate to India Local Payables --> Invoice --> Invoice.
2. Create  a prepayment and attach applicable TDS(Tax Deduction at Source) section code and tax category manually or default TDS section code using defaulting mechanism.
3. Validate the prepayment and make payment.
4. Now create a standard invoice and attach attach applicable TDS section code and tax category manually or default TDS section code using defaulting mechanism.
5. Validate the standard invoice and go to Actions and check Apply/Unapply Prepayment.
6. Apply prepayment and observe error.


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.