P2P Description

Here in this post, I tried to explain the steps involved in Procure to Pay Cycle. This is a pure functional Stuff and helps you to understand the navigation steps.

I tried to keep as simple as Possible for clear understanding. The screenshots given below are taken from R12.1.1 apps instance.

Stage 1: Choosing an Item

Let us choose an item to be procured in our example. 

Go to Purchasing Responsibility and follow the below navigation to check for the suitable item.

 

The item picked for our example should be purchasable item as above. Click on tools and choose “Categories” to view the below screen.

Stage 2: Creation of Requisition

Follow the below Navigation to reach Requisition Form. 

Create a new Requisition for the item viewed in Stage 1.

Click on Distributions to View the charge Account.

 

Save and Submit for Approval

 

Now note down the Requisition number and open the “Requisition Summary Form” to view the status of it. For our Example, Requisition number is: 14855

Stage 3 : Checking the Status of Requisition

 Query for the Requisition Number and click Find.

 Here for our example purpose, I kept the submitted and approved person has same and hence it shows the status as approved.

 To see the approval status, please follow the below navigation. 

  

Stage 4 : Creation of Purchase Order

For creating a Purchase order, let us use the “Autocreate Documents” Form. Follow the below Navigation

 Query for the Requisition

 Click on Automatic as shown in the above figure to create a Purchase Order

  

Click on “Create” button to create a Purchase order

  

 View the shipment screen to change the “Match Approval Level” to “2-Way”.

Click the “Receiving Controls” to make sure that the “Routing” is made as “Direct Routing”

 Click Save and submit for Approval.

                                     

 Note down the PO Number.

  

Stage 5: Creation of Receipts

Query with the Purchase order created in the above stage.

 Check the check box near to the lines that are received and click save.

  

Click the “Header Button” to view the Receipt Number.

You will be able to see if:Receiving Transaction Processor is completed successfully.

Stage 6: Checking the On Hand

 Go to any Inventory Responsibility and follow the below Navigation

 Query for our Receipt and make sure the Organization is the same as we received.

 Below screen will show that our inventory has been increased by 5 quantities.

Stage 7: Check the Material Transactions

Follow the below Navigation to reach “Material Transactions” Form

 Query for the item and date as below

 Below screen shows the source and transaction Type

 Below screen shows you the Serial Numbers of the items received.

  

Stage 8: Creation of Invoice

Navigate to any Purchasing Responsibility and view à Requests 

Submit the below requests by providing the Receipt number as Parameter to create an invoice.

 Check the status of the program.

Stage 9: Checking the Invoice

Change to any Payables Responsibility and open the invoices Form.

Query for the Purchase order as below,

                                   

 Click “Actions” Button then tick the “Validate Check Box” and press “Ok” to validate the invoice

  

Below screenshot will give you the status of the invoice

  

Stage 10: Creation of Accounting and Payment

Once invoice got approved, we can “Create Accounting” and “Create Payments” via “Action” Button in the “InvoiceForm” as we validated the invoice.

Thus the brief description of P2P cycle came to end.  

QUARY:

SELECT

A.ORG_ID "ORG ID",

E.VENDOR_NAME "VENDOR NAME",

UPPER(E.VENDOR_TYPE_LOOKUP_CODE) "VENDOR TYPE",

F.VENDOR_SITE_CODE "VENDOR SITE",

F.ADDRESS_LINE1 "ADDRESS",

F.CITY "CITY",

F.COUNTRY "COUNTRY",

TO_CHAR(TRUNC(D.CREATION_DATE)) "PO DATE",

D.SEGMENT1 "PO NUMBER",

D.TYPE_LOOKUP_CODE "PO TYPE",

C.QUANTITY_ORDERED "QTY ORDERED",

C.QUANTITY_CANCELLED "QTY CANCALLED",

G.ITEM_DESCRIPTION "ITEM DESCRIPTION",

G.UNIT_PRICE "UNIT PRICE",

(NVL(C.QUANTITY_ORDERED,0)-NVL(C.QUANTITY_CANCELLED,0))*NVL(G.UNIT_PRICE,0) "PO Line Amount",

(SELECT

DECODE(PH.APPROVED_FLAG, 'Y', 'Approved')

FROM PO.PO_HEADERS_ALL PH

WHERE PH.PO_HEADER_ID = D.PO_HEADER_ID) "PO STATUS",

A.INVOICE_TYPE_LOOKUP_CODE "INVOICE TYPE",

A.INVOICE_AMOUNT "INVOICE AMOUNT",

TO_CHAR(TRUNC(A.INVOICE_DATE)) "INVOICE DATE",

A.INVOICE_NUM "INVOICE NUMBER",

(SELECT

DECODE(X.MATCH_STATUS_FLAG, 'A', 'Approved')

FROM AP.AP_INVOICE_DISTRIBUTIONS_ALL X

WHERE X.INVOICE_DISTRIBUTION_ID = B.INVOICE_DISTRIBUTION_ID)"Invoice Approved?",

A.AMOUNT_PAID,

H.AMOUNT,

I.CHECK_NUMBER "CHEQUE NUMBER",

TO_CHAR(TRUNC(I.CHECK_DATE)) "PAYMENT DATE"

FROM AP.AP_INVOICES_ALL A,

AP.AP_INVOICE_DISTRIBUTIONS_ALL B,

PO.PO_DISTRIBUTIONS_ALL C,

PO.PO_HEADERS_ALL D,

AP_SUPPLIERS E,

AP_SUPPLIER_SITES_all F,

PO.PO_LINES_ALL G,

AP.AP_INVOICE_PAYMENTS_ALL H,

AP.AP_CHECKS_ALL I

WHERE A.INVOICE_ID = B.INVOICE_ID

AND B.PO_DISTRIBUTION_ID = C. PO_DISTRIBUTION_ID (+)

AND C.PO_HEADER_ID = D.PO_HEADER_ID (+)

AND E.VENDOR_ID (+) = D.VENDOR_ID

AND F.VENDOR_SITE_ID (+) = D.VENDOR_SITE_ID

AND D.PO_HEADER_ID = G.PO_HEADER_ID

AND C.PO_LINE_ID = G.PO_LINE_ID

AND A.INVOICE_ID = H.INVOICE_ID

AND H.CHECK_ID = I.CHECK_ID

AND F.VENDOR_SITE_ID = I.VENDOR_SITE_ID

AND C.PO_HEADER_ID IS NOT NULL

AND A.PAYMENT_STATUS_FLAG = 'Y'

AND D.TYPE_LOOKUP_CODE != 'BLANKET'