Tag Archives: gather schema

Gathering Statistics in Release 11i and R12

Last updated on December 21st, 2015 at 08:00 amIn order to use CBO 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 … Continue reading Gathering Statistics in Release 11i and R12 »

ora-20001 in Gather schema stats on 11g(FND_HISTOGRAM_COLS)

Last updated on December 21st, 2015 at 06:14 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 Gather schema stats on 11g(FND_HISTOGRAM_COLS) »