There are no active responsibilities available for this user – Oracle Apps 11i

Problem Statement : Recently I encountered a problem in Oracle Apps 11i (11.5.9). When a user login into the application he/she gets error “There are no active responsibilities available for this user”and user is not able to see any responsibility in the home page.

The problem is same even for sysadmin user. Now the challenge is that, if the system administrator is also not able to see any responsibility then its very difficult to administer other users facing same problem. So here is the solution that I found out as per metalink note ID 316959.1

Solution :

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’);

OWNER                          OBJECT_NAME                    OBJECT_TYPE
—————————— —————————— ——————
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

OWNER                          OBJECT_NAME                    OBJECT_TYPE
—————————— —————————— ——————
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 );

2)

SELECT count(*)
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;

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;

Bounce Apache and try to login as sysadmin. You should be able to see the correct responsibilities.

Hope this helps !!

Advertisements

4 thoughts on “There are no active responsibilities available for this user – Oracle Apps 11i

  1. I just applied the RUP 6 and i faced the same issue i resolved the sysadmin responisiblities issue after reading your doc but i am not able to retreive other users responsibilities. All responsibilites from other users are missing. Please help me.
    thanks

    1. I faced same issue adding new responsibilites to users but responsibilty are missing…

      suggest me i have seen in backend these table its show but in front end its is missing ..

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s