Oracle E-Business Suite (EBS) – Overview, Modules & Business Benefits

• Oracle EBS stands for Enterprise Business Suite.
• Oracle E-Business Suite (EBS) is an internet-enabled product that can be managed from a single site. 
• A company can operate a single data centre with a single database, similar to other ERP products. 
• Oracle EBS includes the company’s enterprise resource planning (ERP) product as well as supply chain management (SCM) and customer relationship management (CRM) applications.
• Each application is licensed separately so companies can select the combination that is suitable for their business processes.

The applications found in the Oracle EBS include:

Oracle CRM

Oracle Financials

Oracle Human Resource Management System (HRMS)  

Oracle Logistics

Oracle Supply Chain Applications 

Oracle Order Management

Oracle Transportation Management

Oracle Warehouse Management System

Supply Chain Management modules like Inventory, Purchasing, Advanced Pricing, and Order Management.

CRM Modules :
   Customer data integration
   Quote and order capture

Financials Modules :
    General Ledger
    Account Payable
    Account Receivable

Supply Chain Applications :
   Inventory
   Purchasing
   Order Management

Oracle EBS SHORTCUT IMAGES :

Key SQL Queries for Purchase Requisition, PO, and Receipt in Oracle Apps R12

SELECT prha.segment1 requisition_number,
       prha.type_lookup_code,
       prha.authorization_status,
       prla.item_description,
       prla.quantity,
       pha.type_lookup_code,
       pha.segment1 po_number,
       pha.document_creation_method,
       pla.item_id,pla.list_price_per_unit,rsh.receipt_num
FROM  po_requisition_headers_all prha,--REQUISITION HEADERS TABLE
      po_requisition_lines_all  prla,--REQUISITIONS LINES TABLE
      po_req_distributions_all prda,--REQUISITIONS DISTRIBUTION TABLE
      po_headers_all pha, --PURCHASE ORDER HEADER TABLE
      po_lines_all pla,--PURCHASE ORDER LINE TABLE
      po_distributions_all pda,--PURCHASE ORDER DISTRIBUTIONS TABLE
      rcv_shipment_headers rsh,--RECEIPT HEADER TABLE
      rcv_shipment_lines rsl--RECEIPT LINE TABLE
WHERE prha.requisition_header_id = prla.requisition_header_id
and  prla.requisition_line_id = prda.requisition_line_id
and  pha.po_header_id = pla.po_header_id
and pla.po_line_id = pda.po_line_id
and prda.distribution_id = pda.req_distribution_id
and rsh.shipment_header_id = rsl.shipment_header_id
and pha.po_header_id = rsl.po_header_id
--and   prha.segment1 = '336276';
and rsh.shipment_header_id = '23163104';

Back Orders Query in Oracle Apps R12 – Track Pending Orders with SQL

SELECT *
  FROM oe_order_headers_all ooha,
       wsh_delivery_details wdd,
       oe_order_lines_all oola
 WHERE     ooha.header_id = oola.header_id
       AND ooha.header_id = wdd.source_header_id
       AND wdd.released_status = 'B'
       AND NOT EXISTS
                  (SELECT 1
                     FROM wsh_delivery_details wdd1
                    WHERE     wdd1.released_status != 'B'
                          AND wdd1.source_header_id = ooha.header_id);

Relationship Between Requisition and Purchase Order in Oracle Apps R12 – Explained with Tables

SELECT prha.segment1 "REQ NUM", pha.segment1 "PO NUM"
  FROM po_headers_all pha,
       po_distributions_all pda,
       po_req_distributions_all prda,
       po_requisition_lines_all prla,
       po_requisition_headers_all prha
 WHERE     pha.po_header_id = pda.po_header_id
       AND pda.req_distribution_id = prda.distribution_id
       AND prda.requisition_line_id = prla.requisition_line_id
       AND prla.requisition_header_id = prha.requisition_header_id
       order by prha.segment1 desc;

How to Find All Canceled Requisitions in Oracle Apps R12 – SQL Query Guide

SELECT  prha.*
 FROM  po_Requisition_headers_all prha, po_action_history pah
 WHERE     1 = 1
       AND pah.object_id = prha.requisition_header_id
       AND action_code = 'CANCEL'
       AND pah.object_type_code = 'REQUISITION'
       ORDER BY requisition_header_id desc;