Approval Fails at VERIFY_APPROVER_AUTHORITY Activity With SYSADMIN_ERROR_MSG "ORA-28113: policy predicate has error"
(Doc ID 2808677.1)
Last updated on MAY 28, 2024
Applies to:
Oracle Purchasing - Version 12.2.10 and laterInformation in this document applies to any platform.
Symptoms
On : 12.2.10 version, Approvals - Req, PO
PO Approval fails and document is stuck "In Process" status with the following error:
ERROR
-----------------------
Activity (Display Name) VERIFY_APPROVER_AUTHORITY (Does Approver Have Authority?)
RESULT #EXCEPTION
ERROR_NAME 1
ERROR_MESSAGE User-Defined Exception
ERROR_STACK Wf_Engine_Util.Function_Call(PO_REQAPPROVAL_ACTION.VERIFY_AUTHORITY, POAPPRV, 3700392-139176, 178042, RUN)
-----------------------
Activity (Display Name) VERIFY_APPROVER_AUTHORITY (Does Approver Have Authority?)
RESULT #EXCEPTION
ERROR_NAME 1
ERROR_MESSAGE User-Defined Exception
ERROR_STACK Wf_Engine_Util.Function_Call(PO_REQAPPROVAL_ACTION.VERIFY_AUTHORITY, POAPPRV, 3700392-139176, 178042, RUN)
Workflow SYSADMIN_ERROR_MSG attribute:
po.plsql.PO_DOCUMENT_ACTION_CHECK.populate_session_gt:20:-28113ORA-28113: policy predicate has error - po.plsql.PO_DOCUMENT_ACTION_CHECK.authority_check:50:populate_session_gt not successful - po.plsql.PO_DOCUMENT_ACTION_PVT.do_action:110:unexpected error in action call
Steps to Reproduce:
1. Submit PO for approval
2. Approval fails with the error above
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 |