Oracle Financials for India (OFI) GST Reconciliation Framework
(Doc ID 2356043.1)
Last updated on JUNE 21, 2023
Applies to:
Oracle Financials for India - Version 12.1 and laterInformation in this document applies to any platform.
Purpose
Build a GST Reconciliation framework which identifies for any combination of given Registration No., Operating Unit, Organization, date range etc...all the problematic GST transactions having tax amount mismatch.
This is an important tool to be used in reconciling the GST tax amounts for a given period.
Following cases are covered in this note:
I. OFI Transaction tax amount is NOT matching with that of the GST Subledger.
II. OFI Transactions tax amount is NOT matching with that of the corresponding GL Entry.
III OFI subledger tax amount is NOT matching with that of the corresponding GL Entry.
This Framework can be used to reconcile the tax data for the following transaction sources:
Payables | Standard Invoice, Credit Memo, Debit Memo, Prepayment |
Receivables | Invoice, Credit Memo, Debit Memo, Advance Receipts |
PO Receiving | Receiving, Delivery, Return to Receiving, Return to Vendor, Corrections |
OM Shipments | Delivery |
Troubleshooting Steps
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
Purpose |
Troubleshooting Steps |
A. Concurrent Program Based |
B. SQL's Based |
Sl# |
Transaction Source |
Data Corruption Nature |
Identification Query |