Peoplesoft: How to configure the component’s pagebar via a script?

The Peoplesoft-pagebar can contain the following hyperlinks:

According to customer’s standards, each page should show (only) the ‘Help’ hyperlink, which can be configured via the component properties (yellow marked) as shown in the screenshot below.

 How to establish what components do not meet this standard?

It turned out that all yellow marked properties together make up the (bitmap) value of Peoplesoft systemtable-field PSPNLGRPDEFN.SHOWTBAR (eg. 63 in case of screenshot above). For your convenience,  i added an Excel-sheet which will calculate the value for this systemtable-field based on your input.

Now it’s easy to establish what components do not meet the standard, i used the following script:

SELECT *
FROM PSPNLGRPDEFN pg
WHERE showtbar NOT IN (56,
                       57)
  AND EXISTS
    ( SELECT 'y'
     FROM PSAUTHITEM a
     WHERE a.baritemname = pg.pnlgrpname
       AND EXISTS
         ( SELECT 'y'
          FROM PSROLECLASS rc
          WHERE rc.classid = a.classid
            AND EXISTS
              (SELECT 'y'
               FROM PSROLEUSER ru
               WHERE ru.rolename = rc.rolename)))
ORDER BY pg.pnlgrpname

Next step could be creating an update-script to set PSPNLGRPDEFN.SHOWTBAR (for selected components) to a desired value.

I hope you can use this to your advantage.

(PeopleTools release 8.47.08, Oracle 9i Enterprise Edition Release 9.2.0.6.0 – 64bit Production)

 Viewed 2064 times by 649 visitors

Posted by: Tom Wesseling (2 post(s)).