从后台修改职责的失效日期

遇到sysadmin用户的“系统管理员”职责失效，想用而不得法，于是鼓捣了半天，通过从后台表修改，来回复已过期的职责。

SELECT * FROM wf_local_user_roles wlur,fnd_user u
WHERE u.user_name = wlur.user_name
AND u.user_name LIKE 'SYSADMIN'
and wlur.role_orig_system = 'FND_RESP'
AND
substr( wlur.role_name,
INSTR(wlur.role_name,'|',1,2)+1,
(INSTR(wlur.role_name,'|',1,3)-INSTR(wlur.role_name,'|',1,2)-1)
)
=
(SELECT fr.responsibility_key FROM fnd_responsibility fr,fnd_responsibility_tl ftl WHERE
fr.responsibility_id = ftl.responsibility_id
AND ftl.responsibility_name LIKE '系统管理员');

修改EXPIRATION_DATE字段就好。

这是今天的一点收获～

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/24527387/viewspace-1044600/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/24527387/viewspace-1044600/