Comparing NULLs in Oracle SQL
by 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
Author: Randall Groncki
Oracle ACE ♠
PeopleTools Developer since 1996
Lives in Northern Virginia, USA
PeopleSoft PUM: Map the Tools_Client folder
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
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)
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
Time to get your PeopleTools Geek on and update your home labs to the latest PeopleTools 8.62 version
Insights Date Issues
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.
Add a PSQuery to Insights Data Tables
Insight Data Table real estate can be a problem. Too many columns and they get pushed together with data and labels truncated and offset.
And it crashes.
The users always want more, but it’s not pretty.
But we do have a solution: put a PSQuery link in the data grid that is big as they want and will show whatever data you choose
Use Insights Dashboards in Navigation Collections
Use a PeopleSoft Fluid Navigation Collection to organize multiple Insights Dashboards
So, you want better Technicals?
… Then invest in your Functionals.
(another bloviating opinion piece)