Document Manager Error Number 3 and Unknown Error When Approving Purchase Orders or Requisitions (Doc ID 1310935.1)

Last updated on AUGUST 21, 2016

Applies to:

Oracle Purchasing - Version 11.5.10 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.

Symptoms

Listing of Document Manager Error Number 3 Issues and Troubleshooting Tips > 1310935.1

Requisitions or purchase orders fail during approval with document manager error number 3, causing documents to get stuck in an in process or pre-approved status. These are examples of some of the errors in the workflow:

Failed activity: Approve The PO (APPROVE_PO)
Error Stack: Wf_Engine_Util.Function_Call(PO_REQAPPROVAL_ACTION.APPROVE_DOC,
POAPPRV, 133890-113857, 196532, RUN)
Error Message: User-Defined Exception

Failed activity: Approve The Requisition (APPROVE_REQUISITION)
Error Stack: Wf_Engine_Util.Function_Call(PO_REQAPPROVAL_ACTION.APPROVE_DOC,
REQAPPRV, 133890-113857, 196532, RUN)
Error Message: User-Defined Exception

Failed activity: Does Approver Have Authority? (VERIFY_APPROVER_AUTHORITY)
Error Stack: Wf_Engine_Util.Function_Call(PO_REQAPPROVAL_ACTION.VERIFY_AUTHORITY,
POAPPRV, 133890-113857, 196532, RUN)
Error Message: User-Defined Exception

Failed activity: Forward PO With Status "In-Process" (FORWARD_DOC_INPROCESS)
Error Stack: Wf_Engine_Util.Function_Call(PO_REQAPPROVAL_ACTION.FORWARD_DOC_INPROCESS,
REQAPPRV, 133890-113857, 196532, RUN)
Error Message: User-Defined Exception

Failed activity: Open document state (OPEN_DOCUMENT_STATE)
Error Stack: Wf_Engine_Util.Function_Call(PO_REQAPPROVAL_ACTION.OPEN_DOC_STATE, POAPPRV, 61-800,204955, RUN)
Error Message: User-Defined Exception

Failed activity: Build Default Approval List (BUILD_DEFAULT_APPROVAL_LIST)
Error Stack:Wf_Engine_Util.Function_Call
(PO_APPROVAL_LIST_WF1S.BUILD_DEFAULT_APPROVAL_LIST,
REQAPPRV, 24164-182234, 166001, RUN)
Error Message: User-Defined Exception

The sysadmin error workflow attribute does not display additional error messages. Run this query to confirm that the value is null:

select wiav.name attr_name,
substr(nvl(wiav.text_value, nvl(to_char(wiav.number_value),to_char(wiav.date_value,'DD-MON-YYYY hh24:mi:ss'))),1,30) value
from wf_item_attribute_values wiav,
wf_item_attributes wia
where wiav.item_type = '&1'
and wiav.item_key = '&2'
and wia.item_type = wiav.item_type
and wia.name = wiav.name
and wiav.name = 'SYSADMIN_ERROR_MSG'
and wia.type <> 'EVENT';

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms