R12: AP: When Attempting To Run Gather Schema Statistics, It Fails With Error 'ORA-20001: invalid column name or duplicate columns/column groups/expressions in method_opt' (Doc ID 2945364.1)

Last updated on MAY 08, 2023

Applies to:

Symptoms

When attempting to run Gather schema statistics, the following error is observed for AP module:

ERROR
-----------------------

In GATHER_SCHEMA_STATS , schema_name= AP percent= 10 degree = 64 internal_flag= NOBACKUP
Error #1: ERROR: While GATHER_TABLE_STATS:
object_name=AP.JE_FR_DAS_010***ORA-20001: invalid column name or duplicate columns/column groups/expressions in method_opt***
Error #2: ERROR: While GATHER_TABLE_STATS:
object_name=AP.JE_FR_DAS_010_NEW***ORA-20001: invalid column name or duplicate columns/column groups/expressions in method_opt***
Error #3: ERROR: While GATHER_TABLE_STATS:
object_name=AP.JG_ZZ_SYS_FORMATS_ALL_B***ORA-20001: invalid column name or duplicate columns/column groups/expressions in method_opt***



STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. View => Request=> Submit a new request
2. Run Gather schema statistics concurrent program
3. Observed error message in concurrent request log files
   'ORA-20001: invalid column name or duplicate columns/column groups/expressions in method_opt'

Cause

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