REQAPPRV: po.plsql.PO_DOCUMENT_ACTION_UTIL.update_doc_auth_status:10 ORA-06512: at "APPS.ALR_PO_REQUISITI_201_69780_UAR"

(Doc ID 985937.1)

Last updated on AUGUST 21, 2016

Applies to:

Oracle Purchasing - Version 12.0.6 to 12.0.6 [Release 12]
Information in this document applies to any platform.
***Checked for relevance on 11-Nov-2013***

Symptoms

When attempting to approve purchase requisitions a document manager error 3 occurs. The following error is generated:

User-Defined Exception
Wf_Engine_Util.Function_Call(PO_REQAPPROVAL_ACTION.APPROVE_DOC, REQAPPRV, 1918-2689, 214749, RUN)


Further the following Sysadmin Error Message is generated:

po.plsql.PO_DOCUMENT_ACTION_UTIL.update_doc_auth_status:10:-20160ORA-20160: Encountered an error while getting the ORACLE user account for your concurrent request.
Contact your system administrator.
ORA-06512: at "APPS.ALR_PO_REQUISITI_201_69780_UAR", line 1 ORA-04088: error during execution of trigger 'APPS.ALR_PO_REQUISITI_201_69780_UAR' - po.plsql.PO_DOCUMENT_ACTION_UTIL.change_doc_auth_state:120:update_doc_auth_status not successful - po.plsql.PO_DOCUMENT_ACTION_AUTH.approve:20:change_doc_auth_state not successful - po.plsql.PO_DOCUMENT_ACTION_PVT.do_action:110:unexpected error in action call



The issue can be reproduced at will with the following steps:
1. Navigate to Requisitions > Requisitions
2. Create a requisition and submit it for approval
3. At this moment the document manager error 3 occurs

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