New! Purchasing R12: PO Approval Analyzer Diagnostic Script

We are pleased to announce the release of the Purchasing ‘PO Analyzer’ diagnostic that can be used proactively to check a group of purchasing documents or reactively if you have problems on specific ones.  The PO Analyzer script can be run on one specific document that perhaps is stuck in an ‘in process’ or ‘pre-approved’ status where more information is needed, or it can be run for all documents within a specific date range.  It’s non-invasive (no update or delete statements are used) so it can be run it in a Production environment.

The images below show sample output from the script - the contents section and a detail report section:

PO Analyzer Report Output

PO Analyzer Sample Output

For download and steps to run the PO Analyzer see Doc ID 1525670.1.

We are also providing a Webcast on the Analyzer on May 28th.

Sign up now at Doc ID 1456150.1 .


Just tried it out. Looks quite useful.
Would like to point out that the package name 'po_approval_analyzer_pkg' in the Examples section in the Metalink document, does not match the package being created through the script.

Posted by Sujoy on April 30, 2013 at 06:54 AM EDT #

Hi Sujoy, thanks for your comment. I'll add a comment to Doc ID 1525670.1 to request the authors to take a look at that and amend the note accordingly.

Posted by LuciaC on May 01, 2013 at 09:32 PM EDT #

Hi! Just wanted to let you know that the note has been amended and the package name is now correct.

Posted by LuciaC on May 22, 2013 at 09:04 PM EDT #

Dear All,

Please help me on the below.

I have created a PO and received the goods. I rejected partical quantity and created receipts for

remaining quantity. I have closed the PO before making Returns for the rejected quantity.

KIndly help me in resolving the issue. I have opened the PO and removed the cancelled flag, but still i

was unable to create returns due to below error.

"APP-PO-14094: No Records Meet your Search Criteria"

Vivekanandan K

Posted by Vivek on May 27, 2014 at 01:56 AM EDT #

Hi Vivekanandan,
Sorry, but we can't really answer technical questions here in the blog. If you have a My Oracle Support login, then I recommend that you post your questions in the Procurement Community (

Posted by LuciaC - Oracle on May 27, 2014 at 03:30 AM EDT #

Thanks Lucia

Posted by Vivek on May 27, 2014 at 04:21 AM EDT #

how to set up PO approval through emails.

Posted by guest on August 28, 2014 at 04:20 AM EDT #


The PO approval process uses Oracle Workflow to process the notifications. You can configure Workflow to send emails as well as the notifications. Both outbound and inbound processing of the mails is possible. Workflow setup is often done by the DBAs.

We can't really go into technical details here. Your best bet is to post your question to the MOS Procurement community:

Posted by guest on August 31, 2014 at 09:59 PM EDT #

Post a Comment:
  • HTML Syntax: NOT allowed

Welcome to the EBS Support Blog where Oracle insiders share news and information about EBS products including new releases, tips and tricks, troubleshooting guides, upcoming webcasts and links to EBS Communities.

Stay Connected



« April 2015