Document Manager Failed With Error Number 3 and "po.plsql.PO_DOCUMENT_ACTION_CLOSE.auto_update_close_status:30 ORA-1403" Causing Blanket Releases to Get Stuck in Pre-Approved or In Process

(Doc ID 867855.1)

Last updated on AUGUST 21, 2016

Applies to:

Oracle Purchasing - Version 12.0.6 and later
Information in this document applies to any platform.
POXDACLB.pls


Symptoms

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

Blanket releases fail during approval with document manager error number 3 and sysadmin error:

po.plsql.PO_DOCUMENT_ACTION_CLOSE.auto_update_close_status:30:100ORA-01403: no data found -
po.plsql.PO_DOCUMENT_ACTION_CLOSE.auto_close_po:120:unexpected error in updating closed status -
po.plsql.PO_DOCUMENT_ACTION_PVT.do_action:110:unexpected error in action call

Error in workflow:
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

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