Failed jobs because of past close date, closing ticket error

Source: Internet
Author: User
Tags time and seconds

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.