Document Manager Failed With Error Number 3 and POXDM-210 POACA-870 POACA-790 ORA-01403 Causing Purchase Orders or Requisitions to Get Stuck in Pre-Approved or in Process (Doc ID 782911.1)

Last updated on JULY 14, 2016

Applies to:

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

Symptoms

Listing of Document Manager Error Number 3 Issues and Troubleshooting Tips : Note 782911.1

Requisitions or purchase orders fail during approval with document manager error number 3 and sysadmin error:
     

POXDM-210: Subroutine poxdmaction() returned erro
POACA-870: Subroutine poacasetup() returned error
POACA-790: ORA-01403: no data found


These are examples of errors in the workflow:

Error in workflow for purchase orders/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


Error in workflow for requisitions:
     

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

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