P2P Cycle

P2P CYCLE:

Inventor

     |

Requisition

     |

RFQ

     |

Quotation ß supplier

     |

Quotation analysis

     |

Purchase orderàsupplier

     |

invoiceàgoodsàsupplier

     |

validate

     |

Payment

     |

invoice created by payables

     |

transfer to gl

     |

unposted journal will be created

     |

Posted

P2P CYCLE

1.0 Creation of Requisitions

SELECT * FROM PO_REQUISITION_HEADERS_ALL WHERE SEGMENT1=5671

SELECT * FROM PO_REQUISITION_LINES_ALL

WHERE REQUISITION_HEADER_ID = (SELECT REQUISITION_HEADER_ID FROM PO_REQUISITION_HEADERS_ALL WHERE SEGMENT1='5671')

Ø  After saving the REQUISITION initially Status at the header level is incomplete and press APPROVE tab for the approval.

Ø  This is sent for the approval and if it has been approved then the STATUS is converted APPROVED.

 

      

2.0 Creating Purchase Order against the Requisition:

Ø  Either you can create manually or using auto create a PURCHASE ORDER.

Ø  In this opting to choose Autocreate.

>Click the Auto create option

Ø Click Automatic

Ø Click Create to automatically create the purchase order

Ø If you want to define shipment schedules then define by pressing Shipments  tab

Ø save the record and submit for APPROVAL. Now the  STATUS becomes approved  after approving by corresponding Approver.

At back end they are stored in:

> All Header level information is stored in

SELECT * FROM PO_HEADERS_ALL WHERE SEGMENT1=4500

Ø  All line level information is stored in:

SELECT * FROM PO_LINES_ALL

WHERE PO_HEADER_ID= (SELECT PO_HEADER_ID FROM PO_HEADERS_ALL WHERE SEGMENT1=4500)

Ø  All shipment schedules details are stored:

SELECT * FROM PO_LINE_LOCATIONS_ALL

WHERE PO_HEADER_ID=(SELECT PO_HEADER_ID FROM PO_HEADERS_ALL WHERE SEGMENT1=4500)

   > All the Distribution information stored in

SELECT * FROM PO_DISTRIBUTIONS_ALL

WHERE PO_HEADER_ID=(SELECT PO_HEADER_ID FROM PO_HEADERS_ALL WHERE SEGMENT1=4500).

3.0 Receiving against the Purchase Order

Ø Change the receiving Organization before you create a receipt to which org you supposed to ship the goods.

Ø If it is a ordered Receipt  then enter the Purchase Order Number against which you have to receive

>Click Find

Ø Receive the goods against that Purchase Order

At back end they are stored in

SELECT * FROM RCV_SHIPMENT_HEADERS

        WHERE RECEIPT_NUM =9621

 SELECT * FROM RCV_SHIPMENT_LINES

 WHERE SHIPMENT_HEADER_ID IN (SELECT SHIPMENT_HEADER_ID

                         FROM RCV_SHIPMENT_HEADERS   

        WHERE RECEIPT_NUM =9621 AND SHIPMENT_HEADER_ID=69428)

> The more Tables that are affected are

       Select * from RCV_TRANSACTIONS

          Where PO_HEADER_ID IN (SELECT PO_HEADER_ID

                                  FROM PO_HEADERS_ALL

                                   WHERE SEGMENT1=4500) 

SELECT *

FROM mtl_material_transactions

WHERE RCV_TRANSACTION_ID IN (select TRANSACTION_ID

    From RCV_TRANSACTIONS                                                                                                

            Where PO_HEADER_ID IN (SELECT PO_HEADER_ID FROM

                       PO_HEADERS_ALL WHERE SEGMENT1=4500))

        

           

    

4.0 Creation of Invoice

Ø Switch  responsibility to Payables Manager( AP module)

Ø Match it with either a purchase Order or Receipt.

                     Initially Invoice status will be Not Validated

                     Approval Status will be Required Approval

Ø Then go for  Actions Tab

                Actions   -> Validate check and press Ok.

Ø See for Holds if any  and Release the holds

                     Actions    -> Release Holds

> Then check the ‘Force Approval’   Press OK.

> Then check ‘Create Accounting’ Press Ok.

> For Payment

>Press actions     

At back end they are stored in:

The tables that are going to be impacted are

1. AP_INVOICES_ALL
2. AP_INVOICE_DISTRIBUTIONS_ALL

    SELECT *

  FROM AP_INVOICES_ALL

  WHERE INVOICE_NUM=4579

SELECT *

FROM AP_INVOICE_DISTRIBUTIONS_ALL

WHERE INVOICE_ID IN (SELECT INVOICE_ID

                       FROM AP_INVOICES_ALL

                       WHERE INVOICE_NUM='4579')

Payments are made in & it depends on the payment terms

At back end they are stored in:

Tables affected are:

 SELECT *

FROM AP_PAYMENT_SCHEDULES_ALL

WHERE INVOICE_ID IN (SELECT INVOICE_ID FROM AP_INVOICES_ALL

                        WHERE INVOICE_NUM='4579')

SELECT *

FROM AP_INVOICE_PAYMENTS_ALL

WHERE INVOICE_ID IN (SELECT INVOICE_ID FROM AP_INVOICES_ALL --63568

                        WHERE INVOICE_NUM='4579')

SELECT *

FROM AP_PAYMENT_DISTRIBUTIONS_ALL

WHERE INVOICE_PAYMENT_ID IN (SELECT INVOICE_PAYMENT_ID

FROM AP_INVOICE_PAYMENTS_ALL

WHERE INVOICE_ID IN (SELECT INVOICE_ID FROM AP_INVOICES_ALL  --63568

                        WHERE INVOICE_NUM='4579'))

SELECT *

FROM AP_CHECKS_ALL

   WHERE CHECK_ID=28698   à Corresponding vendor_id and bank_account is related to that particular vendor

6.0 Reconciling Bank Accounts in Cash Management Module

At back end they are stored in:

SELECT STATEMENT_HEADER_ID FROM CE_STATEMENT_HEADERS_ALL

WHERE STATEMENT_HEADER_ID =75826

SELECT * FROM CE_STATEMENT_LINES

WHERE STATEMENT_HEADER_ID IN (SELECT STATEMENT_HEADER_ID

                            FROM CE_STATEMENT_HEADERS_ALL                                                   

                           WHERE STATEMENT_HEADER_ID =75826)

Ø  After these Invoice’s are transferred to GL by running

  Payables Transfer to General Ledger  PROGRAM

The tables affected are

    GL_JE_BATCHES

    GL_JE_HEADERS

    GL_JE_LINES