This content has been marked as final. Show 4 replies
There is a link available in that same MOS Doc - if you click on it, you will get the script
user10920567 wrote:It is in the same doc, under "For Release 11.5.10" --> "Run poxpocrf_detect_115.sql" so click on poxpocrf_detect_115.sql
Metalink article 465068.1 recommends running poxpocrf_detect_115.sql to verify if a purchasing document (purchase order or release) or line has not been closed when they fall within guidelines to automatic close.
Anyone knows where to find this query?
Edited by: user10920567 on Feb 25, 2013 11:15 AM
Thanks Srini. The script name was the link and got it. However, it was not what I was hoping. The script simply lists POs that are fully received and ready to be closed. I was hoping the script will analyze the PO and determine if anything is wrong with it.
Thanks for your response!
The script simply lists POs that are fully received and ready to be closed. I was hoping the script will analyze the PO and determine if anything is wrong with it.You can log a SR and ask Oracle support for such a script.
Or, you can run a diagnostics script -- E-Business Suite Diagnostics 11i Test Catalog [ID 179661.1] (search for "Oracle Purchasing").