Compareit - Powerful tool to compare files

Compareit is very powerful tool to compare data. Its free and can download it from internet. Some of the links where we can download it form are given below.

http://www.grigsoft.com/wincmp3.htm
http://download.cnet.com/Compare-It/3000-2248_4-10832602.html

MailMerge - Simple reporting in MS Office

We can use MS Office feature called MailMerge to generate simple reports. We can prepare template in Word, link data from Excel sheet. Follow below links for the procedure.

http://office.microsoft.com/en-us/word-help/CH010062628.aspx
http://mistupid.com/technical/mailmerge/

Access the Menu Security page (PeopleTools, Portal, View Menu Security)

Path: Main Menu > PeopleTools > Portal > View Menu Security


Use this page to view a list of folders or content references to which a user ID, role, or permission list has access. View Menu Folder Structure and View Menu Item Detail in the same path as above are also useful.

Tables

To find all the Oracle Database Tables: SELECT * FROM TAB;
To find all the PS AppDesigner Tables: SELECT * FROM PSRECDEFN;

To Migrate Audit Records/Settings

When a record is migrated to other instance (ex: DEV to STG) whose audit settings are changed, destination instance audit will not work properly. To avoid this situation, we have to manually update the audit record in destination instance and save.

If we have too many records, the above procedure is not suggestible. instead, we copy data from below tables from source instance to destination instance. we can use DMS for that. (Please test it first before implementing for all the records)


SELECT * FROM SYSADM.PSRECFIELD WHERE RECNAME = 'PSOPRDEFN';
SELECT * FROM SYSADM.PSRECDEFN WHERE RECNAME = 'PSOPRDEFN';

PeopleSoft Blog

http://ps.mytechspeak.com/