Unable To End-Date a Responsibility Assigned To The User
(Doc ID 1348270.1)
Last updated on JANUARY 23, 2017
Oracle Workflow Cartridge - Version 184.108.40.206 to 12.1.3 [Release 11.5.10 to 12.1] Information in this document applies to any platform.
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';
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 .
My have upgraded from: E-Business Suite 11i to E-Business Suite Release 12 11.5.9 to 220.127.116.11
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!