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 JANUARY 31, 2023
Applies to:
Oracle Purchasing - Version 12.2.8 and laterInformation in this document applies to any platform.
Symptoms
Purchase Requisition approval erroring out in workflow with the following error :
ERROR
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
Workflow attribute SYSADMIN_ERROR_MSG shows:
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
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 |
Cause |
Solution |
References |