My Oracle Support Banner

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

Last updated on SEPTEMBER 21, 2023

Applies to:

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


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
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 event.

However the GUID returned by the following select is different:

select guid from wf_events where


3) The "" 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 :

from wf_events e ,wf_event_subscriptions s
where e.guid = s.event_filter_guid
and like '%wf.ds.userRole.updated';

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


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


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.