failed jobs because of past close date，关工单报错

今天会计反映关不了工单。我们公司关工单的程序是自己开发的，可以整批关。报如下错误。我试着用Standad程序关，可以。看来应该是我们开发的程序有问题。后来发现，是抛到WIP_DJ_CLOSE_TEMP的ACTUAL_CLOSE_DATE的数据有问题，只要没有时分秒的，就会报错。检查自己开发的程序，发现代码中有个判断，时间是每月最后一天，时间就抛TRUNC (SYSDATE)。去掉这个判断，全部抛SYSDATE后，程序恢复正常。
+---------------------------------------------------------------------------+
Work in Process: Version : 12.0.0

Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

WICDCL module: Close Discrete Jobs
+---------------------------------------------------------------------------+

Current system time is 28-FEB-2015 11:46:39

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

**Starts**28-FEB-2015 11:46:41
**Ends**28-FEB-2015 11:46:41
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
WIP DISCRETE JOB CLOSE
GROUP ID 217029
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 1XXXXXXXXX
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 : 57
Exception has occured
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+


+---------------------------------------------------------------------------+
No completion options were requested.

Output file size: 
211

+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 28-FEB-2015 11:46:41

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

转载于:https://www.cnblogs.com/kevinsun/p/4305630.html