Editor's Note 
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.
New TRAG members
Everybody, please welcome Suman Deekonda, Mishelle Denton and Rajani Madeti to the TRAG, and to our listserv!
International Virtual Week Success 
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 
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 support@alliance-conference.com.
Recent Webinars & Discussions 
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 
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 
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 
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?
Answers:
- 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 @ https://docs.oracle.com/cd/E41509_01/pt852pbh2/eng/psbooks/tpvg/chapter.htm?File=tpvg/htm/tpvg04.htm
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: https://support.oracle.com/epmos/faces/DocumentDisplay?id=2293687.1
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.
Answers:
- 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.
https://cve.circl.lu/cve/CVE-2020-14882
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: https://www.oracle.com/security-alerts/alert-cve-2020-14750.html?source=:em:gbc:ie:cpo:RC_SPPT201008P00126:SEV400103856&elq_mid=177393&sh=220918241612151514261313311501050403&cmid=SPPT201008P00126
Without any compensating controls/mitigation, your systems may be at risk and should be patched as quickly as possible.