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 30, 2015

Applies to:

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

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.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms