2 Replies Latest reply on Feb 22, 2012 3:14 AM by Paarthy-Oracle

    Linking a manually created PO with a PR

    918571
      Hi

      Is it possible to link a manually created purchase order with a PR in database?

      regards,
        • 1. Re: Linking a manually created PO with a PR
          Mahendra
          Hi

          Is it possible to link a manually created purchase order with a PR in database?

          regards,
          Typical workaround..don't know whether it will fit you
          What we do here is..we go to auto create select the requisition which we want to add to exiting standard PO then go to PO delete the line(cancel PO line) which was original available in the PO..so we left with the requisition line which we copied from the auto create..which is been referenced now..

          But this requisition will not be viewed from PO summary..as this is not the one which is originally created from auto create

          I think it can be done via updating backend tables....

          HTH
          Mahendra

          Edited by: 843237 on Feb 20, 2012 3:37 PM

          Edited by: 843237 on Feb 20, 2012 3:39 PM
          • 2. Re: Linking a manually created PO with a PR
            Paarthy-Oracle
            Hi,
            Please refer the below MOS Note : How to Get the Purchase Order (PO) Number From a Requisition Number Via the Tables (Doc ID 169095.1)

            To get a PO number from a Requisition number via the tables, run the following
            script:

            SELECT poh.segment1, pol.line_num, poll.shipment_num
            FROM po_headers_all poh, po_lines_all pol,
            po_line_locations_all poll,
            po_requisition_headers_all porh,
            po_requisition_lines_all porl
            WHERE porh.requisition_header_id = porl.requisition_header_id
            and porl.line_location_id = poll.line_location_id
            and poh.po_header_id = pol.po_header_id
            and pol.po_line_id = poll.po_line_id
            and porh.segment1 = ####;

            If you check the above query, you will understand- how they are linked.
            porl.line_location_id should be equal to poll.line_location_id.

            However, I wont suggest you to manually create the link, as it may cause few problems:
            The approved requisition will have separate entry in Supply tables (mtl_supply) and PO will have separate entry . (ideally, if it is autocreated - it should have a single entry).
            If you have encumbrance enabled, it might cause other issues with requisition encumbrance and po encumbrance
            If you cancel the PO, not sure whether the backing requisition too will get canceled without any issue.

            Personally i feel, it is not the good practise to establish the link manually.