The blog provides the commonly used SQL Queries to reconcile the Oracle Receivables R12 AR Receipts to get accounted AR Receipts with GL Code Combinations, AR Payments received through checks , AR Receipts processing details, etc. Oracle AR Receipts Tables The below given are the Oracle AR Receipts tables in Oracle Receivables R12 Oracle AR […]
Oracle Standard programs in Account Payables R12
The blog provides the Oracle Payables Standard Programs provided in Oracle Account Payables R12. The Oracle Payables Standard Program helps in processing the Payables Invoices and get accounted into General Ledger for specified accounting period Oracle Payables R12 Standard Programs The below given are the Oracle Payable programs Oracle Payables R12 Standard Programs Payables Program […]
Oracle Payables R12 Sweep Program to process unaccounted transactions
The blog discuss the process on running the Sweep Program for processing the unaccounted transactions in Oracle Payables R12. When the Account Payables Period is closed there could be the possibility of pending AP transactions which are not accounted for that particular period which are considered as ‘unaccounted transactions in accounting period’ . Due to […]
Auto Accounting Rules in Oracle Account Receivables (AR)
The blog discuss about the Accounting Rule Configuration in Oracle Account Receivables R12. Accounting Rule in Oracle Receivables allows to create Invoice Revenue Recognition schedule for the invoices to be processed. Accounting rule determines number of periods and revenue percentage to be recorded for each accounting period. Accounting rules can be configured for the AutoInvoices […]
Define Period Type and Accounting Calendar in Oracle EBS R12
The below steps need to be performed for setting up Period Type in Oracle EBS /Apps R12 Why we need Adjustment Period ? Adjustment Period is used to make adjustment to manage the accounting entries for the reconciliation of Financial Periods. The Adjustment Period is not visible in General Ledger. Calendar Types in Oracle EBS […]