Existing Responsibility Does Not Appear after Modifying the Effective Date (Doc ID 458869.1)

Last updated on OCTOBER 04, 2016

Applies to:

Oracle Workflow Cartridge - Version 11.5.10.0 to 12.1.3 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.
Checked for relevance on 11-MAY-2013

Symptoms

After changing an effective start date for a responsibility from a future date to the current date for a
user, the responsibility does not appear on the users list of responsibilities.   A similar problem may occur when changing the effective end date.

The problem persists after restarting Apache.

The SQL output below also shows the data has not been updated in the WF_LOCAL_USER_ROLES table:

REM
REM        START OF SQL
REM
set echo on
set timing on
set feedback on
set pagesize 132
set linesize 80
--
select USER_NAME, ROLE_NAME, USER_ORIG_SYSTEM, START_DATE, EXPIRATION_DATE,
  USER_START_DATE, USER_END_DATE, ROLE_START_DATE, ROLE_END_DATE,
  EFFECTIVE_START_DATE, EFFECTIVE_END_DATE, ASSIGNMENT_TYPE, OWNER_TAG
from WF_LOCAL_USER_ROLES
where upper(USER_NAME) = upper('&Enter_user_name')
and ROLE_ORIG_SYSTEM = 'FND_RESP'
order by USER_NAME, ROLE_NAME
/
REM
REM        END OF SQL
REM

This means that the user cannot use the affected responsibility.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms