Skip to content
PeopleTools Tech Tips

PeopleTools Tech Tips

Getting things done with PeopleTools

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

Author: Randall Groncki

Oracle ACE ♠ PeopleTools Developer since 1996 Lives in Northern Virginia, USA
PeopleSoft HCM PUM54 OCI Insights Fails
Insights Dashboards / Technology / Utilities

PeopleSoft HCM PUM54 OCI Insights Fails

Randall Gronckiby Randall GronckiFebruary 15, 2026March 11, 2026

The Insights server in the OCI Marketplace HCM PUM54 image fails due to a bad parameter in the opensearch-dashboards.service file

Insights 04: Extract Data to Insights
Insights Dashboards / Insights Training

Insights 04: Extract Data to Insights

Randall Gronckiby Randall GronckiFebruary 7, 2026March 11, 2026

Scheduling Search Indexes moves our data from PeopleSoft to OpenSearch. Once OpenSearch has ingested that data, we can then use it in our Visualizations.

Insights 03: Search Objects
Insights Dashboards / Insights Training / Uncategorized

Insights 03: Search Objects

Randall Gronckiby Randall GronckiFebruary 1, 2026March 11, 2026

PeopleSoft Search Objects define and control datasets in OpenSearch

Insights 02: Data & Query
Insights Dashboards / Insights Training

Insights 02: Data & Query

Randall Gronckiby Randall GronckiJanuary 25, 2026March 8, 2026

Part 2 of our PeopleSoft Insights Series

How to create a PSQuery to Extract Insights Data.

Insights 01: Terms
Insights Dashboards / Insights Training

Insights 01: Terms

Randall Gronckiby Randall GronckiJanuary 17, 2026January 17, 2026

Your team needs common, concise terms when designing Insights Dashboards. Calling everything a “widget” creates misunderstandings and slows progress.
This post is a dictionary and reference of proper terms when working with PeopleSoft Insights Dashboards

Insights 00: A Plan
Insights Dashboards / Insights Training

Insights 00: A Plan

Randall Gronckiby Randall GronckiJanuary 4, 2026June 2, 2026

I’m creating a series of short posts on PeopleSoft Insights.

It would be nice to know where we’re going, how to get there, and we need some common language.

Comparing NULLs in Oracle SQL
Oracle / PeopleTools / SQL

Comparing NULLs in Oracle SQL

Randall Gronckiby Randall GronckiDecember 20, 2025January 4, 2026

Nulls are special in Oracle SQL – we can’t directly compare them since they won’t equal anything including themselves.
Use Oracles NVL() function to compare fields that may contain Null values

PeopleSoft PUM: Map the Tools_Client folder
PeopleTools / PUM

PeopleSoft PUM: Map the Tools_Client folder

Randall Gronckiby Randall GronckiDecember 5, 2025January 4, 2026

You’ve successfully installed your PeopleSoft PUM. Now map to the PUM’s /tools_client/ folder and install the latest PeopleTools on your local machine.

Bloom’s Logical Fallacy Field Guide
Other / Technology

Bloom’s Logical Fallacy Field Guide

Randall Gronckiby Randall GronckiNovember 5, 2025January 4, 2026

It’s part of our job, everyday, not only work, lead and convince others about our ideas and goals, but to evaluate these goals, plans and ideas of everyone around us. ERP systems are never a result of one person’s edicts.

AI is taking all our jobs tomorrow! (maybe not)
Other / Technology

AI is taking all our jobs tomorrow! (maybe not)

Randall Gronckiby Randall GronckiOctober 22, 2025January 4, 2026

An excellent article about the real historical pace of technical adoption. So how does our PeopleSoft skills fall into this?

PeopleTools 8.62 Available in HCM PUM 53
Oracle / PeopleTools / PUM / Technology

PeopleTools 8.62 Available in HCM PUM 53

Randall Gronckiby Randall GronckiOctober 19, 2025October 19, 2025

Time to get your PeopleTools Geek on and update your home labs to the latest PeopleTools 8.62 version

Insights Date Issues
Insights Dashboards

Insights Date Issues

Randall Gronckiby Randall GronckiOctober 10, 2025January 4, 2026

I’ve encountered two issues with dates in PeopleSoft Insights Dashboards:
• Null dates in data tables
• Displaying the correct date rather than the UTC date

We’re going to discuss work arounds for these two issues using scripted fields.

Posts pagination

Previous 1 2 3 … 9 Next

Recent Posts

  • Oracle Ace Pro: 2026-2027
  • Insights 13: Bar Charts
  • Insights 12: Pie Charts
  • Insights 11: Real Time Indexing
  • Insights 10: Deploy & Present Insights Dashboards

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.