今天会计反映关不了工单。我们公司关工单的程序是自己开发的,可以整批关。报如下错误。我试着用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
+---------------------------------------------------------------------------+