In a previous post I showed you how to know what Roles are assigned to a specific user. But here is how you find out what Users are assigned to a specific Role.

Here is a query that I often use to lookup Roles assigned to a specific PeopleSoft user.
At run time, replace :1 with OPRID your are looking for OR user name (partial search also works).

Roles attached to a component (portal_uri_seg2) or content reference (portal_objname)

This is a simple example on when and how to use the Try and Catch built-in function. The code below will fetch a field value from a scroll area on a page and delete the row depending on the value. If the value is >= 0 or if it is a "charachter" value, then go ahead and mark the row for deletion.

See code comments to get a better idea of what the code is doing.

Oracle SQL Developer 1.5 Early Adopter is out. I have been using 1.2 for a while and started testing 1.5 couple days ago. As this is still not the official release, I would have to say things are going pretty good and no bugs so far.

To make things easier on users, you are most likely to order portal content references and portal folders in an alphabetical order. To do that, you need to navigate to your portal structure page (Portal Administrator role required), and edit each content reference and folder sequence numbers to be equal, for example, set them all to 100.

When all of your content references are set to be the same number PeopleSoft will automatically sort them alphabetically.

The picture below shows a Security folder and 2 sub-folders (User Profiles and Permissions & Roles). You can also notice that each sub-folder has 4 more links listed below it (in addition to the More... link). If you are wondering why 4 links and not 6 or 10 links, well, it is 4 links because this is what I want it to be.

How can you set the number of links available under a Portal folder?
Navigate to PeopleTools > Portal > Portal Utilities > System Options and update "Maximum Child Links" to 4.

I Never had this error before while trying to SELECT from a table, but there is always fist time for everything I guess. So, after few minutes of troubleshooting I found out that there is a synonym for the table on DBA_SYNONYMS table but the actual table object doesn't exist on DBA_OBJECTS table.

How did this happen? Well, my guess is someone dropped the table but never did the same for the synonym. So, the synonym ends up referencing itself when ever you select from that table and thus the “Looping chain of synonyms".

I have been used to turn to HideScroll and UnHideScroll functions to hide/unhide grid on a page. These two functions however, remain for backward compatibility only.

The functions have been replaced by HideAllRows and ShowAllRows methods. The methods are equivalent to a loop setting the visible propertly of each row of the rowset to false.
For the code to work though, you need to place your peoplecode in a parent rowset and execute it against a child rowset.

A sample code to read a file using file layouts and insert data read into a record.