My Oracle Support Banner

E-UPG Warnings and Errors when Building the ALLTABS Project (Doc ID 1416795.1)

Last updated on MAY 01, 2018

Applies to:

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


During an Application and Tools Upgrade, a project ALLTABS is created using all records of type = tables.   This does not occur in a Tools Only Upgrade. 

From the ALLTABS project, Sql Scripts are generated to
a. Create new tables:   ALLTABS_CRTTBL.SQL

b. Alter modified tables:   ALLTABS_ALTTBL.SQL

c. Create indexes:  ALLTABS_CRTIDX.SQL 

d. and re-Create database triggers:  ALLTABS_CRTTRG.SQL  [Update: You do not need to run this script, because all database triggers will be created in the Finalizing the Database Structure task.]

These scripts are referred to as "alter without deletes".


Later in the Upgrade, in section Finalizing Database Structure,  the previously created project ALLTABS generates three more SQL scripts:

a.  One that will alter tables to drop obsolete columns: ALLTABS_DEL_ALTTBL.SQL

b.  One that will also create any remaining indexes that could not be created with
the first alter: ALLTABS_DEL_CRTIDX.SQL

c.  And one that will create triggers:   ALLTABS_DEL_CRTTRG.SQL

These scripts are referred to as “alter with deletes”. 

Sometimes during generating these scripts, warnings and errors are given off and can be seen in the

ALLTABS_build.log.  When is it acceptable to ignore these warnings and/or errors?


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.