System Administrator Responsibility Missing In Sysadmin
November 7, 2017
APPS DBA, Errors/Workarounds-Applications
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