My Oracle Support Banner

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 MAY 25, 2023

Applies to:

Oracle General Ledger - Version 12.0.0 and later
Oracle Financials for EMEA - Version 12.0.0 and later
Oracle E-Business Suite 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

To view full details, sign in with your My Oracle Support account.

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

In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.