Error "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 STD invoice" While Applying Prepayment to Never Validated Invoice (Doc ID 2902823.1)

Last updated on OCTOBER 14, 2022

Applies to:

Symptoms

When attempting to Apply prepayment on never validated invoice,
the following error occurs.

ERROR
-----------------------
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 STD invoice.


STEPS TO REPRODUCE
--------------------------
1. Navigate to Oracle Payables.
2. Invoice > Invoice > Create a Prepayment with TDS and pay the same.
3. Create Invoice and do not validate.
4. Apply Prepayment now.
5. Observe error.

Cause

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