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***
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms