My Oracle Support Banner

Incorrect trx_number appearing in jai_tax_det_factors (Doc ID 2864329.1)

Last updated on JUNE 12, 2023

Applies to:

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


Problem Statement
Found that for an invoice instead of having its records in jai_tax_det_factors table, found details pertaining to another invoice.
i.e. in jai_tax_det_factors table trx_number is reserved for invoice_number for invoices.
Observed that in case of storing its relevant invoice number found that this column has a value pertaining to another invoice which is not related to this.

Steps for replication
Issue can be considered as sheer corruption and this cannot be replicated at will.
But observed for an existing invoice when querying jai_tax_det_factors table.

Expected Behavior
Expectation is such that this incorrect record stands corrected appropriately.


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.