當Oracle Workflow 出現問題重起時的後續處理
若有簽核中的單據需要進行下列作業,目前訂單/請購單/採購單都有使用到Oracle Workflow。
Responsibility: CLT Application Manager
路徑: Workflow /Administrator Workflow/ Status Monitor
l PO單In process
輸入參數,找到有錯誤的單據,按下「Error」進入Monitor Error,按下「Retry」
按下「Submit」
l PR單In Process
輸入參數,找到有錯誤的單據,按下「Error」進入Monitor Error,按下「Retry」,「Submit」
下圖為查看圖示
OM
當狀態卡在Error/Differ時,若可採用上述方式則採用上述方式。
Type Internal Name=OEOL
============================================================================
修改Workflow System Administrator:
To change the Workflow System Administrator to the role intended to have administrator privileges, perform the following steps: Workflow Administrator Web Applications, Administration > Workflow Configuration. Select the user or responsibility intended in the Workflow System Administrator field and save. For more details, see Document 453137.1: Oracle Workflow Best Practices。當下面畫面為灰色時,極可能為bug.參考文件: ID 308160.1
可將下面的Workflow System Administrator指定給某個Responsibility,如此就有多人可執行該權限。
若為Bug,先查詢欄位值.
select *
from applsys.wf_resources
where name = 'WF_ADMIN_ROLE';
將TEXT改為'FND_RESP|SYSADMIN|SYSTEM_ADMINISTRATOR|STANDARD'
update wf_resources
set text = 'FND_RESP|SYSADMIN|SYSTEM_ADMINISTRATOR|STANDARD'
where name = 'WF_ADMIN_ROLE';
commit;