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 NOVEMBER 23, 2020

Applies to:

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


Symptoms

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


po.plsql.PO_DOCUMENT_ACTION_CLOSE.auto_update_close_status:30:100 ORA-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

e.g. 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

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
 
  
References

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