Tuesday, February 26, 2013

Solution : ORA-01017: invalid username/password; logon denied (Peoplesoft Application Designer)

Recently when em working with PeopleSoft VM template faced below problem while loging to Application designer.

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

Solution:

1. Run the grant.sql script (available in /scripts folder)
       & modified the script - replace the with people
   

                  grant select on PSSTATUS to people;
                  grant select on PSOPRDEFN to people;
                  grant select on PSACCESSPRFL to people;

      Executed with sysadm/sysadm user.

2. Checked the PSACCESSPRFL table for accessid & password.

       select * from PSACCESSPRFL; 

  The accessid & accesspwd fields are encrypted so I dont know the existing existing userid & password so I  ran below script to modify the table.

      update PSACCESSPRFL set accessid = 'sysadm',accesspswd = 'sysadm', encrypted =0;

after all these I am able to login successfully to app designer.


4 comments:

Max Onlinetraining said...

Thanks for providing information on people soft admin.people-softadmin

Srinivas Reddy said...

You are welcome

harry said...

HI i followed the step what you have said, but same invalid username and password is showing for me... pls guide

chandra sekhar Bhavanam said...

keep sharing this type of good informationsap

netweaver training in hyderabad