Transaction Number Is Incorrect in JAI_TAX_LINES Table After Completing the Account Receivables(AR) Transaction (Doc ID 3039620.1)

Last updated on AUGUST 13, 2024

Applies to:

Symptoms

Wrong TRX_NUMBER is populated in the JAI_TAX_LINES table after completing the AR transaction.

The issue can be reproduced at will with the following steps:
1. Create the Receivables Document Sequencing & Transaction Numbering setups as per document 735498.1
2. Navigate to India Oracle Receivables > Transactions.
3. Create a new AR transaction as per the setup and enter the lines and distribution details.
4. Save the AR transaction.
5. AR transaction number is generated.
6. Navigate to Tools > India Tax Details > Apply GST taxes and save it.
7. Now Complete the AR transaction.
8. Find that the new TRX_NUMBER is generated in AR workbench and in the JAI_TAX_DET_FACTORS.
9. Whereas in the JAI_TAX_LINES table, the TRX_NUMBER is still showing the old number.
10. Hence there is a difference in TRX_NUMBERS in both det factors and tax lines tables.

Changes

Cause

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