I’m an Oracle Ace!
by 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
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.
BI Publisher PDF Templates
BI Publisher enables your system to populate data on the actual PDF form instead of creating and maintaining a separate, custom versions of that form as an RTF template. The savings in time and resources can be enormous.
BI Publisher Charts
BI Publisher Desktop chart wizard enables designers to quickly insert charts into RTF templates.
PeopleSoft ReConnect Live at BLUEPRINT 4D 2023
May 8 – May 11, 2023
Hilton Anatole in Dallas, Texas
Finally, an in person conference to meet and “ReConnect” with the PeopleSoft community.
PSAdmin.io Conference – 2023
This year, psadmin.conf will be an in-person conference held on May 22-24, 2023 in Minneapolis, MN.
Building a PeopleSoft Image – OCI Marketplace
Great post by Dan Iverson at PSAdmin.IO with a step by step walk through of building a PeopleSoft image in your Oracle Cloud account (OCI).
PeopleCode: Adding Images to BI Report
As requested, this is the PeopleCode behind placing images in BI Publisher Reports Episode
BI Pubisher Pivot Tables
At design time, we don’t always know how many rows and columns a table will have, nor what their labels will be. Pivot Tables place a grid on a BI Publisher report that is data dependent.
Use XML Files in BI Publisher with PeopleSoft Batch Reporting
Running a BI Publisher report in batch doesn’t mean it has to use PSQuery as a data source. As per MOS (Doc ID 962712.1), an XML File is the most efficient way to feed the report data.