New Encryption Algorithm Impacts PeopleTools Connectivity

I stumbled onto this little piece of info while researching an unrelated connectivity problem.  Oracle changed an encryption algorithm they use (for at least Access Id/Password) a few months back.  This change went in with PeopleTools 8.52.24, 8.53.17, and 8.54.04.  Most places I’ve been have always kept their PeopleTools clients at the same level as the Tools release in the PeopleSoft Database.  But I have seen on more than a few occasions, either certain users lag behind or the updated client is not pushed to developers.  This happens sometime for those doing minor release updates. When going from a level lower than the three listed above to a level equal or higher than listed, clients will no longer be able to connect.  They will be greeted with an Invalid User ID and password error.

Building out a new HCM 9.2 Update Image 9 DEMO

As mentioned here an updated version of  the PeopleSoft HCM media was released in late 2014.  I’ve done a few Demo installs of this on both Linux and Windows now, and here are my notes from a Linux install.  As in the past, these are rough notes I take when I do any install and not a how-to guide.  This install requires PeopleTools 8.54.03 patch as that is the level of PeopleTools within the database.  The media available on Oracle Software Delivery Cloud is only 8.54.00.  This install includes all PeopleSoft HCM patches through Update Image 9, a great thing for those using it to upgrade. Continue reading

SSL and Weblogic

As previously mentioned, I was doing an analysis of how PeopleSoft and Weblogic utilize SSL which was spawned by the announcement of POODLE.  I’m going to review my findings for Weblogic 10.3.6.x and then duplicate the analysis to see if anything is changed with Weblogic 12.1.2.  Weblogic 10.3.6.x is supported for any PeopleTools 8.50 – 8.53 installations.  If you are on an older release of Weblogic 10.3 you should upgrade your Weblogic. Continue reading

Remastered 9.2 Application media

Some of you may have noticed this already but I recently saw that some of the PeopleSoft 9.2 Application media had been remastered.

  • HCM 9.2 was updated on E-delivery at the end of October.  It includes patches from Update Image 9.  Image 9 was also released as a certified Upgrade Demo Image.
  • FSCM 9.2 was updated at the end of September.  It includes patches from Update Image 5 which also released as a certified Upgrade Demo Image.
  • ELM 9.2 was updated in early October and contains patches from Update Image 6.  As with the others it also is a certified upgrade image.
  • CRM 9.2 looks updated at the end of September as well, but it does not indicate if any patches from an Update Image are included.  Since there is not currently a supported Upgrade Image other than CRM 9.2.000 it would not make sense that this media include the patches.  This may indicate it was updated because PeopleTools 8.53 was pulled and 8.54 added to the collection.  I have not downloaded it to look.

In addition the other change I noticed was that all PeopleTools 8.53 media has been pulled.  If you need something from the 8.53 media set you will need to open a non-tech SR.  This seems to be a change from the previous strategy of keeping the current plus one previous Tools set available for download.  I’m not on E-delivery all that often so who knows, maybe they changed that a while ago.

Either way, those looking to start upgrades or may have recently started the process using media they downloaded prior to end of September should evaluate where they are and possibly grab this new media.  Jumping straight to a Update Image would be beneficial.  Those looking to avoid PeopleTools 8.54 for some reason may want to avoid these though because at least HCM, FSCM, and ELM will already be 8.54 PeopleTools in the database.

8.54 PUM Images Released

Oracle released the HCM 9.2.008 PUM Image today, Aug 19th.  The ELM 9.2.005 PUM Image came out last week on Aug 12th.  Finance should be out next week.  These images are supposed to be delivered on the new 8.54.01 PeopleTools release.  These should be an easy way for Admins like ourselves or Oracle customers in general to kick the tires on some of the new PeopleTools features and middleware components.  You need to download them anyhow for patching right?

HCM weighs in at 34.7 GB while ELM is 28.4 GB.  Happy downloading.

8.54 PreRelease Notes Available

The PeopleSoft Technology Blog has announced the availability of the PreRelease notes for 8.54:

