Unable to view new responsibilities added to an User.

Issue: unable to view new responsibilities as added to existing users or re-activate end dated responsibilities. 

Recent Changes: Applied a new Patch using adpatch.

Solution:

1. 429852.1 - Reactivated User Does Not See Responsibilities - This step is where we applied patch 6008417.

2. Workaround

2.1. Stop and restart the "Workflow Java Deferred Agent Listener" in OAM

2.2. This will clear the events in Ready status. To verify this, run:

select

decode(state,

0, '0 (Ready)',

1, '1 (Delayed)',

2, '2 (Retained)',

3, '3 (Exception)',

to_char(state|| ' (Other)')) state,

count(*) how_many

from wf_java_deferred

group by state

The number of 'Ready' needs to get to 0 before you continue.

2.3. Login to E-Business as SYSADMIN and navigate to Workflow Administrator Web Application, Business Event

Search for oracle.apps.fnd.wf.ds.userRole.updated.

Then click on clock symbol under the Subscription column.

Disable the AP_WEB_PROXY_ASSIGN_PKG.proxy_assignments subscription

2.4. Stop and restart the Workflow Agent Listener Service

3. Follow the steps on note 464445.1 - specifically the step to Run the Directory Services Validate User/Role concurrent request.