Purchase Requisition Approval Errors in "PO_APPROVAL_LIST_WF1S.BUILD_DEFAULT_APPROVAL_LIST" "PO_DOCUMENT_ACTION_CHECK.authority_checks_setup:40" "ORA-01422"
(Doc ID 2756996.1)
Last updated on MARCH 02, 2021
Applies to:Oracle Purchasing - Version 12.2.8 and later
Information in this document applies to any platform.
Purchase requisition not getting forwarded and getting errored out in workflow.
ORA-06512: at line
Activity (Display Name) RESULT ERROR_NAME ERROR_MESSAGE ERROR_STACK
BUILD_DEFAULT_APPROVAL_LIST (Build Default Approval List) #EXCEPTION -6512 ORA-06512: at line Wf_Engine_Util.Function_Call(PO_APPROVAL_LIST_WF1S.BUILD_DEFAULT_APPROVAL_LIST, REQAPPRV, 14576974-577583, 311439, RUN)
Does Employee Have Authority to Approve
RESULT_CODE FAILURE_MESSAGE EXCEPTION_MESSAGE
U:AUTHORIZATION_FAILED po.plsql.PO_DOCUMENT_ACTION_CHECK.authority_checks_setup:40:-1422ORA-01422: exact fetch returns more than requested number of rows - po.plsql.PO_DOCUMENT_ACTION_CHECK.authority_check:20:unexpected error in authority_checks_setup - po.plsql.PO_DOCUMENT_ACTION_PVT.do_action:110:unexpected error in action call
STEPS TO REPLICATE
The issue can be reproduced at will with the following steps:
1. Create Requisition and Submit for approval
2. Workflow errors
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