Gather Schema Statistics Failing for GL Tables, GL.JE_BE_LINE_TYPE_MAP***ORA-20001: invalid column name (Doc ID 2112879.1)

Last updated on JUNE 24, 2016

Applies to:

Oracle General Ledger - Version 12.0.0 and later
Oracle Financials for EMEA - Version 12.0.0 and later
Oracle Applications Technology Stack - Version 12.0 and later
Information in this document applies to any platform.
FNDGSCST module: Gather Schema Statistics

Symptoms

FNDGSCST module: Gather Schema Statistics fails for GL tables.

The log file shows:

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***
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***

Changes

Ran the request

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms