0 Replies Latest reply on Jun 14, 2019 5:15 PM by anasazii

    Create PO using PDOI and use approval hierarchy


      We'd like to use the PDOI to create standard purchase orders, but we want them to go through the standard employee-supervisor hierarchy.  Is this possible?

      So far every one I've tested is just going right to Approved status, even though the user I'm submitting them as does not have the proper approval limits to approve the PO. 


      Here is an example of what fields I'm setting...so for this case the user doesn't have approval limits so I would want the PO to create and then go to their supervisor for approval.  I am using the INITIATE APPROVAL parameter when I submit the Import Standard Purchase Orders request. 


      insert into po.po_headers_interface

      (interface_header_id, action, document_type_code, vendor_id, vendor_site_id, process_code, agent_id, ship_to_location_id,creation_Date, created_by, last_update_date, last_updated_by

      , interface_source_code, org_id, comments



      (po.po_headers_interface_s.nextval, 'ORIGINAL', 'STANDARD', 111, 222, 'PENDING'

      , 777

      , 99999

      , sysdate, 5555, sysdate, 5555

      , 'PO', 12345

      , 'SPEC 123456' -- if you wanted to put any reference numbers here