狀況:
測試指定上期日期作為Actual close date, 執行Close Discrete Jobs時, 出現error: Can not delete more than one reservation at a time
log中的訊息:
Can not delete more than one reservation at a time
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
WIP DISCRETE JOB CLOSE
GROUP ID 1101014
Number of jobs failed because release date before close date : 0
Number of jobs failed due to Pending Clocks : 0
Cancelling Move Orders if any exists
return status S
Pending Txns Check
Number of jobs failed due to Pending txns : 0
Inside Procedure Close Date
Number of failed jobs because of past close date : 0
lot validate
delete Existing reservations
Exception has occured
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+
試了幾張工單都是相同問題.
解決方式:
有篇文章說是12.1的bug, 但狀況不太像.
瘋狂測試不同方法, 當把本期的期間打開後, 就正常執行完成了...
Oracle的錯誤訊息本身就是錯誤... Orz...
沒有留言:
張貼留言
注意：只有此網誌的成員可以留言。