Randall Groncki - PeopleTools Tech Tips

PSQuery Record Security

by Randall GronckiSeptember 5, 2023September 12, 2023

… questions about which roles and permission lists have access to a specific record can be a trip down the multiple rabbit holes.

Search Record Overrides

by Randall GronckiJuly 3, 2023July 3, 2023

Overriding the search record allows us to use the same component in different situations without modifying that component.

We can reuse a component for a specific user group with a targeted search record that doesn’t affect that same component with other users by attaching that component to a different menu and overriding the search record there.

Oracle 23c Free Announcement

by Randall GronckiApril 5, 2023April 5, 2023

They want developers to have the chance to play with the new release and see what it can do before it lands on us like a moose falling out of the sky on a Thursday night….

IsMenuItemAuthorized?

by Randall GronckiMarch 23, 2023March 24, 2023

IsMenuItemAuthorized() is a delivered PeopleCode function that tells us, True or False if the current user has access to a specific page.

Kibana in PeopleSoft Links

by Randall GronckiMarch 15, 2023October 20, 2023

Many of these links cover basic information in different ways. Some are detailed, some are outlines. Find what works best for your learning style.

I’m an Oracle Ace!

by Randall GronckiMarch 5, 2023March 5, 2023

I’ve benefited so much as a PeopleSoft developer from others in the community. It’s an honor to help pay that generosity forward.

Expand your Binds …with PeopleCode

by Randall GronckiFebruary 26, 2023February 26, 2023

PeopleCode has two little gem functions that expand binds: ExpandBindVar and ExpandSqlBinds.

At first glance, these two functions look similar. A cursory glance at PeopleBooks show that they both expand binds in strings. Even the parameter list is the same (not). But how they are used is two very different situations and are not interchangeable.