2 Replies Latest reply on Oct 11, 2017 8:12 AM by Kanda-Oracle

    Scheduled Concurrent Request Submitting Two Jobs

    Ramaraju

      Hi All,

      We have EBS R12.2.5. Scheduled concurrent request are resubmitting the job twice.

       

      pls find below log file for example.

       

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

      Application Object Library: Version : 12.2

      Copyright (c) 1998, 2013, Oracle and/or its affiliates. All rights reserved.

      FNDGSCST: Gather Schema Statistics

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

      Current system time is 04-OCT-2017 02:11:54

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

      **Starts**04-OCT-2017 02:11:58

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

      Application Object Library: Version : 12.2

      Copyright (c) 1998, 2013, Oracle and/or its affiliates. All rights reserved.

      FNDGSCST: Gather Schema Statistics

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

      Current system time is 04-OCT-2017 02:12:07

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

      **Starts**04-OCT-2017 02:12:07

      **Ends**04-OCT-2017 02:12:18

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

      Start of log messages from FND_FILE

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

      In GATHER_SCHEMA_STATS , schema_name= ALL percent=  degree = 1 internal_flag= NOBACKUP

      stats on table WMS_WCS_AQ_QUEUE_TBL is locked

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

      End of log messages from FND_FILE

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

      Successfully resubmitted concurrent program FNDGSCST with request ID 59896140 to start at 04-OCT-2017 03:00:00 (ROUTINE=AFPSRS)

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

      No completion options were requested.

      Output file size:

      0

      Deleting empty output file.

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

      Concurrent request completed successfully

      Current system time is 04-OCT-2017 02:12:18

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

      **Ends**04-OCT-2017 02:12:30

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

      Start of log messages from FND_FILE

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

      In GATHER_SCHEMA_STATS , schema_name= ALL percent=  degree = 1 internal_flag= NOBACKUP

      stats on table WMS_WCS_AQ_QUEUE_TBL is locked

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

      End of log messages from FND_FILE

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

      Successfully resubmitted concurrent program FNDGSCST with request ID 59896151 to start at 04-OCT-2017 03:00:00 (ROUTINE=AFPSRS)

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

      No completion options were requested.

      Output file size:

      0

      Deleting empty output file.

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

      Concurrent request completed successfully

      Current system time is 04-OCT-2017 02:12:30

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

       

      Thanks,

      Ramaraju