Document Manager Failed with Error Number 3 at Verify Approver Authority with "po.plsql.DOCUMENT_ACTION_CHECK.authority_checks_setup:40:100 ORA-01403" (Doc ID 1073703.1)

Last updated on AUGUST 21, 2016

Applies to:

Oracle Purchasing - Version 12.0 to 12.2 [Release 12 to 12.2]
Information in this document applies to any platform.
***Checked for relevance on 12-Nov-2012***

Symptoms

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

The workflow fails with Document Manager Error number 3 at the Verify Authority activity after one user approves requisitions.

      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

sysadmin error:
      po.plsql.DOCUMENT_ACTION_CHECK.authority_checks_setup:40:100 ORA-01403: no data found
      po.plsql.PO_DOCUMENT_ACTION_CHECK.authority_check:20:unexpected error in authority_checks_setup
      po.plsql.PO_DOCUMENT_ACTION_PVT.do_action:110:unexpected error in action call

OR

sysadmin error:
      po.plsql.DOCUMENT_ACTION_CHECK.authority_checks_setup:40:100ORA-01403: no data found
      po.plsql.PO_DOCUMENT_ACTION_CHECK.authority_check:20:unexpected error in authority_checks_setup
      po.plsql.PO_DOCUMENT_ACTION_PVT.do_action:110:unexpected error in action call

Steps:
1. Enter requisition
2. Submit it for approval
3. Log in as the approver and respond to the notification
4. Workflow fails with document manager error and requisition is stuck with an in-process status

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