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 11.13.20.04.0 and later
Information in this document applies to any platform.

Symptoms

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

https://www.oracle.com/webfolder/technetwork/tutorials/tutorial/cloud/r13/wn/fin/releases/20A/20A-financials-wn.htm#T16951

https://www.oracle.com/webfolder/technetwork/tutorials/tutorial/cloud/r13/wn/fin/releases/20B/20B-financials-wn.htm#T18559

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

STEPS
-----------------------
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.


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
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.