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:

Symptoms

ACTUAL BEHAVIOR
---------------
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


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

STEPS
-----------------------
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.

Changes

This issue is encountered after applying patch 32291631

Cause

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