1 Reply Latest reply on Aug 1, 2014 6:42 PM by user1047506

    I am trying to run PO_ACTIONS.CLOSE_PO  it is not closing POs

    user1047506

      I am on EBS 12.1.3

      I wrote a stored procedure to close POs coming from a temp table.

      I sometimes get a return code of False and sometimes TRUE.  Either way it does not close the POs.

      I have looked through many things like using "CLOSE" and CLOSED for P_ACTION.

      I have had the  P_AUTO_CLOSE  as Y and N.

      I have even hard coded in all the values and it does not work.

      Any assistance would be appreciated.

       

      l_result  :=    PO_ACTIONS.CLOSE_PO(

                P_DOCID => v_po_header_id,

                P_DOCTYP => 'PO',

                P_DOCSUBTYP => 'STANDARD', -- Can be STANDARD, BLANKET, RELEASE

                P_LINEID => NULL, -- If want to close Line

                P_SHIPID => NULL,-- If want to close Shipment

                P_ACTION => 'CLOSE',

                P_REASON => 'Close Purchase Order',

                P_CALLING_MODE => 'PO',

                P_CONC_FLAG => 'N',

                P_RETURN_CODE => lv_return_code,

                P_AUTO_CLOSE => 'Y',

                P_ACTION_DATE => sysdate,

                P_ORIGIN_DOC_ID => NULL );

              commit;