Saving Transparent Data Encryption Information

PeopleSoft Change Assistant will display and run this step only if you are upgrading from PeopleSoft PeopleTools 8.50 or higher.

If you have defined encrypted fields within PeopleSoft PeopleTools for Oracle’s Transparent Data Encryption (TDE) feature, note that all metadata field definitions are delivered from PeopleSoft applications without any encryption attributes enabled. PeopleSoft applications will not deliver any metadata indicating that encryption is enabled for any field for an initial installation database file, project, or a PeopleSoft PeopleTools or PeopleSoft application patch. If you customize any fields by adding TDE encryption, you will need to keep track of the fields and their associated record definitions and ensure that you maintain the desired encryption status throughout any upgrades that you perform.

If you have TDE enabled, run PS_HOME\SCRIPTS\preupgtdeprocess.sql. This script clears the TDE encryption algorithm currently defined in the PeopleSoft metadata. The script also creates two projects, ENCRYPTEDFLDSB and ENCRYPTEDTBLSB. The project ENCRYPTEDFLDSB contains fields that currently have distinct encrypted columns and the project ENCRYPTEDTBLSB contains recfields that currently have distinct encrypted columns, as indicated in the Oracle database catalog.

You will need the information in the projects and the log file that results from running this script in order to reimplement TDE after the upgrade.

See “Completing Database Changes,” Enabling Oracle Transparent Data Encryption.

Properties

Database Orientation	Pass Type	Products	Platforms	Languages
Target	All	All	Oracle	All