Oracle eBS經驗分享

這個User的Menu 上少了兩個 Cost Management的權限

但我們確定有assign也沒有失效

Execute Request by sequence..

1. Sync responsibility role data into the WF table.
2. Synchronize WF LOCAL tables
3. Workflow Directory Services User/Role Validation

如果還是不行….

＝＝＝＝Datafix＝＝＝＝＝

首先確認以下兩個table的end date是否一致

/* Formatted on 2010/03/31 16:48 (Formatter Plus v4.8.8) */
SELECT user_name ,user_end_date
     , role_end_date
     , assigning_role_end_date
     , effective_end_date
  FROM wf_user_role_assignments
WHERE user_name IN ('TINALEE', 'AMYLEE') and role_name like '%COST_M%';

SELECT user_name,user_end_date,role_end_date,effective_end_Date
  FROM wf_local_user_Roles
WHERE user_name IN ('TINALEE', 'AMYLEE') and role_name  like '%COST_M%';

這個case我們發現不一致

所以我的Datafix SQL是..

update wf_local_user_Roles
set effective_end_Date =to_date('99990101','yyyymmdd')
where user_name='AMYLEE'
and role_name like '%COST_M%';

就可以了…