PeopleTools 8.53/ PS 9.2 : PS Query :New Functionality Transformations Using XSLT

In PeopleTools 8.53, Oracle has added a new tab called Transformation. Hmm Transformation heard somewhere.. ya.. used in Integration broker in order to transform(or format) the input message. 

So what is this transformation do with PS/Query ?

PeopleBooks:
PeopleBooks Query Transformations

Basically If you want to transform the PS Query output to a different presentation format rather providing in standard table format.

for eg;  you want table header background with different color & you need some heading for report & want CSV output report readily...etc i..e User Defined Output

In Order to achieve all these kind of things need to have little about  XSLT, HTML and XPATH language.

 basics can be found http://www.w3schools.com/

So I have tried my self example :

Created query & In the Transformation tab & Click Add XSLT name you XSLT (Why naming XSLT coz you can have n number of XSLT formats I dont know the max limit ).

Click & click on Preview XSLT

Solution : TNS:listener does not currently know of SID given in connect descriptor

When em trying to connect db client with the problem TNS the db throws below error

Listener refused the connection with following error: ORA-12505, TNS: listener does not currently know of SID given in connect descriptor.

Checked the TNS everything looks fine.

Login to db server :

Checked ORACLE_SID & ORACLE_HOME environment variables are properly set or not. They looks fine.

Next in command line or putty

$lsnrctl status         (to the know the status of current listener)

the log indicated me  listener started with no services. Googled the to understand the issue found out I need to run below command inorder to link db with listener.

Logged as : sqlplus / as sysdba & excuted below command by changing the host & port

alter system set local_listener=' (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=test.local)(PORT=1521)))'

Then excuted the $lsnrctl status

the log indicated listener connected with db instance, and TNS entries may be the issue need to verify TNS entry at db client.

after that successfully connected to oracle db client

:-)

      

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.