Unable To End-Date a Responsibility Assigned To The User (Doc ID 1348270.1)

Last updated on JANUARY 23, 2017

Applies to:

Oracle Workflow Cartridge - Version 11.5.10.2 to 12.1.3 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.

Symptoms

1)
a) End-dating a responsibility assigned to a user in User Define form is not working even after saving. 
b) Removing the end-date from a responsibility assigned to a user in User Define form is not working even after saving.
When the updated responsibility is re-queried, the end-date is blank or the end-date is still in place and hence the change is not effective.

Steps to reproduce:

Navigate -> System Administration -> Security -> User -> Define 
Query a User
End-date a Responsibility by putting an end-date in the 'To' field under the 'Effective Dates' heading
or
Remove the end-date of a Responsibility under the 'To' field under the 'Effective Dates' heading
Save and observe a confirmation on the status bar
Re-query the User and observe that the 'To' date is null again or the end-date is still there.

2) In $FND_TOP/patch/115/xml/US/wfdss.wfx file both the rule functions WF_ROLE_HIERARCHY.Cascade_RF and WF_ROLE_HIERARCHY.Aggregate_User_Roles_RF has the <EVENT_FILTER_GUID> as CAC4A9FF51E1DC53E030B98B887F788E which is corresponding to the GUID entry in $FND_TOP/patch/115/xml/US/wfdse.wfx file for oracle.apps.fnd.wf.ds.userRole.updated event.

However the GUID returned by the following select is different:

select guid from wf_events where
name='oracle.apps.fnd.wf.ds.userRole.updated';

GUID
---------------------------------------------
3F2363CB892C6D37E0440003BA19340B

3) The "oracle.apps.fnd.wf.ds.userRole.updated" event do not have the subscriptions to call packages WF_ROLE_HIERARCHY.Aggregate_User_Roles_RF, WF_ROLE_HIERARCHY.Cascade_RF,
WF_ROLE_HIERARCHY.Denormalize_User_Role_RF. This can be checked using the SQL below :

select e.name,e.status,e.licensed_flag,s.rule_function,s.phase,s.status,s.licensed_flag
from wf_events e ,wf_event_subscriptions s
where e.guid = s.event_filter_guid
and e.name like '%wf.ds.userRole.updated';

The subscriptions are not loaded by the following WFXLoad:
java oracle.apps.fnd.wf.WFXLoad -u apps apps_pwd <host.domain>:<db_port>:<db_sid> thin US wfdss.wfx .

Changes

My have upgraded from:
E-Business Suite 11i to E-Business Suite Release 12
11.5.9 to 11.5.10.2

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms