My Oracle Support Banner

GST E-Invoice: JAI_IRN_DETAILS Not Populated For Sales Orders Having Taxes With Tax Point Basis: Invoice (Doc ID 2849442.1)

Last updated on MARCH 02, 2022

Applies to:

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


To test E-invoice functionality, the program "India Generate IRN Extract" was run but it didn't generate the xml with the required transaction details.
On further debug it was found that the source table JAI_IRN_DETAILS is empty

JAI_IRN_DETAILS should be populated for the Sales order invoices. This table data is extracted in the IRN extract.

The issue can be reproduced at will with the following steps:
1. Navigate to India Local Order Management responsibility > Sales Order
2: Create a Bill Only sales order Or a Shipment Sales order.
3: Go to tools > India tax details and attach taxes with tax point basis(TPB): Invoice
4: Save and book the sales order.
5. Optionally pick release and ship confirm the shipment SO if applicable.
6. Run Workflow background process and Autoinvoice.
7. Review if Invoice tax number is generated and check if JAI_TAX_DETAILS is populated.
8. Review if JAI_IRN_DETAILS table is populated with data and find that it has no data.


This issue is encountered after applying patch 32291631


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.