Oracle EBS R12 is the Oracle Enterprise Business Suite widely used in Manufacturing , Retail Applications. Oracle EBS R12 contains different modules to handle Business needs like Oracle Financials, Account Payables (AP), Account Receivables (AR), General Ledger (GL) , Cash Management (CM) , Human Resource Management System (HRMS), Payroll, Order Management, Inventory, Subledger Accounting, Oracle Projects, Oracle Fixed Assets and many more.

The blog provides the commonly used Configurations / Setup in Oracle EBS R12. The blogs also contains useful SQL Queries to retrieve record data from these modules.

Oracle EBS R12 Concurrent Manager Configurations /Setup

Oracle EBS R12 Concurrent Manager Overview

Oracle EBS R12 Concurrent Manager Setup to Change Process Count

Oracle EBS R12 SQL to get Internal Concurrent Manager Details

Oracle EBS R12 Assign concurrent programs to Request Group

SQL Query to retrieve On Hold Concurrent Requests

FND_CONCURRENT_REQUESTS Status Codes and Phase Code values

Oracle EBS R12 SQL to Retrieve Concurrent Program attach to a PL /SQL package

Oracle EBS R12 Assign concurrent programs to Request Group

Oracle EBS R12 Concurrent Request Log and Trace File SQL Query

Oracle EBS R12 SQL Query to get all user responsibilities

Oracle EBS  R12 Account Payables (AP) Configurations /Setup

Account Payables differences in EBS R11i and EBS R12

Oracle Account Payables (AP) Item Type Workflow Error query in Oracle EBS R12

Oracle Account Payables (AP) SQL to get Purchase Order Tax Details in Oracle EBS R12

Oracle Account Payables (AP) SQL to get Invoice Supplier Tax Registration Data in Oracle EBS R12

Oracle Account Payables (AP) returns All Tax Lines on Additional Tax Page in Oracle EBS R12

Oracle EBS R12 SQL to get AP and AGIS Invoices

Oracle EBS R12 SQL get AP cancelled invoices with distribution lines

Oracle EBS R12 SQL to get AP invoices posted to GL

Oracle EBS R12 SQL to get AP Invoice Status

Oracle EBS R12 AR SQL to get Customer Bank details

Oracle Account Receivables (AR) R12 Configurations /Setup

Oracle EBS R12 Account Receivables Transaction Source Setup

Oracle EBS R12 Account Receivables (AR) Tables

Oracle EBS R12 Account Receivables (AR) Transaction Type Setup

Oracle EBS R12 Account Receivables (AR) Payment Terms Setup

Oracle EBS R12 AR Navigation Path

Oracle EBS R12 SQL to get AR and AGIS Invoices

Oracle EBS R12 SQL to get AGIS Matched or Unmatched Account Balances

Oracle EBS R12 AR Receipt Class and Receipt Method SQL

Oracle EBS R12 R12 SQL to get AR Credit Memo Balance Due

Oracle EBS R12 SQL to get AR Open Invoices Customer Transaction Balances

Oracle EBS R12 AR SQL to get Open Invoices with Customer payment status

Oracle EBS R12 AR transaction processing Setup Checklist

Oracle EBS R12 SQL to get General Ledger Posting for AR Invoices

Oracle EBS R12 Account Receivables (AR) Receipt Creation

Oracle EBS R12 AR Receipt status

Oracle EBS R12 AR SQL to get Customer Address

Oracle EBS  R12 General Ledger (GL) Configurations /Setup

EBS R12 General Ledger SQL to get GL Code Combinations records

General Ledger ( GL) differences in EBS 11i and EBS R12

Oracle EBS R12 Journal Import Validation Process

Oracle EBS R12 General ledger interface tables

Oracle EBS R12 SQL Query to delete GL budget lines

Oracle EBS R12 SQL to get Journal Batch workflow Item details

Oracle EBS R12 SQL to get user supervisor authorized limit

Oracle EBS R12 GL Journal Header attributes SQL

Oracle Project R12 Configurations /Setup 

Oracle Projects R12 Key Table Details in Oracle EBS R12

Oracle Projects Setup Checklist in Oracle EBS R12

Oracle Project Costing and Project Billing Setup in Oracle EBS R12

Oracle Project Control Functions and Options in Oracle EBS R12

Oracle Projects WBS, Project Type and Project Numbering Configuration in EBS R12

Oracle Projects Rejected PO in Oracle EBS R12

Oracle EBS  R12 Fixed Assets (FA) Configurations /Setup

Oracle EBS R12 SQL Query to drill down FA Assets to GL

Oracle EBS R12 SQL to fetch fixed asset (FA) invoices

EBS R12 SQL to get fixed asset depreciation details

Oracle EBS  R12 Order Management Configurations /Setup

Oracle EBS R12 Pricing SQL Queries in Order Management

Oracle EBS R12 System Administrator (DBA) Queries

SQL Query to get Customer Tax Registration Header and Site Level data in Oracle EBS R12

Oracle Account Payables (AP) PO SQL to get Tax Code and Tax Rate for EBTAX in Oracle EBS R12

Oracle EBS R12 EBTax Setup and Transactional tables

Oracle EBS R12 SQL to get SQL to get GST TDS Tax Report

Oracle EBS R12 create user and responsibility