My Oracle Support Banner

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 OCTOBER 05, 2018

Applies to:

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


Listing of Document Manager Error Number 3 Issues and Troubleshooting Tips 

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


To view full details, sign in with your My Oracle Support account.

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

In this Document
 Retrying Documents Stuck in Pre-Approved or In Process Status

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.