Scribd Logo
Upload

Welcome to Scribd!

  • 503 views

    Oracle Apps P2P Cycle With Technical Info

    Uploaded by

    VCJyothi
    The document describes the procure to pay (P2P) cycle in Oracle Apps, including: 1) Requisition creation and approval, purchase order creation against approved requisitions 2) Receiving goods against purchase orders 3) Invoice creation and validation in accounts payable module 4) Payment processing against validated invoices 5) Transfer of payables transactions to the general ledger module

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Oracle Apps P2P Cycle With Technical Info

    Uploaded by

    VCJyothi
    503 views5 pages
    The document describes the procure to pay (P2P) cycle in Oracle Apps, including: 1) Requisition creation and approval, purchase order creation against approved requisitions 2) Receiving goods against purchase orders 3) Invoice creation and validation in accounts payable module 4) Payment processing against validated invoices 5) Transfer of payables transactions to the general ledger module

    Original Description:

    Oracle apps P2P Cycle with technical info

    Original Title

    Oracle apps P2P Cycle with technical info

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document describes the procure to pay (P2P) cycle in Oracle Apps, including: 1) Requisition creation and approval, purchase order creation against approved requisitions 2) Receiving goods against purchase orders 3) Invoice creation and validation in accounts payable module 4) Payment processing against validated invoices 5) Transfer of payables transactions to the general ledger module

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    503 views5 pages

    Oracle Apps P2P Cycle With Technical Info

    Uploaded by

    VCJyothi
    The document describes the procure to pay (P2P) cycle in Oracle Apps, including: 1) Requisition creation and approval, purchase order creation against approved requisitions 2) Receiving goods against purchase orders 3) Invoice creation and validation in accounts payable module 4) Payment processing against validated invoices 5) Transfer of payables transactions to the general ledger module

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 5
    At a glance
    Powered by AI
    The key takeaways from the document are the overall procure to pay cycle in Oracle Apps, including the main steps such as requisition, purchase order, receiving, invoice, and payment. It also details the backend tables involved at each step and the responsibilities involved throughout the process.

    The main steps in the procure to pay cycle described in the document are: requisition, purchase order, receiving, invoice, payment, and payables transfer to GL.

    The document lists the following backend tables that store information at each step: requisition headers and lines, purchase order headers and lines, receipts headers and lines, invoice headers and lines, payment schedules, checks, journal headers, journal lines, and journal batches.

    P2P : Procure to Pay Cycle in Oracle Apps

    P2P CYCLE:
    INVENTORY=>
    REQUIESTITION=>
    RFQ=>
    QUOTATION=>
    QUOTATION ANALYSIS=>
    PURCHASE ORDER =>
    INVOICE =>
    VALIDATE INVOICE =>
    PAYMENT =>
    TRANSFER TO GL =>
    UNPOSTED JOURNAL=>
    POST THE JOURNAL IN GL
    ​DETAIL TECHNICAL DESCRIPTION ABOUT P2P CYCLE :

    Creation of Requisition :
    When organization's any item stock ended they raise requisition to get quotation against that
    item from diffrent vendor.
    Requisition raise in Purchase order Responsibility.

    Navigation : Purchase Order Superuser -> Requisition -> Requisitions

    Backend Table Detail :

    a) PO_REQUISITION_HEADERS_ALL (Requisition Header Information) :


    Select *
    from PO_REQUISITION_HEADERS_ALL
    where segment1 = '1234' -- segment1 will be rerequisition number

    b) PO_REQUISITION_LINES_ALL (Requisition Lines Information ):


    select *
    from PO_REQUISITION_LINES_ALL
    where requisition_header_id =
    (Select requisition_header_id
    from PO_REQUISITION_HEADERS_ALL
    where segment1 = '1234')

    Kindly press Approve button which send requisition for approval. Once it get approved from
    Manager its status will get change to 'APPROVED' from 'INCOMPLETE'

    2. Creation of Purchase Order (PO) against Requisition :


    PO we can either create manually or using auto create option in Purchase order responsibility.

    Navigation : Purchase order Responsibility -> Purchase Orders -> Purchase Orders

    -> Click on Auto Create option on Purchase order screen


    -> Search requisition '1234' detail
    -> Click Automatic
    -> it will create Purchase Order.
    -> Kindly enter shipment details with ship-to details
    -> Save Record and Submit For approval. Its status become APPROVED once approver
    approve PO.

    Backend Table Details :

    a) PO_HEADERS_ALL (Po Header Information) :


    Select *
    From PO_HEADERS_ALL
    where segment1='5700' -- segment1 is Po Number

    b) PO_LINES_ALL (PO Line Level information) :


    Select *
    From PO_LINES_ALL
    where Po_header_id =
    ( Select po_header_id
    From PO_HEADERS_ALL
    where segment1='5700')

    c) PO_LINE_LOCATIONS_ALL (PO shipment schedule information ):


    Select *
    From PO_LINE_LOCATIONS_ALL
    Where Po_header_id =
    ( Select Po_header_id
    From PO_HEADERS_ALL
    where segment1='5700')

    d) PO_DISTRIBUTIONS_ALL (Distribution Information) :


    Select *
    From PO_DISTRIBUTIONS_ALL
    Where Po_header_id =
    ( Select Po_header_id
    From PO_HEADERS_ALL
    where segment1='5700')
    3. Receiving Against Purchase Order
    Purchasing Responsbility change the receiving Organization before we create receipt to which
    org you supposed to ship the goods.
    You can do this by entering PO number against which we want to recive.

    Navigation : Purchasing Responsibility -> Receiving -> Receipt


    -> Enter PO Number and click on Find
    -> Receive the good against PO Number

    Backend Table Details :


    a) RCV_SHIPMENT_HEADERS (Receipts Header Information )
    Select * from RCV_SHIPMENT_HEADERS
    where po_header_id =
    ( Select Po_header_id
    From PO_HEADERS_ALL
    where segment1='5700');

    b) RCV_SHIPMENT_LINES (Receipts Lines Information)


    Select * from RCV_SHIPMENT_LINES
    where shipment_header_id =
    (Select shipment_header_id
    from RCV_SHIPMENT_HEADERS
    where po_header_id =
    ( Select Po_header_id
    From PO_HEADERS_ALL
    where segment1='5700')
    );

    c) RCV_TRANSACTIONS (Receipt Transaction Information)


    Select * from RCV_TRANSACTIONS
    where po_header_id =
    ( Select Po_header_id
    From PO_HEADERS_ALL
    where segment1='5700');

    4. Creation of Invoice in Account Payables

    Now you need to switch Responsibility from Purchasing to Payables (AP Module)

    Navigation : Payables Responsibility -> Invoices -> Invoice


    It will takes you to invoice workbench form.
    Enter details on header like Invoice type (Standard, DM, CM etc), Supplier Name, Supplier Site
    etc.
    -> Match invoice against PO Number or Receipt Number.
    -> Initially its status will be Not Validated.
    -> Go to Action -> Check Validate and press OK
    -> See for Hold, If holds present then Release Hold.
    -> Click on check box Force Approval. Press OK.
    -> Click on 'Create Accounting' Check box and press OK.
    Now Invoice is ready for Payments.

    Backend Table Details :


    a) AP_INVOICES_ALL (Invoice Header information)
    Select * From AP_INVOICES_ALL
    where po_header_id =
    ( Select Po_header_id
    From PO_HEADERS_ALL
    where segment1='5700');

    b) AP_INVOICE_LINES_ALL (Invoice Lines Information)


    Select * from AP_INVOICE_LINES_ALL
    where invoice_id =
    (Select invoice_id
    From AP_INVOICES_ALL
    where po_header_id =
    ( Select Po_header_id
    From PO_HEADERS_ALL
    where segment1='5700'));

    c) AP_INVOICE_DISTRIBUTIONS_ALL (Invoice Distributions information)


    Select * from AP_INVOICE_DISTRIBUTIONS_ALL
    where invoice_id =
    (Select invoice_id
    From AP_INVOICES_ALL
    where po_header_id =
    ( Select Po_header_id
    From PO_HEADERS_ALL
    where segment1='5700'));

    5. Payments done against Invoice in Payables

    Navigation : Payables Responsibility -> Payments -> Payments

    Backend Table Details :


    a) AP_PAYMENT_SCHEDULES_ALL (Payment Details)
    Select *
    from AP_PAYMENT_SCHEDULES_ALL
    WHERE invoice_id =
    (select invoice_id
    from AP_INVOICES_ALL
    WHERE po_header_id =
    ( Select Po_header_id
    From PO_HEADERS_ALL
    where segment1='5700'));

    b) AP_CHECKS_ALL (Checks Details)


    Select * from AP_CHECKS_ALL
    where Check_num='Chq-1234';

    6. Payables Transfer To GL
    Kindly Run Payables Transfer To GL Program from Payables Responsibilty.
    It will transfer Payables Data into Gl modules.

    Backend Tables Details :


    a) GL_JE_HEADERS (Journal Headers Information)
    Select * from GL_JE_HEADERS

    b) GL_JE_LINES (Jornal Lines Information)


    Select * from GL_JE_LINES

    c) GL_JE_BATCHES (Journal Batch Information )


    Select * from GL_JE_BATCHES;

    You might also like