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

Last updated on DECEMBER 01, 2016

Applies to:

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

*****reviewed for currency Dec 2016*****

Goal

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?

Solution

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