R12: "ORA-04063: rule set "APPLSYS.WF_DEFERRED_R" has errors" Error When Attempting to Apply Patch 6435000

(Doc ID 553673.1)

Last updated on SEPTEMBER 09, 2016

Applies to:

Oracle Applications DBA - Version 12.0.0 to 12.0.6 [Release 12]
Oracle Applications Manager - Version 12.2.4 to 12.2.4 [Release 12.2]
Information in this document applies to any platform.
***Checked for relevance on 29-Dec-2012***

Symptoms

On Release 12.0, when attempting to apply <patch 6435000>, the following error occurs:

sqlplus -s APPS/***** @/dbshare/ebiz12/apps/apps_st/appl/fnd/12.0.0/patch/115/sql/affurgol.sql NOFORCE

PL/SQL procedure successfully completed.


PL/SQL procedure successfully completed.


PL/SQL procedure successfully completed.


PL/SQL procedure successfully completed.

begin /* CREATE FND_RESP WF ROLES */
*
ERROR at line 1:
ORA-04063: rule set "APPLSYS.WF_DEFERRED_R" has errors
ORA-20002: 395: Duplicate role Application Developer
('FND_RESP|FND|APPLICATION_DEVELOPER|STANDARD')
ORA-06512: at "APPS.WF_LOCAL_SYNCH", line 1700
ORA-06512: at "APPS.FND_USER_RESP_GROUPS_API", line 1238
ORA-06512: at "APPS.FND_USER_RESP_GROUPS_API", line 1668
ORA-06512: at "APPS.FND_USER_RESP_GROUPS_API", line 1413
ORA-06512: at line 2

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