My Oracle Support Banner

GST: TRX_NUMBER And TAX_INVOICE_NUMBER Columns In JAI_TAX_DET_FACTORS and JAI_TAX_LINES Tables Are Updated With Characters '~$~$$$' (Doc ID 2831493.1)

Last updated on JANUARY 06, 2022

Applies to:

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

Symptoms

ACTUAL BEHAVIOR
---------------
TRX_NUMBER And TAX_INVOICE_NUMBER Columns In JAI_TAX_DET_FACTORS and JAI_TAX_LINES Tables Are visible as Junk Characters '~$~$$$'

EXPECTED BEHAVIOR
-----------------------
After the Autoinvoice completes, the TRX_NUMBER And TAX_INVOICE_NUMBER in JAI_TAX_DET_FACTORS and JAI_TAX_LINES table should be updated to the actual numbers instead of staying as '~$~$$$'

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to India Local Order management responsibility > Orders 
2. Create and order and add taxes from tools > India tax details
3. Book the order
4. Navigate to Shipping transactions and pick release the order line
5. Navigate to Shipping transactions and query the order. Navigate to Delivery Tax and ship confirm the delivery
6. Run Background workflow process and Autoinvoice Import program
7. After the Autoinvoice completes, check the TRX_NUMBER And DOCUMENT_NUMBER Columns In JAI_TAX_DET_FACTORS and JAI_TAX_LINES Tables. 


Changes

Issue started occurring after Database Upgrade to DB 19c.

Cause

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
Symptoms
Changes
Cause
Solution
References


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