The TRAG Quarterly Newsletter - November 2020

By Anna Kourouniotis posted 11-25-2020 07:13 AM


Editor's Note editor_note.png

With Fall about to make way for what is likely to prove a difficult Winter, many of us are looking at ways to keep on keeping on. This makes me think of the song by Curtis Mayfield, and specifically the lyrics:

"Continue to give, continue to live…

there's still a lot of faith and warmth and trust

When we keep on keeping on."


The TRAG, along with other advisory groups and dedicated HEUG members are doing just that. Now, on with our current news.

welcome.png New TRAG members

Everybody, please welcome Suman Deekonda, Mishelle Denton and Rajani Madeti to the TRAG, and to our listserv!

International Virtual Week Success images for newsletter.png

The first ever International Virtual Week (IVW) proved to be quite the success. With participation in Latin America, Canada, Australia & New Zealand, Asia, Europe, the Middle East, and Africa and almost 180 sessions and discussions, there was something for everyone. Here is what our Chairs had to say about their experience:


 “It was great to connect with the international HEUG community with the inaugural International Virtual Week conference in October. Though face-to-face conferences are fantastic for both collaboration and content, in the current climate where this isn’t possible, this conference gave us the next best thing. In addition, it gave us the opportunity to experience presentations and presenters from all over the world, and to share experiences through Birds of a Feather sessions and Kick-off Coffees with participants across the globe.”

- Nikki Gaertner Eaton


“The international week has been a large success and allowed HEUG members to connect with peers and colleagues around the world. Beyond the great content presented during the week, connecting and networking with our international colleagues and exchanging ideas and experiences has been an incredible experience. “

- Longin Gogu

Virtual Alliance 2021 March 15-18, 2021 virtual_alliance.png

Work toward the second virtual Alliance has been underway since August as far as the Track Chair is concerned. Sessions were submitted and approved, tasks assigned, coffee and snacks restocked, sleeves rolled up and ready for a whole lot of work to make this Alliance just as fine as the first, if not better! Look out soon for details in your inbox. Registration is now OPEN! There will be 300+ sessions with live presenter Q&A. If you want to support Alliance, please email

Recent Webinars & Discussions webinars.png

Technical and Reporting Community Cloud & Coffee Break

Kibana Analytics and PeopleSoft Reporting

Leverage File Parser to Import and Update Constituent, Application and Test Score Data (Part 1)

Understanding Pivot Grids (Finally!)

Getting started with PeopleSoft Chatbots 

Recent Blog Articles articles.png

Rebuilt October PeopleTools 8.58 Infrastructure Deployment Package (IDPK) (Oracle blog)

Reporting Console - (Almost) Everything in One Place

Did You Know About PS Reporting Console?

Did You Know? Scatter Plot Graph in Tableau - October 2020

Did You Know? Combined Axis Chart in Tableau - September 2020

PeopleSoft Tree Flattener

PeopleSoft Cloud Manager Spotlight Series images for newsletter(1).png

Do you need help with your Cloud Manager implementation or simply want to learn about the latest updates? We recommend watching the videos on the PeopleSoft Cloud Manager Spotlight Series.

Hottest Topics on the Listservs hot_topics.png

Student Portal 'Null' Error

Posted by: Kimberly Comeau, Manager, Student Information Systems, St. Petersburg College

and Sharon Bobowski, Manager - Student Systems Programming, St. Petersburg College

Students receiving a ‘Null’ error when clicking on their Academic progress Summary Title in the Chrome browser

Issue was reported by other schools as well and suggestions for fixes were proposed. Oracle provided a POC for PeopleTools 8.56.15 and higher


Popular Version Control Tools / Change Management Tools?

Posted by: Afjal Khan Pathan, Peoplesoft System Administrator, PeopleSoft Admin for Student Information System at Northcentral Technical College

What are the most popular version control tools/change management tools available for PeopleSoft?


  • Phire   (UW-Stout, Arizona State University, University of Pittsburgh, Northwestern University)
  • CAPI    (UNC Chapel Hill)
  • Quest STAT  (University of Minnesota, Boise State, NC State)


Pivot Grid doesn't seem to work with query distinct or pivot grid count distinct

Posted By: Ivy Brent, Lead Report Developer at Washington State Board for Community and Technical Colleges

Pivot grids do not work properly if the underlying SQL directly uses UNION – multiple duplicate rows are being created. To avoid multiple duplicate rows creation a new view on top of the view with union statements may be created so that the view used in the pivot grid does not have any unions. Pivot grid limitations can be checked out in the peoplebooks @


UPK and Flash Support

Posted By: Devesh Yadav, Senior Manager at Princeton University

How are you accounting for the end of Flash Support and continued usage of UPK?

Please review the following MOS document: Oracle Support Document 2293687.1 (UPK: Is there a Replacement For Adobe Flash?) can be found at:


API Solutions

Posted By: Gilbert Milone, UConn to CoreCT Technical Lead/Liason at University of Connecticut

Tools used for AI management between PS and other systems.


  • Informatica – UNC Chapel Hill
  • Dell Boomi – University of Virginia
  • Mulesoft (Mule 4) – MSU, ASU


Weblogic server version and Peopletools version

Posted By: Jigisha Thakkar, Peoplesoft HCM Technical Analyst at Columbia College, Chicago

Has anyone ever upgraded their weblogic server version to a more recent one than the one listed in the certifications for PSTools version?

One should be updating the fifth decimal place with PSU (Patch Set Updates) so they get the latest bug and security fixes alongside the Critical Patch Update (CPU) program.


Browse Course Catalog (9.2) and Elastic Search Problems in PeopleTools 8.57

Posted By: Jay Meyer, Director Application Services at College of Lake County

Performance issues with elastic search for Browse Course Catalog search. Issue first arose in CS Image 14 environment with PeopleTools 8.57.09.

Potential resolution – allocate more memory to elastic on the server


Dashboard design - let's get the conversation started!

Posted By: Anna Kourouniotis, Database Analyst II at Duke University

For those of you who are transforming dull data into beautiful and insightful dashboards – whether in Oracle Analytics, Kibana, Microsoft Power BI, Tableau or any other tool – I want to know what drives your dashboard designs.

Great discussions and a good book to read suggestion: The Big Book of Dashboards by Shaffer, Wexler, and Cotgreave


October 2020 CPU - Pre-release Announcement is out

Posted By: Mayank Mittal, Senior Peoplesoft Systems Administrator at University of Colorado

You might want to pay particular attention to the following CVE that’s addressed in this CPU.

Please note that there is another update concerning these critical CVE’s.  Oracle has released a one-off patch for CVE-2020-14750, which is related to CVE-2020-14882.  They can be exploited WITHOUT AUTHENTICATION (i.e. without the need for any userid or password) 

Please see: 

Without any compensating controls/mitigation, your systems may be at risk and should be patched as quickly as possible.