My Oracle Support Banner

GST: TRX_NUMBER And DOCUMENT_NUMBER Columns In JAI Tables Are Updated With Junk Characters '~$~$$$' (Doc ID 2349083.1)

Last updated on FEBRUARY 03, 2019

Applies to:

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

Symptoms


TRX_NUMBER and DOCUMENT_NUMBER columns in JAI tables are updated with junk characters '~$~$$$' for imported transactions.

Below query can help to identify such cases:

Check if the above query returns any count.

Changes

 GST Implementation

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
 1. Bug Summary
 2. Fixed Files

R12.JAI.B:
jaitrxnumdetfactors.sql 120.0.12010000.5
jaitrxnumrgmrcvrlines.sql 120.0.12010000.4
jaitrxnumtaxlines.sql 120.0.12010000.4
 3. Recommended Patches
R12.JAI.B: <Patch 26961347> & Patch 27212160 (RUP 11)
R12.JAI.C: < 27212160:R12.JAI.C>
 4. Solution Steps
References


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