---
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
```sql
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
![](https://i.imgur.com/H4kiGd4.png)
3. 再次執行 ship confirm.