E-ORA/E-UPG PT 8.50, 8.51, 8.52, 8.53, 8.54, 8.55: Upgrade issues with Psoratimestampconversion.bat (Doc ID 1268933.1)

Last updated on JUNE 16, 2016

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.50 to 8.55 [Release 8.4]
Information in this document applies to any platform.
***Checked for relevance on 21-May-2014***

Symptoms



Psoratimestampconversion.bat = program that generates the sql to

1) drop indexes: DROPINDEXESn.SQL
2) alter: ALTERTIMESTAMPSn.SQL
3) build indexes: REBUILDINDEXESn.SQL


Why this is run:
Understanding Oracle Time Data Types Conversion
In PeopleSoft PeopleTools 8.50 and higher, the TIMESTAMP data type is now supported for the PeopleSoft
TIME and DATETIME field types. These data type changes are mandatory, and the DATE data type will no
longer be used for the TIME and DATETIME fields.
PeopleSoft Change Assistant will display and run the steps in this task only if you are upgrading from
PeopleSoft PeopleTools 8.49 or earlier.

Only for Oracle Plaforms upgrading to Tools 8.50 or Tools 8.51 or higher,  from pre-Tools 8.50 release.

This is performed in the Tools Only Upgrades as well as in Application Upgrades that incorporate a Tools Upgrade.

Cause

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