Oracle EBS R12: Query for SLA-GL Reconciliation of Payables Accounts (Liability, Prepayments etc.)

The Query provided in this post can be used to reconcile a Payables control Account to GL. This may be a liability account or a prepayment account:

Continue reading


Oracle EBS R12: Query for Inventory AP Reconciliation SLA to GL

The query provided in this post will provide you with the complete list of transactions that sum up to make your AP Accrual Balance in General Ledger. You may amend the query to run for whatever date range/GL Accrual Account you require, and any other columns you see fit:

Continue reading