GST: Error While Applying Prepayment: "Application cannot be done as thier is no TDS attached in Prepayment invoice" (Doc ID 2869112.1)

Last updated on MAY 17, 2022

Applies to:

Symptoms

Getting error while trying to apply Prepayment to Standard invoice.

ERROR
-----------------------
Error: APP-SQLAP-10000: The system could not create ta occurred in Apply_Prepay_lineForm with parameters (&PARAMETERS) while performing the following operation:
Distribute Tax.

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

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.Navigate to India Local Payables Responsibility > Invoices >  Create a Prepayment invoice
2. Enter the line.
3. Split the line into 3 distributions.
4. TDS is applied on 2 out of 3 distribution lines.
5. Validate the prepayment invoice.
6. Once the prepayment is available for application, apply the prepayment to a standard invoice with single distribution and TDS applied on full distribution amount.
7. Notice the error message.

Cause

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