My Oracle Support Banner

GST : Data fix to remove duplicate HSN codes created for item and organization in JAI_REPORTING_ASSOCIATIONS table (Doc ID 2754801.1)

Last updated on JUNE 12, 2023

Applies to:

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


Problem Statement
Observed duplicate reporting code data exists in JAI_REPORTING_ASSOCIATIONS table.
Consider the explanation with below example .

(N) to Item template attribute registration form and under Under Reporting code tab
Observed as below
Reporting type : Legal reporting
Regime : GST India
With reporting code value as 123123123.

Where such reporting code value exists as multiple records.

Steps for replication
Unable to replicate this.

Expected Behavior
There shouldn't be duplicate reporting codes created as this leads to incorrect values derived.




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.