Monday 29 September 2014

PO Workflow Error - Document Manager Failed with Error Number 3 while processing Standard Purchase Order XXXXXX

Reset a Purchase Order Statuses From In Process or Pre-Approved To Incomplete/Requires Reapproval

Title:
Document Manager Failed with Error Number 3 while processing  Standard Purchase Order XXXXXX

Issue Description:
PO Workflow got stuck in Error with the error message "Document Manager Failed with Error Number 3 while processing Standard Purchase Order XXXXXX".
Not able to process the Purchase Order using "Retry" or "Skip" options in Workflow. Also, system is not allowing to Cancel or Reject this PO.

Steps to Reproduce:
Navigation: Buyers Work Centre > Orders
  • ·         Create the new Standard Purchase Order
  • ·         Create the PO without entering the Supplier Name and Site details
  • ·         Submit the PO for Approval
  • ·         Check the Workflow for this PO using the Purchase Order Summary form
  • ·         Navigation: Purchase Orders > Purchase Order Summary
  • ·         Query the PO by entering the PO number
  • ·         Check the PO Workflow by navigating to Tools > View Approval through Workflow
  • ·         Workflow will be in error with the below error message


Error Message:
Document Manager Failed with Error Number 3 while processing  Standard Purchase Order XXXXXX

Cause:
When we create the purchase orders using the Buyers Work Centre form, we may miss to enter some data's like Supplier Name, Site or both the details. If we submit the purchase orders without entering these kind of details (Supplier Name/Site/Email ID) for approval then the workflow will get stuck in error with the error message " Document Manager Failed with Error Number 3 while processing  Standard Purchase Order XXXXXX" and the PO will go to "In Process" status.
We can not process these kind of Purchase Orders using "Retry" or "Skip" options in Workflow. Also, we can not Cancel or Reject this workflow. System will not allow us to open this "In Process" status purchase orders.
In this case, we need to enter the missing data's in the purchase orders. But, we can not open the "In Process" purchase orders. To open these kind of POs, we need to re-set the purchase order statuses from "In Process" to "Incomplete" status. Once, we re-set the PO status back to "Incomplete" then we can open the PO and enter the missing data's.

Solution:
Go to Oracle Metalink Note ID: 390023.1 - Reset the PO using the re-set script.
Open the PATCH 9707155 and download the script "poxrespo.sql" (poxrespo.sql - to reset Standard, Blanket, Planned and Contract purchase orders)

Execute the script in the TEST environment first with below parameters.
  • ·         Please enter the PO number to reset : <PO Number>
  • ·         Please enter the organization id to which the PO belongs (Default NULL) : <ORGANIZATION_ID>
  • ·         Do you want to delete the action history since the last approval ? (Y/N): <Y/N>

Commit;

After the DATAFIX, open the PO and enter the missing data's and then re-submit it for approval.

Note:
You can download the DATAFIX script based on the Document Types & Oracle Versions.

  • poxrespo.sql - to reset Standard, Blanket, Planned and Contract purchase orders 
  • poresrel.sql - to reset Blanket and scheduled releases
  • poresreq.sql - to reset Internal and purchase requisitions

7 comments:

  1. Thanks for sharing such a great article about Punchout CXML, it will help me in my work.
    Punchout CXML Catlog




    ReplyDelete
  2. It's interesting to read blog about punchout cxml.
    Punchout CXML

    ReplyDelete
  3. This can be one particular of the most useful blogs We’ve ever arrive across on this subject. Basically Wonderful. I am also a specialist in this topic so I can understand your hard work.
    Document Management Software
    Document Management System
    Electronic Document Management Software
    Best Document Management Software

    ReplyDelete
  4. That is very interesting; you are a very skilled blogger. I have shared your website in my social networks! A very nice guide. I will definitely follow these tips. Thank you for sharing such detailed article.
    CONTRACTS

    ReplyDelete
  5. Hi,
    I am facing a same error message in wf_notifications while trying to Approve the Standard PO using po_reqapproval_init1.start_wf_process API.
    Current status of PO is IN PROCESS

    (Supplier Name/Site/Email ID) --> These fields are available in my case.

    Could you please help me on it.

    Thank you.

    ReplyDelete