Oracle EBS 11i 职责不见了的解决方法

现象：登陆系统后不显示相关职责，进入Form后也无法通过切换职责也看不见丢失的职责.

解决方法：

方案一:

1.

SELECT URA.USER_NAME
      ,URA.ROLE_NAME
  FROM WF_LOCAL_USER_ROLES      UR
      ,WF_USER_ROLE_ASSIGNMENTS URA
 WHERE UR.USER_NAME = URA.USER_NAME
   AND UR.ROLE_NAME = URA.ROLE_NAME
   AND URA.RELATIONSHIP_ID = -1
   AND ((UR.EFFECTIVE_START_DATE IS NULL OR
       UR.EFFECTIVE_START_DATE <> URA.EFFECTIVE_START_DATE) OR
       (UR.EFFECTIVE_END_DATE IS NULL OR
       UR.EFFECTIVE_END_DATE <> URA.EFFECTIVE_END_DATE));

2.

UPDATE WF_USER_ROLE_ASSIGNMENTS T
   SET EFFECTIVE_END_DATE = TO_DATE(NULL)
 WHERE ROWID IN (SELECT URA.ROWID
                   FROM WF_LOCAL_USER_ROLES      UR
                       ,WF_USER_ROLE_ASSIGNMENTS URA
                  WHERE UR.USER_NAME = URA.USER_NAME
                    AND UR.ROLE_NAME = URA.ROLE_NAME
                    AND URA.RELATIONSHIP_ID = -1)
   AND T.USER_NAME = 'LIULIHUA'

 

3).提交请求:
System Administrator responsibility 》request 》

"Sync responsibility role data into the WF table"&
"Synchronize WF LOCAL tables"&

"Workflow Directory Services User/Role Validation concurrent program"

第一，二步更新table数据，要特别注意，并不是责职丢失都要更新，大都多通过只做第三步就能解决丢失职责的问题(如:系统已经升级到ATG.RUP6后版本)

 

方案二:

   打patch:5121512