在做订单发运确认的时候发生如下异常:
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.
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处于有效状态,可利用下面的语句进行查询:
数据库中触发器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 ;
利用下面的语句使其无效化
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/