订单发运确认时的错误

在做订单发运确认的时候发生如下异常：
ERROR
Unexpected Error: Error in Routine WSH_NEW_DELIVERY_ACTIONS.setInTransit,
Oracle Error - -29280
ORA-29280: invalid directory path
ORA-6512: at "SYS.UTL_FILE", line 29
ORA-6512: at "SYS.UTL_FILE", line 448
ORA-6512: at "APPS.ADS_UTIL_PKG", line 22
ORA-6512: at "APPS.ADS_WSH_DELIVERY_DET_TRG1", line 67
ORA-1403: no data found
ORA-4088: error during execution of trigger 'APPS.ADS_WSH_DELIVERY_DET_TRG1'
2 stops had errors and could not be closed.

异常原因：
数据库中触发器ADS_WSH_DELIVERY_DET_TRG1处于有效状态，可利用下面的语句进行查询：

SELECT TRIGGER_NAME,STATUS,OWNER  FROM  DBA_TRIGGERS  

WHERE  TRIGGER_NAME  LIKE  '%ADS_WSH_DELIVERY_DET_TRG1%';

解决方案：
利用下面的语句使其无效化
ALTER  TRIGGER  ADS_WSH_DELIVERY_DET_TRG1 DISABLE ;

做ship confirm的时候画面下部按钮全部不可用，是因为用户没有分配挑库和发运确认权限。因此要授权，在shipping-》setup-》grants and role definition-》grant

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26101098/viewspace-706250/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26101098/viewspace-706250/