Not Able To Validate The Prepayment Applied Standard Invoice Due To Error 'Unexpected error occurred during Tax Calculation Exception: User-Defined Exception '

Last updated on NOVEMBER 06, 2016

Applies to:

Symptoms

On : 12.2.5 version, Tax Deducted at Source-Payables

When attempting to validate  the prepayment applied standard invoice 
the following error occurs.

ERROR
-----------------------

1.Unexpected error occurred during Tax Calculation  Exception: User-Defined Exception

2. 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 the section code is different in both


STEPS
-----------------------
1) Navigate to India Local Payable
2) Create the prepayment invoice and attach the TDS taxes
3)Validate and Approve it
4)make a payment of invoice
5)Create the Standard invoice (ST200) for 15000 Rs where
  1st line amount is 10000
  2nd line amount is 5000
6) Now the attach the TDS taxes to 1st line amount i.e 10000
7)save it
7)Now remove the TDS taxes from the 1st line amount i.e 10000
8)Attach the TDS taxes to 2nd line amount i.e 5000 and save it
9) Validate it
10) Apply the prepayment

Cause