P2P Cycle in Oracle EBS

P2P Cycle involve following steps
1. Requisition creation
     Requisition is nothing but a formal request to buy something needed for the enterprise.
There are two types of Requisition
     1.Internal Requisition
     2.Purchase Requisition
2.Purchase Order Creation
      There are four types of Purchase Order
     1.Standard PO
     2.Blanket PO
     3.Contract PO
     4.Planned PO
3.GRN (Good Receipt Note) Creation
4.Invoice Creation
5.Payment of Invoice

Following are the tables get affected when user perform P2P Transaction on Application

1. At the time of requisition following tables are get populated

PO_REQUISITION_HEADERS_ALL   holds the Requisition Header Details.
Important Columns of this table are REQUISITION_HEADER_ID and  SEGMENT1 Segment1 holds the requisition number generated by system.

PO_REQUISITION_LINES_ALL  holds the Line Details of Requisition
Important columns of this table are REQUISITION_HEADER_ID and REQUISITION_LINE_ID

PO_REQ_DISTRIBUTIONS_ALL  holds the line distribution details of Requisition Line
Important Columns of this tables are REQUISITION_LINE_ID and DISTRIBUTION_ID

Joins between above three tables

PO_REQUISITION_HEADERS_ALL.REQUISITION_HEADER_ID=PO_REQUISITION_LINES_ALL.REQUISITION_HEADER_ID
PO_REQUISITION_LINES_ALL.REQUISITION_LINE_ID=PO_REQ_DISTRIBUTIONS_ALL.REQUISITION_LINE_ID

2. At the time of  Purchase order following tables are get populated

PO_HEADERS_ALL      This table holds the PO Header Information like PO Number,Vendor, Buyer, Ship to and Bill to Location etc. details.
Important columns of this tables are PO_HEADER_ID and SEGMENT1 segment1 holds the PO Number.

PO_LINES_ALL    This table holds the PO Line details like Item Code, Unit of Measure, Quantity,Price etc.
Important columns of this tables are PO_HEADER_ID and PO_LINE_ID

PO_LINE_LOCATIONS_ALL   This table holds the Shipment details of the PO Line.
Important Columns of this tables are LINE_LOCATION_ID,PO_RELEASE_ID,PO_LINE_ID and PO_HEADER_ID

PO_DISTRIBUTIONS_ALL    This table holds the Distribution details of the PO Line.
Important Columns of this tables are PO_DISTRIBUTION_ID, LINE_LOCATION_ID, PO_RELEASE_ID, PO_LINE_ID and PO_HEADER_ID

JAI_PO_TAXES     This table holds the Tax Details which are applied on PO Line.
Important Columns of this table are LINE_LOCATION_ID,PO_LINE_ID,PO_HEADER_ID,TAX_ID  and TAX_CATEGORY_ID

PO_HEADERS_ALL.PO_HEADER_ID=PO_LINES_ALL.PO_HEADER_ID
PO_LINES_ALL.PO_LINE_ID=PO_LINE_LOCATIONS_ALL.PO_LINE_ID
PO_LINES_ALL.PO_LINE_ID=PO_DISTRIBUTIONS_ALL.PO_LINE_ID
PO_LINES_ALL.PO_LINE_ID=JAI_PO_TAXES.PO_LINE_ID

3. At the time of Receipt (GRN) creation following tables are get populated

RCV_SHIPMENT_HEADERS_ALL  This table holds the Receipt Header Details
Important Columns of this table are SHIPMENT_HEADER_ID and RECEIPT_NUM

RCV_SHIPMENT_LINES
Important Columns of this table are SHIPMENT_HEADER_ID and SHIPMENT_LINE_ID
 
RCV_TRANSACTIONS
Important Columns of this table are SHIPMENT_HEADER_ID,SHIPMENT_LINE_ID, TRANSACTION_ID and TRANSACTION_TYPE

 RCV_SHIPMENT_HEADERS_ALL.SHIPMENT_HEADER_ID=RCV_SHIPMENT_LINES.SHIPMENT_HEADER_ID
 RCV_SHIPMENT_LINES.SHIPMENT_LINE_ID=RCV_TRANSACTIONS.SHIPMENT_LINE_ID
 RCV_SHIPMENT_LINES.PO_LINE_ID=PO_LINES_ALL.PO_LINE_ID

4. At the time of Invoice creation following tables are get populated

AP_INVOICES_ALL
Important Columns of this table are INVOICE_ID,INVOICE_DATE and INVOICE_NUM
 
AP_INVOICE_LINES
Important Columns of this table are INVOICE_ID,RCV_TRANSACTION_ID and RCV_SHIPMENT_LINE_ID
 
AP_INVOICE_DISTRIBUTIONS_ALL
Important Columns of this table are INVOICE_ID,INVOICE_DISTRIBUTION_ID and DIST_CODE_COMBINATION_ID

AP_ACCOUNTING_EVENTS_ALL

 AP_INVOICES_ALL.INVOICE_ID=AP_INVOICE_LINES.INVOICE_ID
 AP_INVOICE_LINES.RCV_SHIPMENT_LINE_ID=RCV_SHIPMENT_LINES.SHIPMENT_LINE_ID
 AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_ID=AP_INVOICE_LINES.INVOICE_ID

5. At the time of Payment entry following tables are get populated

AP_INVOICE_PAYMENTS_ALL
 Important Columns of this table are INVOICE_ID,CHECK_ID and INVOICE_PAYMENT_ID

AP_PAYMENT_SCHEDULES_ALL
 Important Columns of this table are INVOICE_ID and PAYMENT_NUM

AP_CHECKS_ALL
Important Columns of this table are INVOICE_ID,PAYMENT_ID,BANK_ACCOUNT_ID and CHECK_ID

AP_BANK_ACCOUNTS_ALL
 Important Columns of this table are BANK_ACCOUNT_ID,BANK_ACCOUNT_NAME and BANK_BRANCH_ID

AP_BANK_BRANCHES
Important Columns of this table are BANK_BRANCH_ID,BANK_NAME and BANK_BRANCH_NAME.

AP_TERMS 
Important Columns of this table are TERM_ID and NAME


AP_INVOICE_PAYMENTS_ALL.INVOICE_ID=AP_INVOICES_ALL.INVOICE_ID
AP_INVOICE_PAYMENTS_ALL.CHECK_ID=AP_CHECKS_ALL.CHECK_ID
AP_CHECKS_ALL.BANK_ACCOUNT_ID=AP_BANK_ACCOUNTS_ALL.BANK_ACCOUNT_ID
AP_BANK_BRANCHES.BANK_BRANCH_ID=AP_BANK_ACCOUNTS_ALL.BANK_BRANCH_ID

Supplier Tables


AP_SUPPLIERS
Important Columns of this table are VENDOR_ID,VENDOR_NAME and SEGMENT1

AP_SUPPLIER_SITES_ALL
Important Columns of this table are VENDOR_ID,VENDOR_SITE_ID and VENDOR_SITE_CODE

AP_SUPPLIERS.VENDOR_ID=AP_SUPPLIER_SITES_ALL.VENDOR_ID

Join with PO Table
AP_SUPPLIERS.VENDOR_ID=PO_HEADERS_ALL.VENDOR_ID
AP_SUPPLIER_SITES_ALL.VENDOR_SITE_ID=PO_HEADERS_ALL.VENDOR_SITE_ID

 Join with Invoice Table
AP_SUPPLIERS.VENDOR_ID=AP_INVOICES_ALL.VENDOR_ID
AP_SUPPLIER_SITES_ALL.VENDOR_SITE_ID=AP_INVOICES_ALL.VENDOR_SITE_ID