ERROR

System Administrator Responsibility Missing In Sysadmin

SOLUTION

STEP 1. Execute following select :

SELECT *

FROM Fnd_Responsibility_vl

WHERE Application_Id = 1

AND Responsibility_Name = ‘System Administrator’

AND Start_Date <= Sysdate

AND ( End_Date is NULL OR End_Date > Sysdate );

STEP 2. Execute following select :

SELECT count(*) FROM Fnd_User_Resp_Groups;

STEP 3. Execute following steps below:

a) Create the Backup table :

CREATE TABLE wf_role_hierarchies_copy AS SELECT * FROM wf_role_hierarchies;

b) truncate the existing table:

TRUNCATE TABLE applsys.wf_role_hierarchies;

c) Run affurgol.sql

sqlplus apps/xxxx @$FND_TOP/patch/115/sql/affurgol.sql FORCE

d) Insert the data into the new created table :

INSERT INTO wf_role_hierarchies SELECT * FROM wf_role_hierarchies_copy;

STEP 4. Verify the output of the following SQL statement at this point :

SELECT count(*) FROM Fnd_User_Resp_Groups;