---
tags: blog
---

# Ship Confirm 後, line 無法 Close
2020/1/1

OM Line 執行 Ship Confirm 後, Line 狀態由 Open 變成 Confirmed, 無法被 Closed.

出現以下的錯誤訊息:

Submitted 4 out of 4 documents for this document set. (REQ_IDS=5952525, 5952526, 5952527, 5952528)
------------------------------------
Ship to Deliver Workflow is launched for delivery 3851376.
------------------------------------
Unexpected Error: Error in Routine WSH_NEW_DELIVERY_ACTIONS.setInTransit,  Oracle Error - -29280
ORA-29280: invalid directory path
ORA-06512: at "SYS.UTL_FILE", line 41
ORA-06512: at "SYS.UTL_FILE", line 478
ORA-06512: at "APPS.ADS_UTIL_PKG", line 22
ORA-06512: at "APPS.ADS_WSH_DELIVERY_DET_TRG1", line 67
ORA-01403: no data found
ORA-04088: error during execution of trigger 'APPS.ADS_WSH_DELIVERY_DET_TRG1'
------------------------------------
Error: Stop M1- Seattle Mfg:Seattle cannot be set to status CLOSED.
------------------------------------
1 deliveries will be marked as Confirmed.

解法參考: [Unable to Clsoe Deliveries](https://www.oracle.com/webfolder/community/oracle_e-business_suite/3046171.html)

解法:
1. 登入 EBS 資料庫, 執行以下 SQL, disable `ADS_WSH_DELIVERY_DET_TRG1` trigger

select trigger_name,status,owner from dba_triggers
where trigger_name like '%WSH_DELIVERY%';

alter trigger ADS_WSH_DELIVERY_DET_TRG1 disable;

2. 找到 OM Line 的 delivery line, reopen 此 delivery line, 將狀態改為 open

3. 再次執行 ship confirm.