My Oracle Support Banner

GST : The column TOTAL_INV_FOREIGN_CURR is Null in JAI_IRN_DETAILS table (Doc ID 2748871.1)

Last updated on FEBRUARY 02, 2021

Applies to:

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

Symptoms

ACTUAL BEHAVIOR
---------------
The column TOTAL_INV_FOREIGN_CURR  is Null in JAI_IRN_DETAILS table

EXPECTED BEHAVIOR
-----------------------
The required columns should be show correct  data in JAI_IRN_DETAILS table


Steps to Reproduce the issue:
----------------
1. Create Export Order in Foreign currency and perform Ship Confirm.
2. Run the inbound process for E-Invoice
3. Notice that the value of TOTAL_INV_FOREIGN_CURR is NULL in jai_irn_details table


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot record correct data

Changes

 

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.