Oracle ERP R12. –Close Discrete Jobs failure (past close date)

一般公司月底在進行工單關結時,其Actual Close Date & Submission Date可能會設成月底日期23:59:59,但若有工單需要重新unclose進行調整後再Close,就會造成failed Close其” Close Discrete Jobs”的log就會看到以下類似訊息:

+---------------------------------------------------------------------------+

Start of log messages from FND_FILE

+---------------------------------------------------------------------------+

WIP DISCRETE JOB CLOSE

GROUP ID 6002

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

Close date precedes the txn date for job 工單號

Number of failed jobs because of past close date : 1

Delivery Quantity Check

Number of jobs failed in Delivered Quantity : 0

lot validate

delete Existing reservations

Current accounting Period ID : 3001

Exception has occured

+---------------------------------------------------------------------------+

End of log messages from FND_FILE

+---------------------------------------------------------------------------+

….

主要原因為Oracle在工單關結時會去WIP_TRANSACTION檢查該工單最後一筆交易日,並限制目前的交易不得早於或等於最後一筆的交易日時間.

如一開始提到的,有些公司會設在月底日期的23:59:59,故工單關結人員不能再輸入月底日期的23:59:59,而必需大於這時間,但就要跨月了.

其可由DATA FIX的方式來解決.做法如下:

1.       找出該工單的WIP_ENTITY_ID

2.       找出WIP_TRANSACTION內該WIP_ENTITY_ID所有交易資料,並找出最大日期的資料(應該就是月底日期23:59:59)

3.       將該資料TRANSACTION_DATE 的時間稍微往前調整.(例如23:59:00)

4.       調整完後,就可重新做Close動作,但其日期必需較上步驟的時間來的晚即可.