4 Replies Latest reply on Feb 2, 2018 4:14 AM by Beauty_and_dBest

    FNDGSCST: Gather Schema Statistics

    Beauty_and_dBest

      EBS 12.2.4

      OL6

       

       

      Hi ALL,

       

      We are running

      FNDGSCST: Gather Schema Statistics

      But we encounter error:

      Error #1: ERROR: While GATHER_TABLE_STATS:
      object_name=GL.JE_BE_LINE_TYPE_MAP***ORA-20001: invalid column name or duplicate columns/column groups/expressions in method_opt***

       

      Please help....

       

      KInd regards,

      jc

       

       

      =============================

       

      +---------------------------------------------------------------------------+
      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 01-FEB-2018 18:30:54

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

      **Starts**01-FEB-2018 18:30:54
      **Ends**01-FEB-2018 18:55:53
      ORA-0000: normal, successful completion
      +---------------------------------------------------------------------------+
      Start of log messages from FND_FILE
      +---------------------------------------------------------------------------+
      In GATHER_SCHEMA_STATS , schema_name= ALL percent= 50 degree = 4 internal_flag= NOBACKUP
      stats on table MSC_INFO_QUEUE_TABLE is locked
      stats on table MSC_NUM_QUEUE_TABLE is locked
      stats on table MSC_TASK_QUEUE_TABLE is locked
      Error #1: ERROR: While GATHER_TABLE_STATS:
      object_name=GL.JE_BE_LINE_TYPE_MAP***ORA-20001: invalid column name or duplicate columns/column groups/expressions in method_opt***
      Error #2: ERROR: While GATHER_TABLE_STATS:
      object_name=GL.JE_BE_LOGS***ORA-20001: invalid column name or duplicate columns/column groups/expressions in method_opt***
      Error #3: ERROR: While GATHER_TABLE_STATS:
      object_name=GL.JE_BE_VAT_REP_RULES***ORA-20001: invalid column name or duplicate columns/column groups/expressions in method_opt***
      +---------------------------------------------------------------------------+
      End of log messages from FND_FILE
      +---------------------------------------------------------------------------+


      +---------------------------------------------------------------------------+
      No completion options were requested.

      Output file size:
      0

      +---------------------------------------------------------------------------+
      Concurrent request completed
      Current system time is 01-FEB-2018 18:55:53

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