My Oracle Support Banner

GST Reporting For India: Data Does Not Populate In Zx_rep_trx_jx_ext_t (Doc ID 2689452.1)

Last updated on JULY 09, 2021

Applies to:

Oracle Fusion Tax Cloud Service - Version and later
Information in this document applies to any platform.


As per below Documentation , trying to create GST report for India.

Need help to investigate why does data not populate in zx_rep_trx_jx_ext_t

The data should get populated in the zx_rep_trx_jx_ext_t table

The issue can be reproduced at will with the following steps:
1. Setup GST
2. Create AP Invoice
3. validated and Accounted AP Invoice
4. Verified that Self Assessed Tax Lines are generated on Invoice.
5. Ran ESS Job# Record Inward and Outward Taxes for India and Report Tax Liability Under Reverse Charge Tax for India
6. Using BI Ran below SQL:
  Select * from zx_rep_context_t --> I can see the Data Populated
  select * from zx_rep_trx_detail_t --> I can see the Data Populated
  select * from zx_rep_trx_jx_ext_t --> DATA Does not Populate.


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.