Oracle Apps Procure to Pay(P2P) Cycle ( Technical )

Procure to Pay Cycle:-

In this Article We will see the Tables involved in P2P cycle.

Purchase Requisition

1)po_requisition_headers_all
2)po_requisition_lines_all
3)po_req_distributions_all

Note: requisition_header_id link between po_requisition_headers_all and po_requisition_lines_all
requisition_line_id link between po_requisition_lines_all and po_req_distributions_all

Purchase order

1)po_headers_all
2)po_lines_all
3)po_distributions_all
4)po_line_locations_all

Note: po_header_id is the link between all these tables

Receipt

1)rcv_shipment_headers
2)rcv_shipment_lines
3)rcv_transactions

Note: shipment_header_id link between rcv_shipment_headers and rcv_shipment_line po_header_id   link between rcv_shipment_headers and rcv_transaction

Invoices

1)ap_invoices_all
2)ap_invoice_distributions_all

3)ap_checks_all

4)ap_invoice_payments_all

5)ap_payment_schedules_all

Note: invoice_id link between ap_invoices_all and ap_invoice_distributions_all

GL Transfer

1)gl_periods
2)gl_period_status
3)gl_set_of_books