Procure to Pay (P2P) Cycle in Oracle Apps Technical

• Create Requisition
• Create Purchase Order
• Create Inventory Receipt
• Enter AP Invoice
• Make Payment
• Transfer to GL

Create Requisition:

Nav: Purchasing à Requisition

Create a purchase requisition.

Tables:

SELECT * FROM PO_REQUISITION_HEADERS_ALL

SELECT * FROM PO_REQUISITION_LINES_ALL
SELECT * FROM PO_REQ_DISTRIBUTIONS_ALL

Create Purchase Order

Nav: Purchasing Responsibility > Auto create

Enter requisition number which is saved and hit search.

Once you find the requisition select it by enabling the checkbox and choose the type of document you want to create and click on Automatic

Now we will select Ship-To field as this is required to create inventory receipt /purchasing receipt.

Tables:

SELECT * FROM PO_HEADERS_ALL
SELECT * FROM PO_LINES_ALL

SELECT * FROM PO_DISTRIBUTIONS_ALL

SELECT * FROM PO_LINE_LOCATIONS_ALL

Create Inventory Receipt

Nav: Purchasing Responsibility > Receiving > Receipts

Enter the Purchase order number to find the PO which is created

Once you create a receipt for PO you will not be allowed to create another receipt for the same PO. It is allowed only in case of partial receipts.           

Tables:

SELECT * FROM RCV_SHIPMENT_HEADERS
SELECT * FROM RCV_SHIPMENT_LINES

SELECT * FROM RCV_TRANSACTIONS 

Once Receipt created we can check whether the requested items are received or not by using these tables in inventory module.
SELECT * FROM MTL_SYSTEM_ITEMS_B
SELECT * FROM MTL_ONHAND_QUANTITIES

Enter AP Invoice and Make payments:

Enter header information in invoice workbench then match the PO and validate the invoice.

Once invoice successfully created without any holds then make payment for the invoice.

Tables:

SELECT * FROM AP_INVOICES_ALL

SELECT * FROM AP_INVOICES_LINES_ALL

SELECT * FROM AP_INVOICE_DISTRIBUTIONS_ALL

To view Invoice holds details:

           Select * from ap_holds_all

To view release the Invoice holds names:

           Select * from ap_holds_release_name_v;

 

Transfer to GL

“Payables Transfer to General Ledger” concurrent program will be executed from SRS screen. This program will transfer all the payment transactions into the G.L Module.

To view from AP to GL:

           Select * from gl_interface;

But in R12 we need to run 'Create Accounting Program' 

In create accounting program window we can see 3 modes

1. Draft : only priview purpose

2. Post : When we select this button sysytem automatically journal entries will be transfer to GL and accounting entries will be genarated.

3. Final post : When we select this button sysytem automatically journal entries will be transfer to GL and accounting entries will be genarated and posted also.

To view journal import details:

           Select * from gl_je_headers       for Headers

           Select * from gl_je_lines            for Lines

           Select * from gl_je_batches       for Batches

To view posting:

           Select * from gl_balances;

Table Joins between PO, AP and GL

Requisitions:

Headers and lines:

requisition_header_id in po_requisition_headers_all = requisition_header_id  in po_requisition_lines_all table.

Lines and distributions:

requisition_line_id in po_req_distributions_all = requisition_line_id in po_requisition_lines_all table.

Requisitions and Purchase Order:

distribution_id in po_req_distributions_all = req_distribution_id in po_distributions_all

Purchase Order to AP Invoices:

Distribution ID in PO_Distributions_All = PO_DISTRIBUTION_ID in ap_invoices_all.

11i AP to GL

When Source is Payable then reference_5 of GL_JE_LINES table is the invoice Number and reference_2 is the invoice_id and Ref3 is the check_id.

R12 Using SLA: