Tag Archives: gather schema

Gathering Statistics in Release 11i and R12

In order to use Cost Based Optimizer effectively, the statistics must be current. Fortunately, Oracle has provided some scripts and concurrent programs to make this administrative task easier. FND_STATS is a PL/SQL package for the Applications that has numerous functions that will assist in this administrative task. This package can be invoked either from a seeded Concurrent Program, or directly from SQL*Plus. It is not … Continue reading Gathering Statistics in Release 11i and R12 »

ORA-20001 in R12 Gather schema statistics on 11g(FND_HISTOGRAM_COLS)

Last updated on July 1st, 2019 at 03:07 am“Gather Schema Statistics” program reported following errors in request log files : 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*** … Continue reading ORA-20001 in R12 Gather schema statistics on 11g(FND_HISTOGRAM_COLS) »