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 +---------------------------------------------------------------------------+
posted @ 2015-02-28 15:52  土鸟  阅读(1520)  评论(0编辑  收藏  举报