E-UPG: During Upgrade, encrypt.log Shows Only "AccessProfile" As Encrypted, But Not All Users In PSOPRDEFN Table are Encrypted
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
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.
PeopleSoft application and its exact version= HCM v9.0
PeopleSoft application module name. TL-Time and labor
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.
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