Syed Saad Ali

Oracle ACE Pro

Oracle Solution Architect

Oracle E-Business Suite

Oracle Cloud Infrastructure

Oracle Fusion Middleware

Oracle Database Administration

Oracle Weblogic Administration

Syed Saad Ali

Oracle ACE Pro

Oracle Solution Architect

Oracle E-Business Suite

Oracle Cloud Infrastructure

Oracle Fusion Middleware

Oracle Database Administration

Oracle Weblogic Administration

Blog Post

System Administrator Responsibility Missing In Sysadmin

System Administrator Responsibility Missing In Sysadmin

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;
Related Posts
Write a comment