My Oracle Support Banner

Post Ship Confirm SHIP_TO_GSTIN Value Wrongly Populating in Table JAI_IRN_DETAILS when Bill To and Ship To Location is Different (Doc ID 2889623.1)

Last updated on AUGUST 22, 2022

Applies to:

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


Post ship confirm SHIP_TO_GSTIN is stamped as BUYER_GSTIN even though ship to site is different then bill to site and having different GSTIN

Expects correct GSTIN should be stamped if ship to is different from bill to

The issue can be reproduced at will with the following steps:

1. Enter sales order (SO) details with different bill to and ship to address and having different GSTIN at below navigation

(N) Oracle Order Management > Orders,Returns > Sales Orders

In sales order form enter details lets say,


Ship To Location and Bill to location of "ABC" customer get populated automatically.

b) Then change the ship to location , Here enter the ship to location of any other customer which has third party registration as

ship to location = 12345

(this is ship to location of another customer i.e. "XYZ")

2.Open India Tax detail form and enter tax details at SO level and book the SO.

3.Perform pick release and ship confirm using below mentioned navigation

(N) Oracle Order Management > Shipping > Transactions

4. Verify data in table JAI_IRN_DETAILS wherin SHIP_TO_GSTIN is stamped as Buyer_GSTIN (i.e. in SHIP_TO_GSTIN GST number of "ABC" customer is coming instead of "XYZ" customer)


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.