PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

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);

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center