What is the application release?
We have a requirement to mass close all the old POs. I am using po_actions.close_po api for the purpose and calling it through a concurrent program. However this doesn't seem to be working. Any pointers will be really appreciated.Do you get any error?
What if you run the code (API) manually? Does it work?
According to my finding a year ago this is a known issue and ER is present from Oracle.
The release is 11.5.10. I haven't tried calling it directly. The returned_code is always coming as false in my case. I am passing p_auto_close as 'N'.
I raised an SR with Oracle and they said they can add my request to the present SR but this won't solve my issue as I need this asap. I searched the various forums and looks like this is the same api they are using in R12. Hence I was wondering if anyone can point me to what is it that I am doing wrong.
I tried running the procedure directly and it still doesn't work.
Did you try to close the shipment (line_location_id)? If I remember well you had to close the shipment and it is rolling up to the line and header if applicable.
I tried with action as CLOSED instead of CLOSED and it worked. Thanks for all your comments.
Am actually facing the same issue as you faced earlier with po_actions.close_po API. However i also tried with the p_action with different values as 'CLOSE', 'CLOSED', 'FINALLY CLOSE', 'FINALLY CLOSED' with no luck. All the time, the return status is NULL and the PO is not getting closed. Mine is 22.214.171.124 version.
Can someone please be able to help?
Thanks much & Regards,