Friday, January 27, 2017

Campus Solutions 9.0 January 2017 Bundle #44 is now available.



Campus Solutions 9.0 January 2017 Bundle #44 is now available.

Where to learn more
Functional documentation is available for Campus Solutions Bundles on My Oracle Support PeopleSoft Campus Solutions 9.0Documentation - Bundles, Feature Packs, Additional Features, and Other Releases(Doc ID 2047464.1).  Select the link for CS 9.0 Bundle #44 Functional Documentation.

For information about the latest updates to PeopleBooks you can refer to Most Recent Versions of Campus Solutions 9.0 Chapters (DocID 1523915.1)

Current Adviser Webcasts Schedule and Archived Downloads can be found by going to My Oracle Support, PeopleSoft Enterprise Adviser Webcast Schedule and Archived recordings (Doc ID 1456265.1).  The webcast related to this bundle is: Financial Aid Regulatory 2017-2018 Release 3 (9.0 Bundle 44, 9.2 PUM Image 4)

Thursday, January 12, 2017

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)

Tuesday, January 10, 2017

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;

Monday, January 9, 2017

PeopleSoft Talk: Fluid Approvals and Page Composer

Page composer is one of the most anticipated of PeopleTools functionality with a rich drag and drop feature to make your own fluid presentation layer via easy configuration.

Fluid Approval is the first component that is using the Page Composer functionality and it soon replaces MAP technology.