Skip to the content.

JA India GSTR-3B Return – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™. Oracle EBS module: Asia/Pacific Localizations · all Asia/Pacific Localizations reports

Overview

Imported from BI Publisher Description: GSTR-3B Return Report Application: Asia/Pacific Localizations Source: India GSTR-3B Return Report Short Name: JAIGSTR3B DB package:

Run this report in Excel in seconds: download Blitz Report™ free (your first 30 reports are free) or try it in the online demo.

Report Parameters

Tax Regime, GST Registration Number, Return Period (MONYYYY)

Oracle EBS Tables Used

jai_party_reg_lines_v, jai_party_regs_v, jai_tax_det_factors, jai_tax_lines_v, jai_reporting_associations_v, jai_rgm_recovery_lines, jai_party_regs, jai_tax_types_v, jai_tax_lines, dual

Report Categories

Enginatics, R12 only

JA India GSTR-2 Return, JA India Third Party Registration Upload, JA India GSTR-1 Return

Running This SQL Without Blitz Report

The SQL source can be run in any SQL client. Some Oracle EBS SQL reports in this library use functions from the utility package xxen_util – install it first. Blitz Report™ adds parameters, Excel output with pivots, scheduling and security on top.

Download & Import Options

Resource Link
Excel Example Output Example
Blitz Report™ XML Import JA_India_GSTR_3B_Return.xml
SQL Source JA India GSTR-3B Return.sql
Full Report on Enginatics www.enginatics.com/reports/ja-india-gstr-3b-return/

JA India GSTR-3B Return - Case Study & Technical Analysis

Executive Summary

The JA India GSTR-3B Return report supports the filing of the monthly summary return. GSTR-3B is a self-declared summary of outward supplies, inward supplies liable to reverse charge, and eligible ITC. It is the return that determines the actual tax payment liability for the month.

Business Challenge

GSTR-3B is the “Payment Return”. Errors here directly result in incorrect tax payments.

Solution

The JA India GSTR-3B Return report aggregates data from both Sales (GSTR-1 equivalent) and Purchases (GSTR-2 equivalent) to provide the summary figures needed for the 3B filing.

Key Features:

Technical Architecture

The report aggregates data from the GST transaction repository.

Key Tables and Views

Core Logic

  1. Aggregation: Sums up taxable values and tax amounts by category (Outward, Inward RCM, ITC).
  2. Netting: (In the business process, not necessarily the report) Calculates the net liability.
  3. Reporting: Presents the data in the exact table format of the GSTR-3B online form (Table 3.1, Table 4, etc.).

Business Impact


© Enginatics GmbH