This content has been marked as final. Show 8 replies
There is no api to finally close PO.
Can you please use the PO_ACTIONS.CLOSE_PO API to Finally Close the PO by providing the following condistions?
x_action constant varchar2(20) := 'FINALLY CLOSE';
x_calling_mode constant varchar2(2) := 'PO';
x_conc_flag constant varchar2(1) := 'N';
x_auto_close constant varchar2(1) := 'N';
Please let me know if you succeed or not.
I will try Finally close, Any API for Freeze,hold ad Unfreeze ?
PO_CLOSE API alowed me to finally close the PO.
Here is the script if anybody interested,
v_result := PO_ACTIONS.CLOSE_PO(
P_DOCID => v_header_id,
P_DOCTYP => 'PO',
P_DOCSUBTYP => 'STANDARD',
P_LINEID => NULL,
P_SHIPID => NULL,
--P_ACTION => 'CLOSE',
P_ACTION => 'FINALLY CLOSE',
P_REASON => 'ONP FINALLY CLOSE Request : ' || to_char(v_request_id),
P_CALLING_MODE => 'PO',
P_CONC_FLAG => 'N',
P_RETURN_CODE => v_return_code,
P_AUTO_CLOSE => 'N',
P_ACTION_DATE => sysdate,
P_ORIGIN_DOC_ID => NULL );
I am going to update the tables directly for HOLD/Freeze and Unfreeze action.
As I believe, there is no public API using which you can able to freeze/hold a PO. If you still require the API, then you need to raise a SR so as to get the APIs.
I have a question recently one of our user has mistakenly taken the returns and then cancelled the PO which is in "APPROVED, CLOSED, RESERVED" and is Paid.
Now is there any API/script which i can retrive the cancelled PO?
Note: We are using the 184.108.40.206 version and encumbrance is enabled only for PO.
Please let me know.
Is this the case happened for single purchase order, or multiple PO's. As per standard oracle functionality you cant UNCANCEL the PO's.
If this is really required as per business, then you can raise SR with oracle.
This is happend only for one PO. Yea i know that from PO point of view we cannot retrive the cancelled PO but i just want to know is there any script/API which can help to retive the PO.