不知道為什麼,某些User的Responsibility有重複的現象,只要停用其中一個,另一個也停用。
Oracle ERP版本:11.5.10.2
Responsibility Duplicate問題解法:
1、更新Patch:4719658,也有人說要更新Patch:5121512(我沒有更新這兩個Patch)
2、備份有重複的Responsibility,因為下一個步驟要刪除它
select * from wf_local_user_roles where user_name='XXXXX' and ... ;
3、刪除重複的Responsibility
delete wf_local_user_roles where user_name='XXXXX' and ... ;
4、執行 Concurrent Request,名稱為:WorkFlow Directory Service user/role validation
報表的參數如下:
p_BatchSize = 10000
Fix dangling user/roles = Yes
Add missing user/role assignments = Yes
但是我在正式機上只有執行 WorkFlow Directory Service user/role validation 這個Concurrent Request
等到Concurrent Request完成後,再重新查詢User的權限,重複的Responsibility就不見了。
1、更新Patch:4719658,也有人說要更新Patch:5121512(我沒有更新這兩個Patch)
2、備份有重複的Responsibility,因為下一個步驟要刪除它
select * from wf_local_user_roles where user_name='XXXXX' and ... ;
3、刪除重複的Responsibility
delete wf_local_user_roles where user_name='XXXXX' and ... ;
4、執行 Concurrent Request,名稱為:WorkFlow Directory Service user/role validation
報表的參數如下:
p_BatchSize = 10000
Fix dangling user/roles = Yes
Add missing user/role assignments = Yes
但是我在正式機上只有執行 WorkFlow Directory Service user/role validation 這個Concurrent Request
等到Concurrent Request完成後,再重新查詢User的權限,重複的Responsibility就不見了。