My Oracle Support Banner

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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.