Troubleshooting Issues With Users Not Being Able To Access Responsibilities (Doc ID 1064438.1)

APPLIES TO:

Oracle Application Object Library - Version 11.5.10.2 to 12.2 [Release 11.5 to 12.2]
Information in this document applies to any platform.

PURPOSE

This document provides several trouble shooting steps that can be checked when you either assign a new responsibility to a user or remove the end date for a responsibility for a user.

TROUBLESHOOTING STEPS

1. If the user uses the ERP forms and uses the switch responsibility option, or, logs in using the http://<server>:<port>/dev60cgi/f60cgi URL, can they see and select the responsibility?
(For this to be possible s_appserverid_authentication must be set to off in your $APPL_TOP/admin/<SID>_<hostname>.xml context file. If it is not, then you will need to reset it to OFF and re-run autoconfig on your web tier.)

2. If you bounce Apache, do they show up?

3. Make sure the Workflow Deferred Agent Listener and Workflow Java Deferred Agent Listener are running. See Note 548918.1 "How to start the Workflow Deferred Agent Listener and Workflow Java Deferred Agent Listener?"

4. Check the queue WF_DEFERRED. If there are rows returned the the workflow processing has not yet been performed:
Are any of the following events waiting:
oracle.apps.fnd.wf.ds.user.updated
or
oracle.apps.fnd.wf.ds.role.updated
or
oracle.apps.fnd.wf.ds.user.nameChanged

SELECT CORRID, to_char(ENQ_TIME, 'DD-MON-YY HH24:MI:SS'), to_char(DEQ_TIME, 'DD-MON-YY
HH24:MI:SS') FROM WF_DEFERRED
where CORRID like '%oracle.apps.fnd.wf.ds%'
order by deq_time;

5. Verify that Patch 6008417, 'AOL USER RESPONSIBILITY SECURITY FIXES 2b', has been applied.

6. Run the following select:
select subscription_rule_function
from wf_active_subscriptions_v
where event_name in ( 'oracle.apps.fnd.wf.ds.userRole.updated');

If the above script returns a row for AP_WEB_PROXY_ASSIGN_PKG.proxy_assignments then you need to DISABLE 'AP_WEB_PROXY_ASSIGN_PKG.proxy_assignments' assigned to " oracle.apps.fnd.wf.ds.userRole.updated". This subscription is at a lower phase than 'WF_ROLE_HIERARCHY.Aggregate_User_Roles_RF'. This causes 'AP_WEB_PROXY_ASSIGN_PKG.proxy_assignments' to run first after being enqueued on the WF_DEFERRED queue. The subscription is set to Rollback on error and as it is erroring, it rolls back the complete running of the subscriptions assigned to the " oracle.apps.fnd.wf.ds.userRole.updated" event so 'WF_ROLE_HIERARCHY. Aggregate_User_Roles_RF' never get a chance to run at all. To disable the subscription, follow the instructions in the workaround portion of Note 433473.1.

7. Run the following select:
select count(*)
from wf_local_user_roles ur, wf_user_role_assignments ura
where ur.user_name = ura.user_name
and ur.role_name = ura.role_name
and ura.relationship_id = -1
and ((ur.effective_start_date is null or ur.effective_start_date <>
ura.effective_start_date)
or (ur.effective_end_date is null or ur.effective_end_date <> ura.
effective_end_date));

If the above script returns any rows then backup the WF_LOCAL_USER_ROLES and WF_USER_ROLE_ASSIGNMENTS tables and run the following update script:

UPDATE WF_USER_ROLE_ASSIGNMENTS set effective_end_date = to_date(null)
where rowid in (select ura.rowid
from wf_local_user_roles ur, wf_user_role_assignments ura
where ur.user_name = ura.user_name
and ur.role_name = ura.role_name
and ura.relationship_id = -1
and ((ur.effective_start_date is null or ur.effective_start_date <>ura.effective_start_date)
or (ur.effective_end_date is null or ur.effective_end_date <>ura.effective_end_date)));

8. After performing steps 6 and 7 run the 'Workflow Directory Services User/Role Validation' report with the parameters: 10000, yes, yes, yes.