Home » gather schema

gather schema

Gather Schema Statistics Using FND_STATS in EBS 11i and R12

How to Gather schema statistics in oracle apps R12 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 …

Gather Schema Statistics Using FND_STATS in EBS 11i and R12 Read More »

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 …

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

Scroll to Top