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 );
I resolved this by playing with the parameters. P_AUTO_CLOSE => 'N',
I did not put in a line id.