My Oracle Support Banner

Tax Deducted at Source (TDS) Calculated Incorrectly Post Validation of Evaluated Receipt Settlement(ERS) Invoice Which is in Needs Revalidation Status. (Doc ID 2985120.1)

Last updated on NOVEMBER 03, 2023

Applies to:

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


Wrong TDS is getting calculated post validating ERS invoice which is in needs revalidation status.

The issue can be reproduced with the following steps:

1. Navigate to Oracle Purchasing > Purchase Orders > Purchase Orders.

2. Create a Purchase Order (PO) with 4 way matching option and with a receipt routing method as "Inspection Required".

3. Navigate to Tools > India Tax Details and apply GST.

4. Approve the PO.

5. Navigate to Oracle Purchasing > Receiving > Receipts.

6. Create PO receipt by confirming tax and do not perform inspection and PO delivery.

7. Based on "Pay on Receipt" or "ERS" setup system creates ERS invoice in Payables and matches it with PO for the received amount.

Note:- If ERS setup is not in place then one can manually run below concurrent programs to create ERS invoice.

a) ADS(Pay On Receipt AutoInvoice)
b) Payables open interface Import

8. Navigate to "Oracle Payables > Invoice > Invoices" and query the created ERS invoice.

9. Open TDS Tax Detail form to review defaulted TDS section and category or apply the relevant TDS section and category and check override checkbox and save if defaultation mechanism is not in place and close the form.

10. Try to validate the invoice which would put invoice on hold with hold name as "Quantity billed exceeds quantity accepted" and invoice status would become as "Needs Revalidation" which is intended since inspection and PO delivery not yet performed.

11. Now navigate to "Oracle Purchasing > Receiving > Receiving Transactions" and perform the inspection and PO delivery and save.

12. Again navigate to "Oracle Payables > Invoice > Invoices" and validate the invoice and observe that TDS invoice and credit memo (CM) were generated with incorrect amounts.


To view full details, sign in with your My Oracle Support account.

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

In this Document

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