My Oracle Support Banner

DATA FIX: GST Tax invoice number is missing in JAI_TAX_DET_FACTORS but exists in JAI_TAX_LINES (Doc ID 2614103.1)

Last updated on JANUARY 15, 2021

Applies to:

Oracle Financials for India - Version 12.1.3 to 12.2.9 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
---------------
Tax_invoice_num is missing in JAI_TAX_DET_FACTORS table

EXPECTED BEHAVIOR
-----------------------
Tax invoice number should be consistent and same in both JAI_TAX_DET_FACTORS and JAI_TAX_LINES tables.

Business Impact
-------------------
Due to this issue, Business is not able to reconcile the records.

Changes

 Fix populates the applicable det factor id with the TAX_INVOICE_NUM value in JAI_TAX_DET_FACTORS table from JAI_TAX_LINES table.

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


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