Common PeopleSoft Login Problem and Its Solution

Today while installing PeopleSoft Financials 9.0, I ran into an issue logging in to the application with a valid PeopleSoft userid.

Specifically, the error was

SQL error. Stmt #: 2 Error Position: 0 Return: 404 - ORA-01017: invalid username/password; logon denied;

If you get this error, most likely your database schema password (probably SYSADM) is out of sync in the PSACCESSPRFL table. The values for ACCESSID and ACCESSPSWD are encrypted so they will not be shown in clear text. If you know your schema owner's userid and password...try the following:

View the current values in PSACCESSPRFL:
select * from psaccessprfl;

Backup the PSACCESSPRFL table;
create table psaccessprfl_bak as select * from psaccessprfl;

Change the encrypted password in PSACCESSPRFL to the known schema owner's password:
update PSACCESSPRFL
set accessid = 'peoplesoft_schema_id',
accesspswd = 'current_password',
encrypted = 0
where symbolicid =

COMMIT!!!

Log into Application Designer with a valid PeopleSoft userid (VP1, PS, etc.) This will let you back into the app and will automatically encrypt the password in PSACCESSPRFL.

Verify the PSACCESSPRFL information and compare to the last query from the same.
select * from PSACCESSPRFL;

The encrypted value of the ACCESSPSWD will look different if the value was indeed updated from another value.



Credit to Ketan Kothari of the PeopleSoft Experts Blog for the table reference and syntax in this post.