Intermittent Error: ORA-20002: [WF_INVAL_USER_ROLE] Assigning User Roles After 11i Patches

(Doc ID 2204345.1)

Last updated on NOVEMBER 16, 2016

Applies to:

Oracle User Management - Version 11.5.10.2 to 11.5.10.4 [Release 11.5]
Information in this document applies to any platform.

Symptoms

Since the application of a number of patches to the production system there have been considerable numbers of errors seen in user provisioning. During role assignment we receive errors not seen until the patches were applied.  The error is:

Oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-20002: 3825: Error '-20002 - ORA-20002: [WF_INVAL_USER_ROLE]
ORA-20002: [WF_INVAL_USER_ROLE]' encountered during execution of Rule function 'WF_ROLE_HIERARCHY.Cascade_RF' for event 'oracle.apps.fnd.wf.ds.userRole.created' with key 'FND_USR:74051|UMX:0|2457708:55243'.
ORA-06512: at "APPS.WF_DIRECTORY", line 2629
ORA-06512: at "APPS.WF_LOCAL_SYNCH", line 2080
ORA-06512: at "APPS.UMX_REGISTRATION_PVT", line 1189
ORA-06512: at "APPS.UMX_REGISTRATION_PVT_W", line 124
ORA-06512: at line 1


The patches applied were: (in order)
4444880 - CAC.C Rup1
4595475 - XML Publisher
3500000 - HR_PF.K
4338667 - SLM
66997770 - HR_PF.K.DELTA.3
4051315 - OKL
3981693 - OKL.G
4298372 - OKL.G.RUP2
17851150 - OAF Consolidated update
19258563 - Applications 11i RUP7 CPU OCT2014
16264433 - TXK

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms