Skip to content
PeopleTools Tech Tips

PeopleTools Tech Tips

Getting things done with PeopleTools

  • Calendar
  • PT3 YouTube Channel
  • Oracle Support
  • About PT3
  • Privacy Policy
  • Calendar
  • PT3 YouTube Channel
  • Oracle Support
  • About PT3
  • Privacy Policy

Author: Randall Groncki

Oracle ACE ♠ PeopleTools Developer since 1996 Lives in Northern Virginia, USA
BI Publisher TBAddin64 Error Fix

BI Publisher TBAddin64 Error Fix

Randall Gronckiby Randall GronckiOctober 10, 2024October 11, 2024

BI Publisher Desktop appears to be now fixed!

BI Publisher TBAddin64 Error work around

BI Publisher TBAddin64 Error work around

Randall Gronckiby Randall GronckiSeptember 20, 2024September 20, 2024

Microsoft Office 365 updates have disrupted the BI Publisher Desktop Add-In for Word and Excel, stopping the creation and support of BI Publisher RTF report templates. Oracle is working on a bug fix, but a comunity member has provided a workaround involving registry edits. The steps include adding registry keys and reactivating the Add-In.

BI Publisher PDF Security

BI Publisher PDF Security

Randall Gronckiby Randall GronckiJune 25, 2024June 25, 2024

Using PeopleTools and PeopleCode, we can add additional security features to BI Publisher generated PDF reports to help safeguard your company’s data.

PSQuery Date Math

PSQuery Date Math

Randall Gronckiby Randall GronckiMarch 27, 2024March 27, 2024

PSQuery is a great tool for PeopleSoft ad hoc reporting. But it does have a challenge when it comes to working with Dates.
Use MetaSQL to manipulate dates in PSQuery

What if the next ERP UI is AI?

What if the next ERP UI is AI?

Randall Gronckiby Randall GronckiMarch 8, 2024March 8, 2024

This is more than just chatbots with key words and behaviors. 

Let it have the whole thing.  Let it learn what and how from the system.

AI isn’t coming after me…

AI isn’t coming after me…

Randall Gronckiby Randall GronckiMarch 1, 2024March 1, 2024

AI isn’t putting me out of my job today.  
I’m feeling pretty good about tomorrow too.

Creating Materialized Views in PeopleTools

Creating Materialized Views in PeopleTools

Randall Gronckiby Randall GronckiFebruary 18, 2024February 18, 2024

Use Materialized Views to improve poor performance of complex SQL Views

QR Codes in BI Publisher

QR Codes in BI Publisher

Randall Gronckiby Randall GronckiDecember 19, 2023December 19, 2023

QR Codes are machine-readable graphics that store information.
BI Publisher (theoretically) can print two types of codes: QR Codes and PDF417 codes.

Formatting DateTime Fields in BI Publisher Excel Templates

Formatting DateTime Fields in BI Publisher Excel Templates

Randall Gronckiby Randall GronckiOctober 29, 2023October 30, 2023

We’ll discuss how to bring in Date-time fields from an XML file and convert it to an Excel Date-time format making it more readable for your users and manipulable through Excel’s date-time math and formats.

BI Publisher Report Categories

BI Publisher Report Categories

Randall Gronckiby Randall GronckiOctober 7, 2023October 7, 2023

PeopleSoft uses BI Publisher Report Categories to control if a user has access to run any specific BI Publisher report. This access controls whether a user can run a report and if they can even see the report definition.

Posts pagination

Previous 1 2 3 4 … 9 Next

Recent Posts

  • Insights 03: Search Objects
  • Insights 02: Data & Query
  • Insights 01: Terms
  • Insights 00: A Plan
  • Comparing NULLs in Oracle SQL

Categories

Archives

Upcoming Events

Notice
There are no upcoming events.

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
Buy me a coffee or help out with the OCI costs
Buy me a coffee or help out with the OCI costs
Copyright © 2026 PeopleTools Tech Tips.