Today's accounting reflects no work orders. Our company's procedures for closing work orders are self-developed, can be the whole batch off. The following error is reported. I tried to use the Standad program to shut it down. It seems that we have a problem with the program we develop. Later found that is thrown into the wip_dj_close_temp of the actual_close_date data there is a problem, as long as there is no time and seconds, will be error. Check your own development of the program, found in the code has a judgment, time is the last day of the month, time is thrown trunc (sysdate). After removing this judgment, the program returns to normal after all the sysdate are thrown.
+---------------------------------------------------------------------------+work in process:version: 12.0.0Copyright (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 closegroup ID 217029Number of Jobs failed because release date before close date : 0Number of Jobs failed due to Pending clocks:0cancelling Move Orders If any exists return status spending Txns checkn Umber of Jobs failed due to Pending txns:0inside Procedure Close date Close date precedes the Txn date for job 1XXXXXXXX XnumbEr of failed jobs because of past close date:1delivery Quantity CheckNumber of jobs failed in delivered Quantity:0lot Validatedelete Existing reservationscurrent Accounting Period id:57exception has occured+---------------------------- -----------------------------------------------+end of log messages from Fnd_file+--------------------------------- ------------------------------------------++------------------------------------------------------------------- --------+no completion options were requested. Output file size:211+---------------------------------------------------------------------------+concurrent Request Completedcurrent system time is 28-feb-2015 11:46:41+------------------------------------------------------- --------------------+
Failed jobs because of past close date, closing ticket error