Manual return prep
Exporting Oracle sales and purchase registers, then re-keying them into GSTR-1 and 3B templates.
Oracle · GST Filing · GSP-CertifiedGST filing from Oracle. Reconciled. Zero PL/SQL.
Native Oracle GST add-on to upload, reconcile and file GSTR-1, GSTR-3B and IMS from Oracle Fusion Cloud and EBS — in real time.
Fusion Cloud · EBS · NetSuiteISO 27001:2022Direct GSTN license
Oracle GST ConnectorOracle GST, powered by WhiteBooks
Real-time invoice flow from Oracle to IRP and back — accurate, compliant, and hassle-free.
Oracle
AR / AP / GL
Invoice Data Generated
e-Invoice Cockpit
GSP Layer
WhiteBooks GSP
Validation & Enrichment
- GSTIN Validation
- De-duplication Check
- Schema Validation
- Digital Signature
- QR Code Generation
IRP Layer
GSTN – IRP
Invoice Registration
- IRN Generation
- ANX-1 (Seller) Update
- ANX-2 (Buyer) Update
Buyer
Buyer System (ANX-2)
Invoice Received
- ITC Details Visible
- Invoice Verified via QR
- Ready for Reconciliation
IRN + Signed QR
Posted back to Oracle
The problem
Is your Oracle team still manually uploading JSON to the GST portal?
Stop wasting hours on manual data entry and GSTR mismatches.
2A/2B mismatches
Vendor invoices in Oracle don't match what's filed on the GST portal, triggering ITC reversals.
No audit trail
Reconciliation becomes a nightmare against the GST portal.
The real cost — at just 1,000 invoices / month
₹12L+Annual labor cost
300+Hours wasted / month
HighGST penalty risk
The solution
One connector. Complete automation.
Real-time, end-to-end — from Oracle ledger data to a filed GST return.
01
Auto-Extraction
Sales & purchase registers pulled from Oracle
DailyAuto-sync
02
Smart Mapping
BI Publisher / REST to GSTR-1 / 3B schema, automatically
47-pointPre-validation
03
Auto-Reconciliation
2A / 2B / IMS matched against your purchase register
<60 sReconciliation time
04
Audit Ready
Complete working papers & compliance trail
7 yrsData retention
Compatibility
Works with your Oracle
From E-Business Suite to Fusion Cloud — we support every major Oracle platform.
Oracle Fusion Cloud ERP
Cloud Native- REST / SOAP web services
- OIC & BI Publisher
- Native IRP since 21A
Oracle E-Business Suite
Most Popular- EBS R12 & 12.2
- XML Gateway & PL/SQL
- BI / XML Publisher
Oracle NetSuite
Cloud Native- SuiteScript / SuiteApp
- REST & SOAP
- India tax localization
Oracle JD Edwards
Enterprise- EnterpriseOne 9.x
- Orchestrator / BSSV
- AIS REST services
Plus PeopleSoft, Oracle SCM Cloud, Fusion Financials & more
View Full CompatibilityArchitecture
How it works
Three layers. Infinite reliability. Zero manual work.
1Layer 1
Oracle
- WhiteBooks Oracle adapter extracts sales & purchase registers
- Maps Oracle ledger data to GSTR-1, 3B, 9 and 9C schema
- Reads GSTIN, HSN, and place-of-supply per line item
- Auto-syncs on a daily or on-demand schedule
2Layer 2
WhiteBooks Server
- Runs the 47-point pre-submission validator before upload
- Auto-reconciles GSTR-2A, 2B and IMS against your purchase register
- Uploads validated returns to the GSTN portal over the GSP channel
- Stores working papers and filing history for 7 years
- Smart, insightful compliance reporting
3Layer 3
GSTN Portal
- Validates return data per GSTN filing rules
- Generates the Acknowledgement Reference Number (ARN)
- Confirms filing status back to WhiteBooks in real time
4Layer 4
Filing & Reconciliation
- GSTR-1, 3B, 9 and 9C filed with EVC
- 2A / 2B / IMS mismatch report with exception routing
- Working papers auto-generated per filing period
- Notice tracker linked back to the return that caused it
Enterprise
Enterprise features
Built for large Oracle deployments with demanding requirements.
High-volume processing
100,000+ invoices / day
Operating-unit & LE mapping
Multi-org support
Multiple legal entities
Centralized management
Failover retry engine
Automatic error recovery
Batch & scheduled runs
Off-peak processing
Multi-GSTIN management
Consolidated dashboard
Bulk reconciliation
Automated matching
Advanced search & filters
Quick data retrieval
Analytics & API webhooks
Real-time data alerts
The transformation
From spreadsheets and manual work to automated workflows
Save hours, eliminate errors and build audit-ready operations with WhiteBooks.
01Before WhiteBooks
8+ hours/monthReturn prep time
15–20%2A/2B mismatch rate
Every GSTINManual work
HighCompliance risk
NoneAudit trail
LowTeam satisfaction
02WhiteBooks Engine
Automation EngineWhiteBooks
GST ReadyAudit TrailMaker-CheckerConnected Workflows
8 hrs/day
saved
0%
errors
100%
audit logs
24×
faster
03After WhiteBooks
<60 secondsReturn prep time
<3%2A/2B mismatch rate
ZeroManual work
NoneCompliance risk
100% completeAudit trail
HighTeam satisfaction
Connected workflow
Create Invoice
Approval
GST Sync
Audit Log
Export
The outcome
24×Faster processing
8 hrsSaved daily
0%Errors
100%Audit trail
Life after WhiteBooks
09:00Invoice created
09:01Approval completed
09:01GST synced
09:02Audit log generated
09:02Evidence exported
For developers
Developer-friendly integration
Built by developers, for developers.
API documentation
Complete REST API documentation with examples.
Sandbox environment
Test the integration before going live.
Multiple language SDKs
Java, Python, Node.js & .NET libraries.
Error codes
Detailed error messages with solutions.
Postman collections
Ready-to-use API collections.
Webhook events
Real-time notifications for filing status changes.
generate-einvoice.js
import WhiteBooksConnector from 'wb-oracle';
const connector = new WhiteBooksConnector({
apiKey: 'your_api_key',
environment: 'production'
});
const result = await connector.fileGstr1({
gstin: '29AABCT1234D1Z5',
period: '032025',
autoSubmit: true
});
console.log(result.arn);
console.log(result.filingStatus);Proof
Proven results
Real companies. Real ROI. Real fast.
Leading auto-parts manufacturer
50 GSTINs filed from one Oracle instance
300+ hrsSaved / month
40% → 0%Error reduction
₹15LROI annually
WhiteBooks transformed our entire GST compliance process overnight.
Fortune 500 FMCG enterprise
Zero missed filing deadlines
150+Branches
100%Automation
PerfectCompliance score
Finally, real-time GST compliance that actually works with Oracle Fusion Cloud.
Multi-state pharmaceutical distributor
50+ GSTINs managed centrally
10K+Invoices reconciled / month
<60 s2B reconciliation time
ZeroAudit issues
The reconciliation alone saves us two full-time employees worth of work.
The logic
Why this works
A proven methodology with predictable results.
1
Because Oracle emits structured ledger data (XML / BI Publisher)
2
Which always has to be mapped to the GSTR-1 / 3B schema
3
And validated against GSTN's field-level rules before upload
4
Using standard Oracle REST / SOAP web services
5
All reconciliation logic is handled at the OIC middleware level
6
You're literally installing a compliance confidence booster
Frequently asked Questions.
What does the Oracle GST Connector do?+
It uploads, reconciles and files GSTR-1, GSTR-3B and IMS directly from Oracle through WhiteBooks' GSP channel — no manual portal work and no JSON juggling.
Does it support multiple GSTINs and legal entities?+
Yes. Multi-GSTIN and multiple legal entities / operating units are managed from one consolidated dashboard, with org-wise mapping.
How does reconciliation work?+
Purchase data is auto-matched against GSTR-2B for ITC, with bulk reconciliation and mismatch reporting surfaced against Oracle Payables.
Can returns be filed in bulk?+
Yes. Batch and scheduled runs let you upload and file across periods and GSTINs during off-peak windows, with a complete audit trail.
What Oracle releases are supported?+
Oracle Fusion Cloud ERP, Oracle E-Business Suite R12 / 12.2 and NetSuite, delivered through REST / SOAP web services and BI Publisher — no core customization.
Get started
Stop manual GST uploads. Start automating today.
Join 100+ Oracle enterprises achieving 100% GST compliance with zero manual work.
100+Enterprise clients
1M+GSTR filings processed
100%Uptime guaranteed
<5 minSetup time