How to Gather statistics in EBS In order to use Cost Based Optimizer effectively, the schema statistics must be current. Fortunately, Oracle EBS has provided some scripts and concurrent programs(Gather Schema Statistics and Gather Table statistics) to make this administrative task easier. FND_STATS is a PL/SQL package for the Applications that has numerous functions that […]
gather schema
ORA-20001 in R12 Gather schema statistics on 11g(FND_HISTOGRAM_COLS)
“Gather Schema Statistics” program reported the 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 […]