My Oracle Support Banner

OFI : Incorrect Value is Getting Populated in Column INVOICE_AMOUNT in Table JAI_AP_TDS_INVOICES Post Validation of Matched Payables Invoice with IPV(Invoice Price Variance) (Doc ID 2965672.1)

Last updated on AUGUST 10, 2023

Applies to:

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


Incorrect value is getting populated in column INVOICE_AMOUNT in table JAI_AP_TDS_INVOICES post validation of payables invoice with IPV though TDS (Tax Deduction at Source) invoice getting generated with correct amount.

The issue can be reproduced with the following steps:

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

2. Create a Purchase Order (PO).

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

4. Approve the PO.

5. Navigate to Oracle Purchasing > Receiving > Receipts.

6. Create receipt by confirming Tax and perform PO delivery.

7. Navigate to Oracle Payables > Invoice > Invoices.

8. Create AP Invoice by matching the receipt which we created in above steps while matching take different unit price.

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. Validate the invoice which will generate IPV lines in distributions and TDS invoice and TDS CM (credit Memo), Observe that TDS invoice and CM got generated with correct amount but incorrect value gets populated in column INVOICE_AMOUNT of JAI_AP_TDS_INVOICES table.


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.