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.