My Oracle Support Banner

PO Approval Workflow Fails With Error ORA-20002: 396: Invalid role name 'WF_EXTERNAL_ROLE_NOEBS_ACCESS' and Email To Supplier's is not Sent (Doc ID 2861193.1)

Last updated on AUGUST 09, 2023

Applies to:

Oracle Purchasing - Version 12.2.9 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.9 version, Approvals - Req, PO

After PO is approved successfully, approval workflow fails with the errors below attempting to deliver the email to the supplier:

WFStat: Activity Statuses exception:
Begin Date  Process / Activity                                                     Process Name            Activity Name                           STATUS  RESULT
2/28/2022 MAIN_POAPPRV_PROCESS/EMAIL_DOC_PROCESS  PO Approval Process   Email PO                                   ACTIVE
2/28/2022 EMAIL_DOC_PROCESS/DOES_USER_WANT_DOC_EMAILED Email PO Does User want document e-mailed  ERROR #EXCEPTION

WFStat: Errored Activities
Activity DOES_USER_WANT_DOC_EMAILED (Does User want document e-mailed)
RESULT #EXCEPTION
ERROR_NAME -6512
ERROR_MESSAGE ORA-06512: at line
ERROR_STACK Wf_Engine_Util.Function_Call(PO_REQAPPROVAL_INIT1.EMAIL_DOC_YES_NO, POAPPRV, 1373267-42009, 339423, RUN)

Trace file shows the error as follows:

Bind#3
oacdty=01 mxl=32(19) mxlc=00 mal=00 scl=00 pre=00
oacflg=13 fl2=206001 frm=01 csi=873 siz=32 off=0
kxsbbbfp=7f305ba3ee38 bln=32 avl=19 flg=09
value="ORA-06512: at line "
Bind#4
oacdty=01 mxl=128(105) mxlc=00 mal=00 scl=00 pre=00
oacflg=13 fl2=206001 frm=01 csi=873 siz=128 off=0
kxsbbbfp=7f305ba3f638 bln=128 avl=105 flg=09
value="
Wf_Engine_Util.Function_Call(PO_REQAPPROVAL_INIT1.EMAIL_DOC_YES_NO, POAPPRV, 1371268-40016, 339423, RUN)"
...
Bind#1
oacdty=01 mxl=32(30) mxlc=00 mal=00 scl=00 pre=00
oacflg=13 fl2=206001 frm=01 csi=873 siz=32 off=0
kxsbbbfp=7f305b980660 bln=32 avl=15 flg=09
value="PLSQL_ERROR_MSG"
Bind#2
oacdty=01 mxl=2000(65) mxlc=00 mal=00 scl=00 pre=00
oacflg=13 fl2=206001 frm=01 csi=873 siz=2000 off=0
kxsbbbfp=7f305b9806e0 bln=2000 avl=65 flg=09
value="ORA-20002: 396: Invalid role name 'WF_EXTERNAL_ROLE_NOEBS_ACCESS'"


Steps to reproduce:
-----------------------
1.  Go to Purchasing Responsibility
2.  Create and Submit PO for Approval
3.  Although PO is approved, workflow shows the errors 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.