problem:
After changing apps password
and sysadmin pwd and run autoconfig , when i connnect with sysadmin user i dont
get the menu and respo of sysadmin i get “ There
are no active responsibilities available for this user. “ message
solution 1 :
solution 1 :
- open the application by sysadmin user
- go to personalize bar and click on it and after u will get all the list
of resp go at the right of the top and click show to change status of resp from
hidden to show and click on the apply botton
-after that return to menu and u will find every thing ok .
solution 2 :
Part 1: Verification
Execute following queries for verification as per metalink note ID 335487.1
1) Please check if table FND_USER_RESP_GROUPS was backed up to table FND_USER_RESP_GROUPS_OLD in the APPLSYS schema, and verify that there is a SYNONYM FND_USER_RESP_GROUPS_OLD in the APPS schema.
SELECT OWNER, OBJECT_NAME, OBJECT_TYPE
FROM ALL_OBJECTS
WHERE OBJECT_NAME LIKE ’FND_USER_RESP_GROUPS_OLD’
AND OBJECT_TYPE IN (‘VIEW’,’TABLE’, ‘SYNONYM’);
FROM ALL_OBJECTS
WHERE OBJECT_NAME LIKE ’FND_USER_RESP_GROUPS_OLD’
AND OBJECT_TYPE IN (‘VIEW’,’TABLE’, ‘SYNONYM’);
OWNER OBJECT_NAME OBJECT_TYPE
—————————— —————————— ——————
APPLSYS FND_USER_RESP_GROUPS_OLD TABLE
APPS FND_USER_RESP_GROUPS_OLD SYNONYM
—————————— —————————— ——————
APPLSYS FND_USER_RESP_GROUPS_OLD TABLE
APPS FND_USER_RESP_GROUPS_OLD SYNONYM
2) Check if object FND_USER_RESP_GROUPS is a view or a table
SQL> SELECT OWNER, OBJECT_NAME, OBJECT_TYPE
FROM ALL_OBJECTS WHERE OBJECT_NAME LIKE ‘FND_USER_RESP_GROUPS’; 2
FROM ALL_OBJECTS WHERE OBJECT_NAME LIKE ‘FND_USER_RESP_GROUPS’; 2
OWNER OBJECT_NAME OBJECT_TYPE
—————————— —————————— ——————
APPS FND_USER_RESP_GROUPS VIEW
APPS_MRC FND_USER_RESP_GROUPS SYNONYM
RTREADONLY FND_USER_RESP_GROUPS SYNONYM
—————————— —————————— ——————
APPS FND_USER_RESP_GROUPS VIEW
APPS_MRC FND_USER_RESP_GROUPS SYNONYM
RTREADONLY FND_USER_RESP_GROUPS SYNONYM
FND_USER_RESP_GROUPS should be a view in APPS schema.
If FND_USER_RESP_GROUPS is of type TABLE in the APPLSYS schema please apply solution from step 3 from metalink note ID 335487.1
Else execute following steps from metalink note ID 316959.1
Part 2: Fix
Run following SQLs
1)
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 );
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)
SELECT count(*)
FROM Fnd_User_Resp_Groups;
FROM Fnd_User_Resp_Groups;
3)
Back up the wf_role_hierarchies table into a new table you create.
CREATE TABLE wf_role_hierarchies_copy AS
SELECT * FROM wf_role_hierarchies;
SELECT * FROM wf_role_hierarchies;
Delete the entries in that table (2 rows exist)
TRUNCATE TABLE applsys.wf_role_hierarchies;
Run affurgol.sql FORCE
SQL> @$FND_TOP/patch/115/sql/affurgol.sql FORCE
Then replace those entries back into wf_role_hierarchies table
SQL> INSERT INTO wf_role_hierarchies
SELECT * FROM wf_role_hierarchies_copy;
SELECT * FROM wf_role_hierarchies_copy;
Bounce Apache and try to login as sysadmin. You should be able to see the correct responsibilities.
Hope this helps !!
No comments:
Post a Comment