How to find version of Peopletools and Application?

What is the PeopleTools version?

SQL> select TOOLSREL from sysadm.PSSTATUS; TOOLSREL -------------------- 8.52

What is the latest Peoplesoft patch that was applied and how often patches are applied?

SQL> select * from  sysadm.PS_MAINTENANCE_LOG order by DTTM_IMPORTED desc;

What is the Oracle database version?

SQL> SELECT VERSION FROM V$INSTANCE; VERSION ----------------- 12.1.0.1.0

Is the database Unicode or Non-Unicode?

1 =  UNICODE

0 =  Non-Unicode

SQL> select UNICODE_ENABLED from sysadm.PSSTATUS; UNICODE_ENABLED ---------------              0

When database was refreshed?

SQL> select CREATED from V$DATABASE; CREATED --------- 15-JAN-14

I hope this helps.

Please feel free to leave your questions or suggest improvements to this section.