Running Gather stats in Oracle Apps Error on FND_STATS_HIST

Error:

When running Gather stats in Oracle apps it fails with below

ERROR: While GATHER_TABLE_STATS:
object_name=APPS.RA_INTERFACE_LINES_ALL_07APR2023**ORA-12899: value too large for column "APPLSYS"."FND_STATS_HIST"."OBJECT_NAME" (actual: 32, maximum: 30)**


Solution:

Modify the Column length

alter table applsys.fnd_stats_hist modify object_name varchar2(128);






If you like please follow and comment