Table_name field in the record PSCBO_LOG char length should get extended from 30 to 128
PeopleSoft custom Cost based optimizer analyze code failed with low columns size for table_name field in the record PSCBO_LOG. The issue is, an attempt was made to insert or update a column with a value which is too wide for the width of the destination column. In the PSCBO_LOG record, the TABLE_NAME field is too narrow, so the analyze script failed due to character length issue. Initially it is 30 CHAR and this needs to be extended to 128 CHAR limit to avoid this type of issues in future.
The details of the logs are attached below.
SQL> EXEC PSCBO_STATS.GATHER_SCHEMA_STATS('SYSADM',TRUE);