My Oracle Support Banner

SLA: A TECHNICAL PERSPECTIVE OF THE AP TO GL RECONCILIATION (Doc ID 605707.1)

Last updated on JUNE 21, 2023

Applies to:

Oracle Payables - Version 12.0.0 to 12.2 [Release 12.0 to 12.2]
Information in this document applies to any platform.

Purpose

This document offers a technical perspective of the AP-GL Reconcialition. Its purpose is to assist the reader with reconciliation issues. In the simplest terms, AP-GL reconciliation means tallying the amounts in Accounts Payable (i.e., AP) for a CCID/Supplier and reconciling it to the figures in the General Ledger (GL).

This document covers the following topics:

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
 1. UNDERSTANDING THE AP-SLA-GL RECONCILIATION
 2. RECONCILING THE AMOUNTS AND UNDERSTANDING THE DATA FLOW BETWEEN SLA AND GL
 Key Tables and Columns used for Reconciliation
 3. ESTABLISHING A BASELINE FOR ADDRESSING 11i UPGRADE ISSUES
 Scenario
 Technical perspective
 Common Reasons why Reconciliation issues are Encountered During the Upgrade
 Analyzing the Difference in the R12 Trial Balance
 How to Analyze the Data Even Further
 4. RECONCILING R12 DATA AND ADDRESSING R12 TRIAL BALANCE-GL ISSUES
 5. UNDERSTANDING HOW UNDO ACCOUNTING CAN IMPACT RECONCILIATION
 Scenario
 Original Event/Accounting
 How to find events/entities created by Undo Accounting 
 6. APPENDIX
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.