Oracle eBS經驗分享

Oracle ERP改成Web Login後造成有些Function無法Launch Form

Oracle的建議請參考(Metalink: 149358.1 )

重點Responsibility Key不要用特殊字,中文字,還有 空白

如果採用Data Fix, 需更新下面3個Table

FND_RESPONSIBILITY
WF_LOCAL_ROLES

WF_LOCAL_USER_ROLES

UPDATE FND_RESPONSIBILITY
     SET RESPONSIBILITY_KEY = 'DHC_WORK_IN_PROCESS'
WHERE RESPONSIBILITY_ID = 51645;

UPDATE WF_LOCAL_ROLES
     SET NAME='FND_RESP|OFA|AYK_FA_ACC_USER|STANDARD'
WHERE NAME='FND_RESP|OFA|AYK_FA列婚_USER|STANDARD';

UPDATE WF_LOCAL_USER_ROLES
     SET ROLE_NAME='FND_RESP|OFA|AYK_FA_ACC_USER|STANDARD'
WHERE USER_NAME='MIKECHEN'
     AND ROLE_ORIG_SYSTEM_ID=51898
     AND ROLE_NAME='FND_RESP|OFA|AYK_FA列婚_USER|STANDARD';