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.
I recently noticed a bunch of Troubleshooting Assistants appear on MOS. A lot of common issues can be troubleshooted using the Wizard like interface. You just have to follow a few simple steps and it leads you to the top answers for those common issues.
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.
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 */
|| ' > '
|| ' > '
|| ' > '
FROM PSPRSMDEFN level3,
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;