訂單尚未完全出貨,但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/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- SAP Commerce(原Hybris)的訂單處理框架和SAP CRM One Order框架框架
- [20201221]KTFB Bitmapped File Space Header的恢復.txtAPPHeader
- 處理恢復資料方法
- sqlsever處理資料庫的恢復掛起狀態SQL資料庫
- RMAN恢復之RMAN-06555處理
- Git恢復被刪除的分支Git
- 記一次 MySQL 資料庫單表恢復事故處理MySql資料庫
- S/4HANA服務訂單Service Order的批量建立
- Linux伺服器被入侵後的處理過程Linux伺服器
- 【伺服器資料恢復】Raid5丟失磁碟後被重建的資料恢復案例伺服器資料恢復AI
- 硬碟被格式化後真的可以恢復嗎?硬碟
- 程式設計師，你有新的訂單請及時處理！程式設計師
- Mac中Chrome書籤被誤刪後如何恢復MacChrome
- Chrome書籤被誤刪後如何一鍵恢復Chrome
- 檔案被隱藏了怎麼恢復？讀完你就知道了
- 如何恢復被刪除的 GitLab 專案？Gitlab
- 被誤刪的檔案快速恢復方法
- php訂單延時處理-延時佇列PHP佇列
- 伺服器被入侵後的一些處理辦法伺服器
- uninstall 後的檔案如何恢復
- Linux系統中檔案被刪除後的恢復方法（ext4）Linux
- 實用！Swoole + Redis 佇列 訂單處理系統Redis佇列
- 檔案替換後怎麼恢復，恢復被覆蓋的檔案
- 電腦重灌系統後被格式化了怎麼恢復之前的資料？
- 簡單的字串處理字串
- EBS:OM Sales Order銷售訂單【Open Interface、Open API】API
- 【北亞資料恢復】sqlserver資料庫被加密的資料恢復案例分享資料恢復SQLServer資料庫加密
- QQ恢復解散後的群聊或刪除後的好友的方法
- 剪下後的檔案可以恢復嗎？恢復剪下檔案怎麼辦？
- USB快閃記憶體盤中的檔案被誤刪除，但容量沒有減少，如何恢復？記憶體
- 登錄檔引起的 I/O 操作發生了不可恢復的錯誤處理辦法
- 隨身碟被刪除的檔案如何恢復？
- 恢復EXT3下被刪除的檔案
- 被360防毒刪除的檔案怎麼恢復防毒
- 微軟“粗暴”刪除 WSATools 後續：“道歉”並恢復了WSATools，但刪除理由是“正當的”微軟
- apiAutoTest: 介面自動化測試的資料清洗(備份/恢復)處理方案API
- Mongodb資料庫誤刪後的恢復MongoDB資料庫
- git reset --hard 操作後的資料恢復Git資料恢復
- chkdsk 後資料丟失的恢復方法