My Oracle Support Banner

R12: Gather Schema Statistics Program Fails with Error ORA-12899 on Custom Table. (Doc ID 2934828.1)

Last updated on JANUARY 20, 2025

Applies to:

Oracle Payables - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

"Gather Schema Statistics" program (FNDGSCST) fails when the custom table name exceeds 30 Characters.

For example:  Custom table CUSTOM_XXXXXXX_APPROVER_REPORT_TABLE
Table Name is 36 characters long.

"Gather Schema Statistics" request Log file shows the following Error:

Error #1: ERROR: While GATHER_TABLE_STATS: object_name=APPS.CUSTOM_PO_SELF_APPROVER_REPORT_TABLE***ORA-12899: value too large for column "APPLSYS"."FND_STATS_HIST"."OBJECT_NAME" (actual: 36, maximum: 30)***

 

Steps to reproduce:

  1. In the APPS DB schema, create a custom table with a name more than 30 characters long, for example CUSTOM_XXXXXXX_APPROVER_REPORT_TABLE.
  2. Log into Oracle Applications using "System Administrator" responsibility.
  3. Open the "Standard Request Submission" (SRS) screen
    (N) Other > Requests > Run
  4. Find/Execute the "Gather Schema Statistics" program.  For the "Schema Name" parameter, enter APPS

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