oracle不能分配应付职责,Oracle EBS职责分配不生效问题处理（变更过失效日期）...

一、通过功能管理员清除高速缓存，同时通过系统管理员提交“有效用户和职责”，观察结果；

二、通过请求同步局部工作流，观察结果；

三、如果前面两步未生效，可考虑应用以下解决方案

1. Go into the responsibility: System Administrator.

2. Navigate to Request > Run.

3. Submit request 'Synchronize WF LOCAL tables'

4. Submit request 'Workflow Directory Services User/Role Validation'

5. Check result in table wf_local_user_roles via:

select role_name, effective_end_date from wf_local_user_roles

where user_name='<>';

6. If still find some records haven't been changed to null, perform:

a.) backup the records:

create table wf_local_user_roles_bak as

select * from wf_local_user_roles

where user_name='<>' and effective_end_date <> to_date('<>','RRRR-MM-DD');

b.) update effective_end_date to null

update wf_local_user_roles

set effective_end_date=to_date('9999-01-01','RRRR-MM-DD')

where user_name='<>' and effective_end_date <> to_date('<>','RRRR-MM-DD');

7. Retest the issue.

8. Migrate the solution as appropriate to other environments.