My Oracle Support Banner

E-UPG: During Upgrade, encrypt.log Shows Only "AccessProfile" As Encrypted, But Not All Users In PSOPRDEFN Table are Encrypted (Doc ID 1635025.1)

Last updated on JULY 15, 2016

Applies to:

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


This was encountered while performing PeopleTools ONLY Upgrade, i.e., Upgrading PeopleTools from PT8.49.11 to PT8.53.06, however it could happen with PeopleSoft Upgrade as well.

While creating Demo data base for PeopleTools Only Upgrade, it is observed that the import script ran to success. But we when checked the encrypt.log it is found that "Access Profile" is only encrypted, instead of all users in PSOPRDEFN table.

Started: Tue Feb 11 16:29:11 2014
Data Mover Release: 8.53.06
Database: DLN24400 (ENG)
Access Profiles successfully encrypted.
Ended: Tue Feb 11 16:29:11 2014
Successful completion

Password of all OPRIDs present in PSOPRDEFN table did not got encrypted and the flag "ENCRYPTED" did not changed from 0 to 1 post encrypt.dms run.

Environment ::
PeopleSoft application and its exact version= HCM v9.0
PeopleSoft application module name. TL-Time and labor

PeopleTools  8.53


The issue can be reproduced at will with the following steps:
1. Install and configure a demo database.
2. Install higher PeopleTools version.
3. Log into the DataMover in bootstrap mode
4. Run the Database setup from Data Mover, (in bootstrap mode).. select Demo option during this process.
5. Upon completion of this demo database creation, open the encrypt.log file
6. it shows the oprids are not encrypted

Password of all OPRIDs present in PSOPRDEFN table are not encrypted.

Password of all OPRIDs present in PSOPRDEFN table should be encrypted.


To view full details, 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 a vibrant support community of peers and Oracle experts.