Many times you may get a request from user to reset his password and you can not login to PeopleSoft Web App to do that. Here is a way to reset the password using your database SQL utility. This assumes that you can login to your database using valid Peoplesoft db account or superuser account.
This resets the password = oprid
update psoprdefn
set operpswd = oprid,
encrypted = 0
where oprid = any_oprid;
Login to data mover (bootstrap mode or regular mode)
and run encrypt_password oprid;
2. For some reason, you login to Appdesigner and it gives following error message
SQL error. Stmt #: 2 Error Position: 0 Return: 404 - ORA-01017: invalid username/password; logon denied;
This indicated that your database password and password stroed in PSACCESSPRFL (Encrypted format in accesspswd) are not in sync.
Run the following command in your database SQL Utility
update PSACCESSPRFL
set accessid = 'peoplesoft_schema_id',
accesspswd = 'current_password',
encrypted = 0
where symbolicid = <your symbolic id>
Login to App designer and it will let you login again and also encrypt the password in PSACCESSPRFL
