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/

To get page level access in PeopleSoft

To get page level access in PeopleSoft:

-------------------------------------------------------------------------------------------------------------------------------------------------------

select x.menuname, x.barname, x.baritemname, x.pnlgrpname, x.itemname, x.itemlabel ,

(select distinct a1.classid from psroleclass a1, PSAUTHITEM x1 where x1.menuname = x.menuname and x1.barname = x.barname and x1.baritemname = x.baritemname and x1.pnlitemname = x.pnlitemname and a1.classid = x1.classid and rolename = 'HM_GPR_SUPER_ADMIN')HM_GPR_SUPER_ADMIN,

(select distinct a2.classid from psroleclass a2, PSAUTHITEM x2 where x2.menuname = x.menuname and x2.barname = x.barname and x2.baritemname = x.baritemname and x2.pnlitemname = x.pnlitemname and a2.classid = x2.classid and rolename = 'HM_GPR_ADVANCE_ADMIN')HM_GPR_ADVANCE_ADMIN,

(select distinct a3.classid from psroleclass a3, PSAUTHITEM x3 where x3.menuname = x.menuname and x3.barname = x.barname and x3.baritemname = x.baritemname and x3.pnlitemname = x.pnlitemname and a3.classid = x3.classid and rolename = 'HM_GPR_ADMIN')HM_GPR_ADMIN,

(select distinct a4.classid from psroleclass a4, PSAUTHITEM x4 where x4.menuname = x.menuname and x4.barname = x.barname and x4.baritemname = x.baritemname and x4.pnlitemname = x.pnlitemname and a4.classid = x4.classid and rolename = 'HM_GPR_BONUS_ADMIN')HM_GPR_BONUS_ADMIN,

(select distinct a5.classid from psroleclass a5, PSAUTHITEM x5 where x5.menuname = x.menuname and x5.barname = x.barname and x5.baritemname = x.baritemname and x5.pnlitemname = x.pnlitemname and a5.classid = x5.classid and rolename = 'HM_GPR_SETUP_ADMIN')HM_GPR_SETUP_ADMIN,

(select distinct a6.classid from psroleclass a6, PSAUTHITEM x6 where x6.menuname = x.menuname and x6.barname = x.barname and x6.baritemname = x.baritemname and x6.pnlitemname = x.pnlitemname and a6.classid = x6.classid and rolename = 'HM_GPR_SETUP_READ')HM_GPR_SETUP_READ,

(select distinct a7.classid from psroleclass a7, PSAUTHITEM x7 where x7.menuname = x.menuname and x7.barname = x.barname and x7.baritemname = x.baritemname and x7.pnlitemname = x.pnlitemname and a7.classid = x7.classid and rolename = 'HM_GPR_BANK_UPDATE')HM_GPR_BANK_UPDATE

from (select distinct a.menuname, a.barname, a.baritemname, a.pnlitemname, p.pnlgrpname, p.itemname, p.itemlabel

FROM PSAUTHITEM a, pspnlgroup p

Where ((a.baritemname = p.pnlgrpname and a.pnlitemname = p.pnlname)

or (a.pnlitemname = p.pnlname and p.pnlgrpname = p.pnlname)

or (a.baritemname = p.pnlgrpname and p.pnlgrpname = p.pnlname))

-- where p.pnlgrpname = a.baritemname

-- and p.itemname = a.pnlitemname

--and pnlitemname = 'GP_DURATION'

and classid in (select distinct classid from psroleclass

where rolename like 'HM_GPR_%'and rolename not in ( 'HM_GPR_TEMP', 'HM_GPR_QUERY', 'HM_GPR_USERS'))

order by menuname, barname, baritemname, pnlgrpname, itemname) x

-------------------------------------------------------------------------------------------------------------------------------------------------------

-- security matrix read/write

select x.menuname, x.barname, x.baritemname, x.pnlgrpname, x.itemname, x.itemlabel ,

