Sunday 3 February 2013



WHAT IS DIFFERENCE BETWEEN PROCURE TO PAY CYCLE & ORDER TO CASH CYCLE ?

Procure (to get) To Pay Cycle (buying of items to payment of them here company buy  items from vendors)
Procure to pay cycle is genrally applicable to all the client who give their projects to the companies (like techsignia ) here that client will go through the p2p cycle and all its different steps and in this steps , data generated will be stored in tables of different modules , we developer, just make reports using that data in AOL , every client must go through P2P cycle

Exa: for example  techsignia is taking project of bank HDFC in this case HDFC will have its own oracle e business suite license, now HDFC is our client and it will give its data to our team in the form of excel sheet which we will enter into tables by any method, this data entered  will be related to different modules and there tables and it will depend on the cycle like p2p cycle where in our exa bank will first act as client to buy its necessary goods like bank will want to buy computers in this case bank will have different vendors from whom they can buy computers in this case bank will first place the requisition ( demand) to different vendors , then HDFC will  prepare RFQ (request  for quotation ) and send it to different suppliers to get the best and /or economical price for the product . then supplier will reply by sending their quotation to bank ,all these data will be stored in oracle purchasing , and after comparing hdfc will select the best quotation , later hdfc will prepare a purchase order (PO)and shift the orders goods , and will receive the goods and all this data called goods received note (GRN )  will go in oracle purchasing , if HDFC want to receive goods at inventory then entries will make changes in inventory tables , once goods are moved to the inventory all accounting detail will be stored into table oracle general ledger, finally supplier will send invoice for the purchased goods and HDFC will match invoice against purchase order from oracle purchasing in oracle payables . , finally payment is made

The requirement arises from requirements for items,and company places order for items needed.
The vendor supplies the items .Once items are received payment will be made.That is a invoice will be raised and payment will be made to the vendor.The payment can be of cash,cheque etc.

This is governed under cash management and finally the transaction detalis will be accounted in
General Ledger (GL).

In P2P cycle module included are
PO (purchase order )
AR(Account Receivable )
AP(account payable )
CM(cash management)
GL (general ledger )













Requisition
po_requisition_headers_all
po_requisition_lines_all ( segment1 ========== requisition number)
po_req_distributions_all
Note: requisition_header_id is the link between po_requisition_headers_all and po_requisition_lines_all
requisition_line_id is the link between po_requisition_lines_all and po_req_distributions_all

Purchase order
po_headers_all
po_lines_all
po_distributions_all
po_line_locations_all
Note: po_header_id is the link between all these tables

Receipt
rcv_shipment_headers
rcv_shipment_lines
rcv_transactions
quality result stored in qa_results table
Note: shipment_header_id is the link between rcv_shipment_headers and rcv_shipment_lines
po_header_id is the link between rcv_shipment_headers and rcv_transaction

Invoices
ap_invoices_all
ap_invoice_distributions_all-
Note: invoice_id is the link between ap_invoices_all and ap_invoice_distributions_all

Payments
ap_checks_all
ap_invoice_payments_all
ap_payment_schedules_all

Payment Reconcillation
ap_banks
ap_bank_branches

GL Transfer
gl_periods
gl_period_status
gl_set_of_books
glfv_charts_of_accounts

2 comments: