Tables involved in Procure to Pay (P2P) Cycle - Oracle R12

Procure to Pay Lifecycle

Algorithmic representation of P2P Cycle

Purchase Requisition:

PO_REQUISITION_HEADERS_ALL

PO_REQUISITION_LINES_ALL

PO_REQ_DISTRIBUTIONS_ALL

Requisition_header_id is the link between PO_REQUISITION_HEADERS_ALL and PO_REQUISITION_LINES_ALL tables

Requisition_line_id is the link between PO_REQUISITION_LINES_ALL and PO_REQ_DISTRIBUTIONS_ALL tables

Purchase Order:

PO_RELEASES_ALL

PO_HEADERS_ALL

PO_LINES_ALL

PO_LINE_LOCATIONS_ALL

PO_DISTRIBUTIONS_ALL

PO_header_id is the link between all these tables

Receipt:

RCV_SHIPMENT_HEADERS

RCV_SHIPMENT_LINES

RCV_TRANSACTIONS

Shipment_header_id is the link between RCV_SHIPMENT_HEADERS and RCV_SHIPMENT_LINE.

PO_header_id is the link between RCV_SHIPMENT_HEADERS and RCV_TRANSACTIONS

Quality results are stored in QA_RESULTS table

Once the Receipt process is completed, MTL_ONHAND_QUANTITIES table gets updated.

Invoices:

AP_INVOICES_ALL

AP_INVOICE_LINES_ALL

AP_INVOICE_DISTRIBUTIONS_ALL

Invoice_id is the link between all these tables

Payments:

AP_INVOICE_PAYMENTS_ALL

AP_PAYMENT_SCHEDULES_ALL

Check’s information will be stored in AP_CHECKS_ALL table.

Check format information will be stored in AP_CHECK_FORMATS table.

Note:

RFQ & Quotation records also get stored in the same PO_HEADERS_ALL table, but with type_lookup_code as ‘RFQ’ and ‘QUOTATION’ respectively.

---X---