PeopleSoft Campus Solutions 9.2 Re-certified Upgrade With Image 3 Now Available

Oracle’s PeopleSoft applications have evolved over time. Oracle’s commitment to our customers, the PeopleSoft suite of applications, and creating best-in-class products remains steadfast. First released in 12/2015, Campus Solutions 9.2 provides expanded functionality, usability, and reduced cost of ownership. In order to provide our global customer base with sustained upgrade support, Oracle plans to re-certify the PeopleSoft Campus Solutions 9.0 to 9.2 Upgrade in January 2017. At that time, we plan to release the PeopleSoft Campus Solutions 9.2 Upgrade Source image CS 9.2.001 containing up to and including Update Image 3. Campus Solutions 9.2 re-certified upgrades are targeted to be delivered once each calendar year. Please refer to the details below for further important information.

My Oracle Support (MOS) PeopleSoft Campus Solutions Upgrade Home Page (Doc ID 2078564.2)

Location of the Campus Solutions Upgrade Source Image:
Campus Solutions Upgrade Source Image CS 9.2.001 will be available at PeopleSoft Upgrade Source Images Home Page (Doc ID 1552580.1), Campus Solutions Upgrade Source Images link.
Information on obtaining the upgrade templates and upgrade documentation can be found on PeopleSoft Campus Solutions Upgrade Home Page (Doc ID 2078564.2).

Minimum Requirements for Upgrading:
Customers using Campus Solutions Upgrade Source Image 9.2.001 will need to be on minimum Campus Solutions 9.0, Bundle #34, HRMS Bundle #25 and PeopleTools 8.54 or higher before commencing their upgrade. In addition, customers must also have completed the Campus Solutions/HCM split prior to upgrading.

Maintenance Equivalency After Upgrade:
Upgrading to Campus Solutions 9.2 using upgrade image 9.2.001 will take customers to the equivalent of Campus Solutions 9.2 PUM Image 3 (CS 9.2.003).  Campus Solutions 9.2 PUM Image 3 is equivalent to Campus Solutions 9.0 Bundle #43.

Multi-Language Capability:
The CS 9.2.001 Upgrade Source Image will include Translations for:
Arabic, Spanish, English - UK, French, French - Canadian, Korean, Turkish, Dutch, Portuguese - Brazil, Simplified Chinese, and Traditional Chinese.

New Customers for Campus Solutions 9.2:
New Campus Solutions 9.2 customers on PeopleTools 8.55 must use the Campus Solutions VCD (virtual CD) available on edelivery.oracle.com. Select Release: PeopleSoft Campus Solutions 9.2, and the appropriate platform.

Important: Do NOT select the PeopleSoft Campus Solutions 9.2 Update Image on edelivery.oracle.com. The new install source will be denoted by PeopleSoft Campus Solutions 9.2.0.1.0. An update image, or PUM image, on edelivery.oracle.com will be denoted by ‘PeopleSoft Campus Solutions Update Image x (9.2.0.x.0)

SQL Queries To Run A List of Bugs + Pre-Reqs Included in PUM Image

Below are queries that I wrote so I can get a list of bugs contained in PUM image and find out if there are any pre-req bugs associated with one particular bug.

Note: these queries are written in Oracle database, so they may need to be modified to make it work with others.

/* How to get all the bugs and if any pre-req exists included in certain PI */
Select H.ptiasprptno as Bug_ID, H.ptiaspspvers as PI_Release, H.ptiasprptsubject as Subject, P.ptiaspprdname as Product_Name, P.ptiaspprdgrpcd as Product_Group,
       Case NVL(PR.ptiasprptnopost, 0) when 0 then 'N' else 'Y' End as PreReq_Exists
From PS_PTIASPRPTHEAD H
   , PS_PTIASPPRD P
   , (Select distinct ptiasprptnopost
      From PS_PTIASPRPTRQPOVW
      ) PR
Where H.ptiaspspvers = '{Enter PI number e.g. 18}'
  --And H.ptiasprptno = '{Enter Bug Number}'
  And P.ptiaspprdid = H.ptiaspprdid
  And PR.ptiasprptnopost (+) = H.ptiasprptno;


Note: I included PreReq_Exists column on the first query, if 'Y' then plug the Bug_ID into the next query to get the pre-req(s) and what PI image


 /* How to get the pre-req(s) for certain bug */
Select PR.ptiasprptno as Bug_ID, H.ptiasprptsubject as Subject, P.ptiaspprdname as Product_Name, P.ptiaspprdgrpcd as Product_Group, H.ptiaspspvers as PI_Release
From PS_PTIASPRPTRQPOVW PR
   , PS_PTIASPPRD P
   , PS_PTIASPRPTHEAD H
Where PR.ptiasprptnopost = '{Enter Bug Number}'
  And H.ptiasprptno = PR.ptiasprptno
  And P.ptiaspprdid = H.ptiaspprdid;

Ah! That's where the SQL Developer pathname for java.exe is!

I keep forgetting where the java.exe located in my Oracle client, so I left myself a note here ;)

When opening a SQL Developer for the first time after the new client installed, you will get a prompt like this below:

The path is pretty simple, but if you have to install the Oracle client every once a while, finding the specific file can be frustrating.

Here it is:

C:\Oracle\client\product\12.1.0\client_1\jdk\bin\java.exe

Note: your Oracle home path may be different from mine above.