My Oracle Support Banner

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.

Symptoms

Purchase requisition not getting forwarded and getting errored out in workflow.
 

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
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




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.