E-AD: Application Designer Crashes When Building Index With 30+ CLOB Fields

(Doc ID 2227384.1)

Last updated on JUNE 15, 2017

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.55 and later
Information in this document applies to any platform.


 When running the tools upgrade to 8.55.12, the step "Running the Final Alter Audit" fails with:
SQL Build process began on 1/4/2017 at 4:38:33 PM for database HCMDEV91.
File: E:\pt85512b-retail\peopletools\src\psbld\bldcreat.cppSQL error. Stmt #: 1653 Error Position: 0 Return: 31603 - ORA-31603: object "SYS_IL0000236652" of type INDEX not found in schema "SYSADM" ORA-06512: at "SYS.DBMS_METADATA", line 6069 ORA-06512: at "SYS.DBMS_METADATA", line 8666 ORA-06512: at line 1
Failed SQL stmt: SELECT DBMS_METADATA.GET_DDL('INDEX',:1) from dual

This is happening with records that have 30+ CLOB fields. We did not experience this in our 8.53.26 version of tools on Oracle 11g ( We are now on Oracle 12c (


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