The Return of Sparky!
Yup… We’re bringing Sparky Back!
Getting things done with PeopleTools
Learn the basics of creating a BI Pub report for PeopleSoft
The BI Publisher Desktop is the easiest way to create your report templates for BI Publisher Reports. Oracle provides Add-Ins for both Microsoft Word and Excel to help you quickly create new reports and modify existing reports.
Most PeopleTools objects allow a developer to classify and organize the object by the Owner ID field on the Object’s Properties page. This value doesn’t affect the object and is more Information Only. However, it does help during development and upgrades by providing the developer an idea of where this object is used.
The delivered PeopleTools 8.59 home page has a notification panel on the right. This is great if your organization wants a large notification panel on their home page.
… But how do you remove it if they don’t want it?
The PeopleSoft Image Catalog is a simple utility allowing a developer to search for images by name or type and see the image object on the page instead of just relying on the image object name to be descriptive (it’s not).
Sub-Templates allow us to create a commonly used code block such as headers with logos and other information instead of recreating that header on every report. When an item in that header changes, we only need to change the header sub-template instead of every report that uses that common header.
Developers always need access to the file servers for logs, traces, input and output files. I’ve developed this utility to speed development tasks of managing files associated with PeopleTools projects.
Using a quick change, we can get BI Publisher Reports generated through the Process Scheduler to post to the Processes detail page along with the other files and logs.
Properly handling the dates between the XML File and a BI Publisher Excel template is actually quite easy once you understand what is happening and how to correct the issue.