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

4 comments:

  1. Regards
    Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
    LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at training@oracleappstechnical.com | +91 - 9581017828.

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




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

    ReplyDelete