Oracle - Procure To Pay CYCLE

P2P cycle:(procure to pay)

    P2P cycle those 3 applications are.

• Purchasing(PO).
• Account Payable(AP).
• General Ledger(GL).

P2P cycle steps following are:

• create a requisition.
• create a purchase order.
• receipts.
• invoice.
• payments.
• transfer to gl.

TABLES IN P2P CYCLE :

  1. REQUISITION :

           select * from PO_REQUISITION_HEADERS_all;  (HEADER)
           select * from PO_REQUISITION_LINES_all ;  (LINE)
           select * from po_req_distributions_all;        (DISTRIBUTION)

  2. PURCHASE ORDER (PO) :
       
            select * from po_headers_all;   (HEADER)
            select * from po_lines_all;        (LINE)
            select * from po_distribution_all;   (DISTRIBUTION)

  3. RECEIPT :

           select * from rcv_shipment_headers_all; (HEADER)
           select * from rcv_shipment_lines_all;   (LINES)

P2P JOINS :
        REQUISITIONS :

          select *
          from PO_REQUISITION_HEADERS_all rh,
          PO_REQUISITION_LINES_all rl
          where rh.requisition_header_id = rl.requisition_header_id;

       select *
       from PO_REQUISITION_HEADERS_all rh,
       PO_REQUISITION_LINES_all rl,
       po_req_distributions_all rd
       where rh.requisition_header_id = rl.requisition_header_id
       and rd.requisition_line_id = rl.requisition_line_id;

          PURCHASE ORDER :

         select * from  po_headers_all poh ,po_lines_all pol
         where poh.po_header_id = pol.po_header_id;

1. REQUISITION:

• requisitions can also be called requirements.
• it is a document prepared by the customer.

   we have two types of Requisitions
         1)Internal
         2)Purchase

• The internal requisition will be created if materials are received from another Inventory inside of the organization.
• Purchase requisition will be created while purchasing the materials from the Suppliers.

  We will enter the Requisition at three-level
        1)Header
        2)Line
        3)Distributions.

CREATING A REQUISITION FOLLOWING  BY STEPS:

  NAVIGATION: MM PURCHASING A SUPERUSER.
                         |
                    REQUISITION
                         |
                    REQUISITION
HEADER:
      Enter the requisition type as"purchase requisition".

LINE:
     item number:999020
     quantity:5
     price:10

SUPPLIER DETAILS:

     TO ORG: BOISE PLANT
     SUPPLIER: (anything you want)
     SITE    :  (anything you want)

• click on the distribution button to see distribution details for each line.
• click save, and now the requisition number is automatically created.
• note that number: 312176
• click approve and ok.
• to check whether the created requisition was approved or not.
• go to MM PURCHASING SUPER USER - REQUISITION - REQUISITIONS SUMMARY.
• find with created requisition number.

TABLE :
 
           select * from PO_REQUISITION_HEADERS_all;(HEADER)
           select * from PO_REQUISITION_LINES_all ;(LINE)
           select * from po_req_distributions_all;(DISTRIBUTION)

Note :

     segment1- requisition_number
     line    - requisition_header_id

LINK ON THE TABLE TYPE :

    rh.requisition_header_id = rl.requisition_header_id (Requisition header and requisition line)
    rd.requisition_line_id = rl.requisition_line_id  (requisition distributions and requisition line)

2.PURCHASE ORDER(PO):

• the purchase order is a document prepared by the customer and given to the supplier maintaining the goods which he required.
• which contains information on terms and conditions, item details, quantity, price, distribution, shipment details so on.

Types of purchase orders:

1. standard
2. planned
3. blanked
4. contract

CREATING A PURCHASE ORDER (PO) :

NAVIGATION: MM PURCHASING SUPER USER
                      |
                 AUTO-CREATE
                   
               
 -> Enter the requisition number.
 -> remove the buyer.
 -> select the requisition.
 -> click on the automatic button.
 -> next enter the old supplier name.
 -> auto creates to purchase orders window open.
 -> take the purchase order number.
 -> enter the ship to
 -> click on the approve button.
 -> status changed in the approved.
 -> to check whether the created purchase order was approved or not.
 -> go to purchase order
 -> click on the purchase order summary.

TABLE  :
 
           select * from po_headers_all;
           select * from po_lines_all;

LINK ON THE TABLE TYPE :

           poh.po_header_id = pol.po_header_id (PO header po line)