Alternate PeopleCode Reference

alternate peoplecode reference

alternate peoplecode reference


I noticed that the new hosted PeopleTools Peoplebooks do not have index functionality like the ones before that. I do use the reference often to look-up usage of various Built In Peoplecode functions, Class methods and properties.

So I went ahead and with help of jQuery and jQuery hightlight plugin constructed this Alternate PeopleCode Reference page based on existing PeopleTools 8.53 hosted peoplebooks in an attempt to streamline the ability to quickly search and get what you need from Oracle hosted PeopleBooks.

Currently included PeopleTools sections: :

  • Built In PeopleCode Functions
  • System Variables Reference
  • MetaSQL Reference
  • Row Class Reference
  • Record Class Reference
  • SQL Class Reference
  • Array Class Reference
  • Session Class Reference

I will attempt to add more as time allows. Let me know if you have any preference or suggestions.

I hope you find this useful.

PeopleSoft Application Designer themeing

App Designer Theme

App Designer Theme

If you used IDEs like Eclipse, Aptana and Notepad++ – they all allow you you to install your own themes, customize color, layout , fonts etc.

I recently read an article in ITWorld | 13 fonts to make a programmer smile. And it inspired me to go ahead and play with App Designer to see if I can make it more fun to write and look at code for myself. In the end of the day – that is where I spent most of my time during the day.

I wanted to share my experience here – I hope this will brighten your day and make you smile. Here are the steps I used:

  1. Download the font – in my case I chose Monaco
  2. Install the fonts, by unzipping them, double-click and Install
  3. And finally open App Designer, open any PeopleCode code definition and git’ to it:
  4. I personally like the lighter themes right now as you can see above, so here are the rest of the steps:

OpenWorld 2014 Registration & Call for Papers

image

Oracle OpenWorld 2014 Registration and call for papers is now open. It was another great \year for PeopleSoft and Oracle so the conference should be as interesting as ever before with a lot of people coming.  There are really 3 events going at the same time

So book yours early to take advantage of the discounts and be able to choose hotels.

I hope to attend this year as well and meet many of you in person.

Menu & Component Navigation Quick Tip

20140320-091413.jpg


I am used to using SQL to quickly find menu or component navigation that I need and recently discovered that the work was already done by Oracle. Starting 9.1 Find Object Navigation Utility is available by going to :

  • Enterprise Components > Find Object Navigation
  • Set Up > System Administration > Utilities > Find Object Navigation

And here is the SQL for navigation if you still want to use that:

/* Find online navigation of a PeopleSoft Component/Page */
SELECT    LEVEL0.PORTAL_LABEL
       || ' > '
       || LEVEL1.PORTAL_LABEL
       || ' > '
       || LEVEL2.PORTAL_LABEL
       || ' > '
       || level3.PORTAL_LABEL
          PATH_TO_COMPONENT
  FROM PSPRSMDEFN level3,
       PSPRSMDEFN level2,
       PSPRSMDEFN level1,
       PSPRSMDEFN LEVEL0
 WHERE     level3.PORTAL_URI_SEG2 = 'TE_APPROVE_SHEET'
       AND level3.PORTAL_PRNTOBJNAME = level2.PORTAL_OBJNAME
       AND level2.PORTAL_PRNTOBJNAME = level1.PORTAL_OBJNAME
       AND level1.PORTAL_PRNTOBJNAME = LEVEL0.PORTAL_OBJNAME
       AND level3.PORTAL_NAME = level2.PORTAL_NAME
       AND level2.PORTAL_NAME = level1.PORTAL_NAME
       AND level1.PORTAL_NAME = LEVEL0.PORTAL_NAME;