#330 – New to 9.2

This week on the podcast, Kyle and Dan talk about building a nightly refresh environment and the benefits of automating the process, and Dan talks about upgrading to PeopleSoft 9.2.

Show Notes

  • 9.2 Go-Live @ 1:45
  • Oracle MERGE command @ 13:30
  • Sandbox Refreshes @ 17:30


psadmin.io Themes for PeopleTools 8.59

We are releasing our newest version of our Themes for PeopleSoft 8.59 (and 8.58). We use these stylesheets on our non-production environments so that users can easily recognize which environment they are in, and most important, know they aren’t in production.

The Themes are released as an Application Data Set that you can easiliy import into your applications. The ADS project includes stylesheets and Branding Themes.

Importing Themes

Download the new themes from the Github respository. Under the Releases, you can download the lastest IO_STYLE_859.zip release. Unpack the zip file to your Data Migration File Location.

You use the Data Migration Workbench’s “Load Project From File” feature to import the themes and stylesheets.

Assigning Themes

To set the main theme for your system,

  1. Navigate to PeopleTools > Portal > Branding > Branding System Options
  2. Select the IO_ theme of your choice.
  3. You will also need to add a stylesheet for Classic Plus. Add the cooresponding IO_<color>_859_PTCP_SS as an additional stylesheet.

  1. If you have set Theme Assignments, you can update those as well under PeopleTools > Portal > Branding > Assign Branding Themes

SQL for Refreshes

Typically, the IO_STYLE_859 is load into production but not used. During your refresh, you can use the following SQL to configure your new environment to use a theme.

UPDATE sysadm.psoptions
SET
    ptbrandtheme = 'IO_GREEN_859_THEME',
    themestyletype = 'PTCP';

TRUNCATE TABLE sysadm.psoptionsaddl;

INSERT INTO sysadm.psoptionsaddl 
VALUES (
    'C',
    'CSS',
    'IO_GREEN_859_PTCP_SS',
    0
);

Colors

If you are just starting these stylesheets for your non-production environments, here is a suggestion for how to color code environments. This is how I use the colors:

Environment Color
Development 1 Green
Development 2 Teal
Development 3 Blue
Test Red
UAT/QA Grey
Sandbox Brown
Project 1 Purple
Project 2 Pink
Project 3 Yellow

I used https://colordesigner.io/ to help build the color schemes.

Orange

Primary Dark Light Accent
#FF8100 #FF5100 #FFAA00 #004757

Red

Primary Dark Light Accent
#94090D #5C0002 #D40D12 #1dfff9

Green

Primary Dark Light Accent
#097609 #075807 #70AF1A #591aaf

Purple

Primary Dark Light Accent
#553285 #36175E #9768D1 #a2d168

Blue

Primary Dark Light Accent
#0074D9 #00448D #7ABAF2 #f2b27a

Teal

Primary Dark Light Accent
#009798 #227273 #9DF3F4 #f49e9d

Yellow

Primary Dark Light Accent
#CCCC04 #8d8d03 #FFFF52 #5252ff

Brown

Primary Dark Light Accent
#A36F44 #6B4732 #F7DEB2 #b2cbf7

Pink

Primary Dark Light Accent
#AA3366 #552233 #CC5599 #55cc88

Grey

Primary Dark Light Accent
#707070 #3B3B3B #BABABA #FD7400

#290 – SameSite Cookies

This week on the podcast, Dan and Kyle talk about SameSite cookies and how the changes in browsers will affect PeopleSoft cookies, and they also discuss auditing PeopleSoft Security tables.

Show Notes


#286 – Database Triggers

This week on the podcast, Kyle wrestles with Windows and Linux services, and Dan spends time with database triggers and asks if they can become managed PeopleTools objects.

Show Notes


#277 – Monitoring Tool


This week on the podcast, Dan discusses some issues with installing VisualCOBOL, Kyle and Dan talk about paying for software and a PeopleSoft Monitoring Tool that is based on Queries.

Show Notes

#275 – Puppet Lookup


This week on the podcast, Kyle and Dan announce psadmin.conf 2021, they discuss environment naming conventions, and Dan follows up on the Puppet lookup options from last week.

Show Notes

#271 – Domain Connect Password


This week on the podcast, Dan and Kyle share some updates to psadmin_plus and a DPK module, how report posting works and some thoughts on handling large reports, and Dan shares why you should be using the Domain Connect password in your domains.

We apologize for the audio this week.

Show Notes

#262 – Cloud Manager Backups


This week on the podcast, Kyle learns how the Cloud Manager repository download and tracks files, and Dan shares how he configured backups for Cloud Manager in OCI.

Show Notes

#184 – nVision Performance



This week on the podcast, David Kurtz joins us again to talk about nVision and how to improve the performance of nVision reports. David also shared his thoughts on Oracle’s Autonomous Databases and some tips on how to resolve invalid views.

Show Notes

nVision Performance Tuning @ 1:30 Difference between OpenXML and Excel for nVision @ 21:30 Thoughts on Autonomous Database and Warehouse @ 29:00 Invalid Views @ 37:00