訂單尚未完全出貨,但order header的 workflow被puges後的恢復處理
在訂單單身中為picked 或 shipped
在shipping transaction為interfaced
/*
因為order header的 workflow被puges
在訂單單身中為picked 或 shipped
在shipping transaction為interfaced
補回來的SQL
以下587667字樣為訂單header_id
3140010656字樣為訂單號
在實際應用中要替換為真正的資料
TO_DATE('11/28/2006 14:17:08', 'MM/DD/YYYY HH24:MI:SS')為日期時間,依情況定
'ORG_ID', 3為公司id
*/
begin
Insert into WF_ITEMS
(item_type, item_key, root_activity, root_activity_version, owner_role, begin_date, user_key)
Values
('OEOH', '587667', 'R_STANDARD_HEADER', 32, 'KERLY.WANG', TO_DATE('11/28/2006 14:17:08', 'MM/DD/YYYY HH24:MI:SS'), 'Sales Order 3140010656');
COMMIT;
Insert into WF_ITEM_ATTRIBUTE_VALUES
(item_type, item_key, name, text_value, event_value)
Values
('OEOH', '587667', '#SCHEMA', 'APPS', null);
Insert into WF_ITEM_ATTRIBUTE_VALUES
(item_type, item_key, name, text_value, event_value)
Values
('OEOH', '587667', '.ADMIN_KEY', '85197700', null);
Insert into WF_ITEM_ATTRIBUTE_VALUES
(item_type, item_key, name, text_value, event_value)
Values
('OEOH', '587667', '.MONITOR_KEY', '3582172285', null);
Insert into WF_ITEM_ATTRIBUTE_VALUES
(item_type, item_key, name, number_value, event_value)
Values
('OEOH', '587667', 'APPLICATION_ID', 660, null);
Insert into WF_ITEM_ATTRIBUTE_VALUES
(item_type, item_key, name, event_value)
Values
('OEOH', '587667', 'GOBO_OM_EMAIL_BODY', null);
Insert into WF_ITEM_ATTRIBUTE_VALUES
(item_type, item_key, name, event_value)
Values
('OEOH', '587667', 'GOBO_OM_EMAIL_HEADER', null);
Insert into WF_ITEM_ATTRIBUTE_VALUES
(item_type, item_key, name, event_value)
Values
('OEOH', '587667', 'GOBO_OM_RECIPIENT', null);
Insert into WF_ITEM_ATTRIBUTE_VALUES
(item_type, item_key, name, text_value, event_value)
Values
('OEOH', '587667', 'HDR_SHORT_DESCRIPTOR', 'plsql:OE_ORDER_WF_UTIL.Set_Header_Descriptor/'||chr(38)||'#NID', null);
Insert into WF_ITEM_ATTRIBUTE_VALUES
(item_type, item_key, name, event_value)
Values
('OEOH', '587667', 'MESSAGE_TYPE', null);
Insert into WF_ITEM_ATTRIBUTE_VALUES
(item_type, item_key, name, event_value)
Values
('OEOH', '587667', 'NOTIFICATION_APPROVER', null);
Insert into WF_ITEM_ATTRIBUTE_VALUES
(item_type, item_key, name, text_value, event_value)
Values
('OEOH', '587667', 'NOTIFICATION_FROM_ROLE', 'KERLY.WANG', null);
Insert into WF_ITEM_ATTRIBUTE_VALUES
(item_type, item_key, name, text_value, event_value)
Values
('OEOH', '587667', 'ORDER_CATEGORY', 'MIXED', null);
Insert into WF_ITEM_ATTRIBUTE_VALUES
(item_type, item_key, name, text_value, event_value)
Values
('OEOH', '587667', 'ORDER_DETAILS_URL',
''||chr(38)||'akRegionApplicationId=660'||chr(38)||'HeaderId=587667', null);
Insert into WF_ITEM_ATTRIBUTE_VALUES
(item_type, item_key, name, number_value, event_value)
Values
('OEOH', '587667', 'ORDER_NUMBER', 3140010656, null);
Insert into WF_ITEM_ATTRIBUTE_VALUES
(item_type, item_key, name, number_value, event_value)
Values
('OEOH', '587667', 'ORG_ID', 2, null);
Insert into WF_ITEM_ATTRIBUTE_VALUES
(item_type, item_key, name, event_value)
Values
('OEOH', '587667', 'PURCHASE_ORDER', null);
Insert into WF_ITEM_ATTRIBUTE_VALUES
(item_type, item_key, name, number_value, event_value)
Values
('OEOH', '587667', 'RESPONSIBILITY_ID', 50158, null);
Insert into WF_ITEM_ATTRIBUTE_VALUES
(item_type, item_key, name, event_value)
Values
('OEOH', '587667', 'SITE_USE_CODE', null);
Insert into WF_ITEM_ATTRIBUTE_VALUES
(item_type, item_key, name, event_value)
Values
('OEOH', '587667', 'USAGE_CODE', null);
Insert into WF_ITEM_ATTRIBUTE_VALUES
(item_type, item_key, name, number_value, event_value)
Values
('OEOH', '587667', 'USER_ID', 7707, null);
Insert into WF_ITEM_ATTRIBUTE_VALUES
(item_type, item_key, name, text_value, event_value)
Values
('OEOH', '587667', 'WF_ADMINISTRATOR', 'SYSADMIN', null);
COMMIT;
Insert into WF_ITEM_ACTIVITY_STATUSES
(item_type, item_key, process_activity, activity_status, activity_result_code, begin_date, execution_time)
Values
('OEOH', '587667', 13825, 'ACTIVE', '#NULL', TO_DATE('11/28/2006 14:17:09', 'MM/DD/YYYY HH24:MI:SS'), 1);
Insert into WF_ITEM_ACTIVITY_STATUSES
(item_type, item_key, process_activity, activity_status, activity_result_code, begin_date, end_date, execution_time)
Values
('OEOH', '587667', 134506, 'COMPLETE', '#NULL', TO_DATE('11/28/2006 14:59:51', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('11/28/2006 14:59:53', 'MM/DD/YYYY HH24:MI:SS'),
16);
Insert into WF_ITEM_ACTIVITY_STATUSES
(item_type, item_key, process_activity, activity_status, begin_date, end_date, execution_time)
Values
('OEOH', '587667', 134508, 'COMPLETE', TO_DATE('11/28/2006 14:17:09', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('11/28/2006 14:59:50', 'MM/DD/YYYY HH24:MI:SS'), 7);
Insert into WF_ITEM_ACTIVITY_STATUSES
(item_type, item_key, process_activity, activity_status, activity_result_code, begin_date, end_date, execution_time)
Values
('OEOH', '587667', 134510, 'COMPLETE', 'COMPLETE', TO_DATE('11/28/2006 14:59:50', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('11/28/2006 14:59:51', 'MM/DD/YYYY
HH24:MI:SS'), 14);
Insert into WF_ITEM_ACTIVITY_STATUSES
(item_type, item_key, process_activity, activity_status, activity_result_code, begin_date, end_date, execution_time)
Values
('OEOH', '587667', 134512, 'COMPLETE', '#NULL', TO_DATE('11/28/2006 14:17:09', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('11/28/2006 14:17:09', 'MM/DD/YYYY HH24:MI:SS'),
5);
Insert into WF_ITEM_ACTIVITY_STATUSES
(item_type, item_key, process_activity, activity_status, activity_result_code, begin_date, execution_time, outbound_queue_id)
Values
('OEOH', '587667', 134540, 'DEFERRED', '#NULL', TO_DATE('11/30/2006 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 41, '2349130043C6814CE0430A0A02EF814C');
Insert into WF_ITEM_ACTIVITY_STATUSES
(item_type, item_key, process_activity, activity_status, activity_result_code, begin_date, end_date, execution_time)
Values
('OEOH', '587667', 134629, 'COMPLETE', 'COMPLETE', TO_DATE('11/28/2006 14:17:09', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('11/28/2006 14:59:53', 'MM/DD/YYYY
HH24:MI:SS'), 4);
Insert into WF_ITEM_ACTIVITY_STATUSES
(item_type, item_key, process_activity, activity_status, begin_date, execution_time)
Values
('OEOH', '587667', 134630, 'ACTIVE', TO_DATE('11/28/2006 14:59:53', 'MM/DD/YYYY HH24:MI:SS'), 40);
Insert into WF_ITEM_ACTIVITY_STATUSES
(item_type, item_key, process_activity, activity_status, activity_result_code, begin_date, end_date, execution_time)
Values
('OEOH', '587667', 134633, 'COMPLETE', '#NULL', TO_DATE('11/28/2006 14:17:09', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('11/28/2006 14:17:09', 'MM/DD/YYYY HH24:MI:SS'),
2);
COMMIT;
end;
/*
執行這段sql後,就去run: Interface Trip Stop - SRS
如選不到trip stop
則執行如下sql,其中trip_id為真實的id
UPDATE wsh_trip_stops
SET pending_interface_flag = 'Y'
--select pending_interface_flag from wsh_trip_stops
WHERE trip_id=583164
and exists (select 1 from wsh_new_deliveries wd, wsh_delivery_legs wdl
where wd.delivery_id = wdl.delivery_id
and wdl.PICK_UP_STOP_ID = stop_id)
*/
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/92289/viewspace-880613/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 銷貨後訂單還是BOOKED的處理
- 銷貨後訂單LINE還是BOOKED的處理
- PTO的訂單誤CANCELLED後,要重撈的處理
- SAP Commerce(原Hybris)的訂單處理框架和SAP CRM One Order框架框架
- 系統被入侵後的恢復(轉)
- 恢復被刪除的Word選單
- 屬性問題造成ATO料號銷貨後訂單LINE狀態不變的處理
- 恢復被刪除的Word選單(轉)
- 恢復 SQL 被注入後的資料程式碼SQL
- oracle_redo*log,被移動後的恢復Oracle
- 撿料或銷貨不成功,卡在inv的transaction move order的處理
- 處理恢復資料方法
- 出貨不成功,出貨介面為shipped, 部分訂單為booked的處理過程.(有修改)
- 一次不完全恢復中途Kill rman後的問題處理+壞塊處理過程
- QTP恢復場景-處理找不到列表項或選單的情況QT
- 工單未完工但訂單已做 ship confirm 造成訂單shipped卡住,但訂單closed, 工單無法完工入庫
- 內部訂單撿料成功,ship confirm後delivery_id消失,出貨不成功的處理過程
- Oracle 基於使用者管理恢復的處理Oracle
- 無備份恢復各種場景的處理
- 臺積電完勝三星CPU晶片 獨享蘋果A11處理器訂單晶片蘋果
- 路由器登入密碼被改後的恢復方法路由器密碼
- 銷售訂單處理期間的基本功能
- S/4HANA服務訂單Service Order的批量建立
- asp 網站被 sql 注入後的處理辦法網站SQL
- 恢復 Git 被刪除的分支Git
- Git恢復被刪除的分支Git
- 恢復完提示無效物件物件
- 記一次 MySQL 資料庫單表恢復事故處理MySql資料庫
- 硬碟被格式化後真的可以恢復嗎?硬碟
- 生產庫的恢復目錄被RMAN恢復出來的資料庫庫使用後出現的問題資料庫
- 關於SAP生產訂單操作中的問題處理。
- ofbiz對workflow的事務處理是如何做到的
- Linux伺服器被入侵後的處理過程Linux伺服器
- 【伺服器資料恢復】Raid5丟失磁碟後被重建的資料恢復案例伺服器資料恢復AI
- oracle之DELETE後的恢復Oracledelete
- ORACLE—DELETE表後的恢復Oracledelete
- RMAN恢復單個表空間或被DROP/DELETE/TRUNCATE的表delete
- 表資料被誤操作的恢復