(select distinct decode(x1.displayonly ,0, 'Read/Write', 'Display Only') from psroleclass a1, PSAUTHITEM x1 where x1.menuname = x.menuname and x1.barname = x.barname and x1.baritemname = x.baritemname and x1.pnlitemname = x.pnlitemname and a1.classid = x1.classid and rolename = 'HM_GPR_SUPER_ADMIN')HM_GPR_SUPER_ADMIN,

(select distinct decode(x2.displayonly ,0, 'Read/Write', 'Display Only') from psroleclass a2, PSAUTHITEM x2 where x2.menuname = x.menuname and x2.barname = x.barname and x2.baritemname = x.baritemname and x2.pnlitemname = x.pnlitemname and a2.classid = x2.classid and rolename = 'HM_GPR_ADVANCE_ADMIN')HM_GPR_ADVANCE_ADMIN,

(select distinct decode(x3.displayonly ,0, 'Read/Write', 'Display Only') from psroleclass a3, PSAUTHITEM x3 where x3.menuname = x.menuname and x3.barname = x.barname and x3.baritemname = x.baritemname and x3.pnlitemname = x.pnlitemname and a3.classid = x3.classid and rolename = 'HM_GPR_ADMIN')HM_GPR_ADMIN,

(select distinct decode(x4.displayonly ,0, 'Read/Write', 'Display Only') from psroleclass a4, PSAUTHITEM x4 where x4.menuname = x.menuname and x4.barname = x.barname and x4.baritemname = x.baritemname and x4.pnlitemname = x.pnlitemname and a4.classid = x4.classid and rolename = 'HM_GPR_BONUS_ADMIN')HM_GPR_BONUS_ADMIN,

(select distinct decode(x5.displayonly ,0, 'Read/Write', 'Display Only') from psroleclass a5, PSAUTHITEM x5 where x5.menuname = x.menuname and x5.barname = x.barname and x5.baritemname = x.baritemname and x5.pnlitemname = x.pnlitemname and a5.classid = x5.classid and rolename = 'HM_GPR_SETUP_ADMIN')HM_GPR_SETUP_ADMIN,

(select distinct decode(x6.displayonly ,0, 'Read/Write', 'Display Only') from psroleclass a6, PSAUTHITEM x6 where x6.menuname = x.menuname and x6.barname = x.barname and x6.baritemname = x.baritemname and x6.pnlitemname = x.pnlitemname and a6.classid = x6.classid and rolename = 'HM_GPR_SETUP_READ')HM_GPR_SETUP_READ,

(select distinct decode(x7.displayonly ,0, 'Read/Write', 'Display Only') from psroleclass a7, PSAUTHITEM x7 where x7.menuname = x.menuname and x7.barname = x.barname and x7.baritemname = x.baritemname and x7.pnlitemname = x.pnlitemname and a7.classid = x7.classid and rolename = 'HM_GPR_BANK_UPDATE')HM_GPR_BANK_UPDATE

from (select distinct a.menuname, a.barname, a.baritemname, a.pnlitemname, p.pnlgrpname, p.itemname, p.itemlabel

FROM PSAUTHITEM a, pspnlgroup p

Where ((a.baritemname = p.pnlgrpname and a.pnlitemname = p.pnlname)

or (a.pnlitemname = p.pnlname and p.pnlgrpname = p.pnlname)

or (a.baritemname = p.pnlgrpname and p.pnlgrpname = p.pnlname))

-- where (a.pnlitemname = p.pnlname or a.baritemname = pnlname)

--where p.pnlgrpname = a.baritemname

--and p.itemname = a.pnlitemname

--and pnlitemname = 'GP_DURATION'

and classid in (select distinct classid from psroleclass

where rolename like 'HM_GPR_%'and rolename not in ( 'HM_GPR_TEMP', 'HM_GPR_QUERY', 'HM_GPR_USERS'))

order by menuname, barname, baritemname, pnlitemname, itemname) x