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
Recent Posts