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

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
Symptoms
Changes
Cause
Solution
References


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.