Oracle Receivables R12 AR Receipts SQL Queries

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 […]

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 […]

Scroll to top