\n\t\u4e00\u3001\u901a\u8fc7\u529f\u80fd\u7ba1\u7406\u5458\u6e05\u9664\u9ad8\u901f\u7f13\u5b58\uff0c\u540c\u65f6\u901a\u8fc7\u7cfb\u7edf\u7ba1\u7406\u5458\u63d0\u4ea4“\u6709\u6548\u7528\u6237\u548c\u804c\u8d23”\uff0c\u89c2\u5bdf\u7ed3\u679c\uff1b\n<\/p>\n
\n\t\u4e8c\u3001\u901a\u8fc7\u8bf7\u6c42\u540c\u6b65\u5c40\u90e8\u5de5\u4f5c\u6d41\uff0c\u89c2\u5bdf\u7ed3\u679c\uff1b\n<\/p>\n
\n\t\u4e09\u3001\u5982\u679c\u524d\u9762\u4e24\u6b65\u672a\u751f\u6548\uff0c\u53ef\u8003\u8651\u5e94\u7528\u4ee5\u4e0b\u89e3\u51b3\u65b9\u6848\n<\/p>\n
\n\t1. Go into the responsibility: System Administrator.\n<\/p>\n
\n\t2. Navigate to Request > Run.\n<\/p>\n
\n\t3. Submit request 'Synchronize WF LOCAL tables'\n<\/p>\n
\n\t4. Submit request 'Workflow Directory Services User\/Role Validation'\n<\/p>\n
\n\t5. Check result in table wf_local_user_roles via:\n<\/p>\n
\n\tselect role_name, effective_end_date from wf_local_user_roles
\n\twhere user_name='<>';\n<\/p>\n
\n\t6. If still find some records haven't been changed to null, perform:
\n\ta.) backup the records:
\n\tcreate table wf_local_user_roles_bak as
\n\tselect * from wf_local_user_roles
\n\twhere user_name='<>' and effective_end_date <> to_date('<>','RRRR-MM-DD');
\n\tb.) update effective_end_date to null
\n\tupdate wf_local_user_roles
\n\tset effective_end_date=to_date('9999-01-01','RRRR-MM-DD')
\n\twhere user_name='<>' and effective_end_date <> to_date('<>','RRRR-MM-DD');\n<\/p>\n
\n\t7. Retest the issue.\n<\/p>\n
\n\t8. Migrate the solution as appropriate to other environments.<\/p>\n","protected":false},"excerpt":{"rendered":"
\u4e00\u3001\u901a\u8fc7\u529f\u80fd\u7ba1\u7406\u5458\u6e05\u9664\u9ad8\u901f\u7f13\u5b58\uff0c\u540c\u65f6\u901a\u8fc7\u7cfb\u7edf\u7ba1\u7406\u5458\u63d0\u4ea4“\u6709\u6548\u7528\u6237\u548c\u804c\u8d23”\uff0c\u89c2\u5bdf\u7ed3\u679c\uff1b … \u7ee7\u7eed\u9605\u8bfbOracle EBS\u804c\u8d23\u5206\u914d\u4e0d\u751f\u6548\u95ee\u9898\u5904\u7406\uff08\u53d8\u66f4\u8fc7\u5931\u6548\u65e5\u671f\uff09<\/span>