Unable To End-Date a Responsibility Assigned To The User
(Doc ID 1348270.1)
Last updated on OCTOBER 02, 2020
Applies to:Oracle Workflow - Version 220.127.116.11 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 oracle.apps.fnd.wf.ds.userRole.updated event.
However the GUID returned by the following select is different:
select guid from wf_events where
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 :
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 .
My have upgraded from:
E-Business Suite 11i to E-Business Suite Release 12
11.5.9 to 18.104.22.168
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