Home / APPS DBA / System Administrator Responsibility Missing In Sysadmin

System Administrator Responsibility Missing In Sysadmin


System Administrator Responsibility Missing In Sysadmin


STEP 1.  Execute following 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;
........Subsribe OracleSolutions.pk........
OracleSolutions.pk is exclusively meant to guide the newbies to Learn and Share.

About oracle.solutions

Check Also

JSP error Request URI:/OA_HTML/RF.jsp java.lang.NoClassDefFoundError

ERROR JSP Error: Request URI:/OA_HTML/RF.jsp Exception: java.lang.NoClassDefFoundError JSP Error: Request URI:/OA_HTML/AppsLocalLogin.jsp Exception: java.lang.NoClassDefFoundError More from …

Leave a Reply