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 );
2.) Execute following select :
SELECT count(*)
FROM Fnd_User_Resp_Groups;
3.) Back up the WF_ROLE_HIERARCHIES table into a new table you create as apps.
Delete the entries in that table (2 rows exist), run affurgol.sql FORCE (in FND_TOP/patch/115/sql) and then replace those entries back into WF_ROLE_HIERARCHIES table.
The steps to execute are :
3.a) Create the Backup table :
CREATE TABLE wf_role_hierarchies_copy AS
SELECT * FROM wf_role_hierarchies;
3.b) truncate the existing table :
TRUNCATE TABLE applsys.wf_role_hierarchies;
3.c) Execute the script that is in Red Color in the top.
3.d) Insert the data into the new created table :
INSERT INTO wf_role_hierarchies
SELECT * FROM wf_role_hierarchies_copy;
4.) Verify the output of the following SQL statement at this point :
SELECT count(*)
FROM Fnd_User_Resp_Groups;
Now You Log in to the Applications, we can find all the responsibilities.
No comments:
Post a Comment