Sep 20

Print this Post

Bind Variables on PeopleSoft Home Page

Prior to PT 8.48 release, there was a record WEBLIB_MENU, using which we were able to pass the dynamic variables to show the same on PeopleSoft Home Page. Below is the
resolution (Resolution # 1, copied from Oracle PeopleSoft Metalink site)

From PT 8.48 and above, one will not be able to find out the record WEBLIB_MENU. The design has been changed. Below is another resolution (Resolution # 2) how to pass the bind
variables like User ID, Instance name etc on the home page.

Resolution # 1 (Prior to PT 8.48, Oracle PeopleSoft Metalink, resolution ID # 623430.1)

E-PIA : How do you add/modify bind variables to change the look and feel. [ID 623430.1]

Resolution # 2 (PT 8.48 and above)

1. Open up App Package PT_BRANDING > Class BrandingBase in application designer. Search for the string ‘add &addjs’. Add the below code above the comment which contains the string ‘add &addjs’:

&greeting = “User: ” %UserId ” in Database: ” %DbName;

The overall code will be like:

/* Added to show the bind variables on the home page */
&greeting = “User: ” %UserId ” on Database: ” %DbName;
/* add &addjs to PT_IFRAME_HDR_SWAN (bind 22) and PT_IFRAME_HDR(bind 23) */

If this looks fine in presentation, its okay, however, the style/font of this variable “&greeting” can be taken care by PSHOMEPAGE Style Sheet

2. Open the PSHOMEPAGE Style Sheet in application designer, locate the “greeting” style class and replace this piece of code with the below code:

/*.greeting {
color: #FFFFFF;
font-family: Arial, Helvetica, sans-serif;
font-size: 12pt;
font-weight: bold;

/* Customized for the home page bind variables looks*/

.greeting {
color: #FFFFFF;
font-family: Arial, Helvetica, sans-serif;
font-size: 10pt;
font-weight: bold;

The above delivered code is commented and below is the customized one. You can use more alterations according to your choice.

Hope this will be of some help.


Permanent link to this article: http://alokbhardwaj.com/oracle-peoplesoft/2010/09/20/bind-variables-on-peoplesoft-home-page/

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>