Gather Schema Statistics Fails with: FDPSTP Failed Due To ORA-12899: Value Too Large For Column "APPLSYS"."FND_STATS_HIST"."SCHEMA (Doc ID 1905601.1)

Last updated on OCTOBER 04, 2016

Applies to:

Oracle Concurrent Processing - Version 12.1.3 to 12.2 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

 The gather statistics concurrent program fails with the following errors in the concurrent request logfile:

FNDGSCST module: Gather Schema Statistics
+---------------------------------------------------------------------------+

Current system time is 28-JUN-2014 19:00:46

+---------------------------------------------------------------------------+

**Starts**28-JUN-2014 19:00:47
ORACLE error 12899 in FDPSTP

Cause: FDPSTP failed due to ORA-12899: value too large for column "APPLSYS"."FND_STATS_HIST"."SCHEMA_NAME" (actual: 36, maximum: 30)
ORA-06512: at "APPS.FND_STATS", line 780
ORA-06512: at line 1
.

The SQL statement being exe
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
In GATHER_SCHEMA_STATS , schema_name= ALL:20:8:NOBACKUP::LASTRUN:GATHER::Y percent= 10 degree = 24 internal_flag= NOBACKUP
ORA-12899: value too large for column "APPLSYS"."FND_STATS_HIST"."SCHEMA_NAME" (actual: 36, maximum: 30)
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+
Successfully resubmitted concurrent program FNDGSCST with request ID 7124699 to start at 05-JUL-2014 19:00:00 (ROUTINE=AFPSRS)

 

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