Some observations as I skimmed the document are:

  • Oracle Linux 6, Win 2012, and Win 2012 R2 support added, Win 2008 (R1 not R2) dropped
  • Client OS Windows 8.1 added, Windows 7 (32 bit) dropped
  • WebLogic 12.1.2 added, 10.3.6 dropped
  • Oracle 12, MSSQL 2014 added, Oracle 10.2.0.5, 11.2.0.3, and MSSQL 2008 dropped
  • Current browsers available added (Chrome, Firefox, IE 11, Safari), IE 8 Firefox 17 dropped
  • Tuxedo 12.1.1.0 added, Tuxedo 11gR1 dropped
  • Still uses Java 7
  • SES is 11.2.2.2, SES 11.1.2.2 dropped
  • Excel 32-bit dropped
  • New Fluid User Interface: moves away from ridge page layouts enhancing the use of CSS3, HTML5, and JavaScript.  Supposed to “scale gracefully between devices”.  Fluid page definitions are maintained within App Designer.  Adds Fluid Homepages, Tiles, Notification Framework, PeopleSoft Navigation Bar
  • Mobile Application Platform: Similar to the Fluid User Interface but utilizes RESTful web services
  • 64-bit Development environment!  App Designer, Data Mover, Change Assistant, the whole lot of them all now 64-bit.  Explains the dropped Win 7 (32-bit).
  • App Designer will have improved search functionality (reference, text), code auto-completion for PeopleCode, and new toolbar buttons to improve productivity
  • Enhancements to App Engine tracing: split files, naming convention, program section trace, combined output of PeopleCode and SQL into the AE trace file
  • Portable PS_HOME: Hard-coded paths and sym links within PS_HOME have been removed to further consolidate and allow a single PS_HOME to be shared across multiple environments
  • Two new metaSQL enhancements for Oracle added.  %SqlHint and %SelectDummyTable
  • Also you can now use Oracle Global Temporary Tables, Materialized Views, and the new 12c container/pluggable databases which allow multiple PS databases in the same instance, some may have used GTTs and Materialized Views in the past, but now App Designer will handle them.  Also, App Designer can now be used directly to partition tables and indexes on Oracle.
  • Domain caching changes allowing automatic monitoring and adjusting?  I’ll have to look into that one more.
  • A Push Notification Event Framework, maybe we can finally broadcast a message to all users via the system.
  • Several security enhancements, Oracle Secure Files for the report repository is one that jumped out at me.
  • There’s a lot of other stuff, Just go read it !

Read the foll post here, or find the notes directly on MOS here

nVision going to Error

I ran into this problem with nVision a little while ago.  nVision processes were going to error status on the process scheduler.  A quick glance at the logs made it look like either the process was crashing or not starting at all.  I logged into the Windows Process Scheduler server to take a look at Excel.  Logging in as the service account that is used to run our process scheduler I looked at task manager and saw two copies of Excel which had been running, however no jobs had been run for quite a while.  I killed the processes and tried to start Excel by hand and began to wait.  Several minutes later Excel popped up a window stating it was starting in safe mode, probably because I killed the processes I assumed.  Once it started I went ahead and closed it cleanly and tried again.  Again about four minutes later it finally opened.  However, this time it opened with the recover lost files pane open and displayed what I would estimate was 1500+ recovered files.  I closed the pane not saving any and removing them which took some more time.  Eventually I was able to shutdown Excel again.  The next time I opened it, it started right up in a second.  I proceeded to disable the AutoRecover feature in the Save settings in Excel Options (for 2007).

I’m not sure what caused them to show up, or if they were there all along and just finally got to the point where Excel took too long to open. Like many, I inherited this environment, but now I have one more thing to add to my environment assessment checklist for the next time.

PeopleSoft Test Framework: Process.Run

The Basics:

Process.Run is a great feature of the PeopleSoft Test Framework.  Using this option wraps the running of a process up into just a few easy steps making the test script a lot easier to maintain.  In this post I use a Object Type dot Action notation which corresponds to how a step would be entered in PTF.  Before the period is the Type field, after is the Action field.  I’ve previously written a post on PTF installation and how to record a simple script, if you need to start from the very beginning.

PTF notation
Pseudo code to run a job looks like this: Continue reading

Oracle posts SES install tips

I’ve been really busy lately and have not been able to find the time to finish up my troubleshooting post on SES yet.  Hopefully I’ll have more time for writing posts again in a few weeks.  I did want to bring attention though to a post I noticed a few weeks ago on the PeopleSoft Technology Blog.   It speaks to the platform support of SES 11.1.2.2, the future support of SES 11.2.2.2 for PeopleTools 8.53, and also provides additional good reasons to keep your SES installs on separate hardware/vm’s than your existing PeopleSoft infrastructure.

Read the full blog post here.