Encountered an error in JAI_AP_IDA_TRIGGER_PKG.BRIUD_T1. ORA-20011: Invoice To Tax Deduction At Source(TDS) Authority is Already Paid. Current Invoice can't be Cancelled (Doc ID 1326443.1)

Last updated on SEPTEMBER 21, 2023

Applies to:

Symptoms

When attempting to cancel the invoice, the following error occurs.

ERROR
-----------------------
APP-SQLAP-10000: User-Defined Exception occured in
Error from Trigger JAI_AP_IDA_BRIUD_T1

with parameters (&PARAMETERS)
while performing the following operation:

Encountered an error in JAI_AP_IDA_TRIGGER_PKG.BRIUD_T1
Error on ap_invoice_distributions_all: ORA-20011: Invoice
to TDS Authority  is already paid. Current invoice can't be cancelled.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. (N)-> India Local Payables
2. Invoices -> Entry

Scenario 1:
Invoice entered.
Payment to vendor and commissioner made.
Canceled payment to vendor.
Tried to cancel vendor standard invoice from invoice screen.
Error popped up.

Scenario 2:
Invoice entered.
Payment to vendor and commissioner made.
Canceled payment to vendor.
Tried to cancel vendor standard invoice from payment screen itself by giving void related invoices.
Error popped up.

BUSINESS IMPACT
-----------------------
Due to this issue, users cannot cancel the invoices.

Changes

Cause

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