Tuesday, February 6, 2007

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:
set accessid = 'peoplesoft_schema_id',
accesspswd = 'current_password',
encrypted = 0
where symbolicid =


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.

Monday, February 5, 2007

5 New Applications Releases

January 31 / February 1 brought about the general availability of the following major release updates:

Oracle E-Business Suite Release 12
PeopleSoft Enterprise 9.0 (All modules)
JD Edwards EnterpriseOne 8.12
JD Edwards World A9.1
Siebel Release 8.0

I am currently working on some PeopleSoft 9.0 installations and will be specifically looking at the integration aspects of the apps as they pertain to Fusion Middleware. Our team is currently rolling a PeopleSoft 8.9-focused integration workshop focused on the use of the Fusion Middleware products (BPEL PM, ESB, WebCenter, etc). I will be very interested to see the differences between releases and will pass on my findings.