Saturday, April 19, 2014

SUI for PeopleSoft Campus Solutions Part 2




In previous post, I described all sources that you need to download to enable SUI for PeopleSoft Campus Solutions. In this post we will install all required sources.



SUI Patch for PeopleSoft

The Simplified UI is delivered as a ordinary patch for PeopleSoft that you apply using Change Assistant. As a prerequisite, the SUI patch requires at least CS9 Bundle #32, which is currently the highest bundle level.

Below are the minimum requirements for your PeopleSoft Campus patch level:
Patch 13813089: PT 8.52.07 PRODUCT PATCH
Patch 17234625: Simplified Campus Experience Templates (SCET)
Patch 17641903: CS 9 BUNDLE #32


JDK 7

In order to install Weblogic, we first need to install JDK. Start the JDK installer and pay attention to the install path, we will be needing path a lot in upcoming steps.


Weblogic 10.3.6

To install Weblogic execute the following command

SET JAVA_HOME=C:\apps\SUI\Java\jdk1.7.0_51
%JAVA_HOME%\bin\java -jar wls1036_generic.jar -log=logs\Wls1036Install.log




When you installed Weblogic, leave the Run Quickstart checkbox on to create a new domain that will host SUI.


Choose option Getting started with Weblogic Server 10.3.6.


Choose the option Create a new Weblogic Domain



Supply a name for your domain


Provide Weblogic administrator credentials



On the select Optional Configuration screen, leave all check boxen unchecked.



Application Development Framework 11.1.1.7

Now that Weblogic is installed, we need to install the ADF Runtime extension on top of the weblogic domain.
To start the installer execute the following command:

setup.exe -jreloc C:\apps\SUI\Java\jdk1.7.0_51

Provide the directory where you installed Weblogic.



After the installer has finished, run the Quickstart wizard again.


This time choose the option to extend the domain.


Select your domain


Select the options to extend the domain:
Oracle Enterprise Manager
Oracle JRF


Patching ADF to 11.1.1.7.1

The SUI template and libraries are actually part of ADF 11.1.1.7.1. In order for the SUI application to work, we need to patch ADF.

For the directory where you downloaded the ADF 11.1.1.7.1 patch execute the opatch command from from the Weblogic 10.3.6 path:

E:\Campus90\SUI\16964825>C:\apps\SUI\oracle\Middleware\oracle_common\OPatch\opat
ch apply -jdk C:\apps\SUI\Java\jdk1.7.0_51
Oracle Interim Patch Installer version 11.1.0.9.9
Copyright (c) 2012, Oracle Corporation.  All rights reserved.


Oracle Home       : C:\apps\SUI\oracle\MIDDLE~1\ORACLE~1
Central Inventory : C:\Program Files\Oracle\Inventory
   from           : n/a
OPatch version    : 11.1.0.9.9
OUI version       : 11.1.0.9.0
Log file location : C:\apps\SUI\oracle\MIDDLE~1\ORACLE~1\cfgtoollogs\opatch\1696
4825_Apr_18_2014_21_05_00\apply2014-04-18_21-05-00PM_1.log


OPatch detects the Middleware Home as "C:\apps\SUI\oracle\Middleware"

Applying interim patch '16964825' to OH 'C:\apps\SUI\oracle\MIDDLE~1\ORACLE~1'
Verifying environment and performing prerequisite checks...
All checks passed.

Please shutdown Oracle instances running out of this ORACLE_HOME on the local sy
stem.
(Oracle Home = 'C:\apps\SUI\oracle\MIDDLE~1\ORACLE~1')


Is the local system ready for patching? [y|n]
User Responded with: Y
Backing up files...

Patching component oracle.jrf.adfrt, 11.1.1.7.0...

Verifying the update...
Patch 16964825 successfully applied
Log file location: C:\apps\SUI\oracle\MIDDLE~1\ORACLE~1\cfgtoollogs\opatch\16964
825_Apr_18_2014_21_05_00\apply2014-04-18_21-05-00PM_1.log

OPatch succeeded.

After this start the Weblogic server.

C:\apps\SUI\oracle\Middleware\user_projects\domains\sui_domain\bin\startWebLogic.cmd

JDBC Datasource

Start Weblogic console using http://localhost:7001/console and on the left pane choose Data Source and choose to create a new Generic JDBC datasource.


The name of the datasource needs to be sseDS. It is not optional to choose another name.



Supply the database connectivity credentials to your PeopleSoft database.


Click on the Test Configuration to check if database connectivity is setup properly in Weblogic.


Choose AdminServer as a Target or if you have setup a managed server, choose that one.

After the Datasource creation, select it, to modify some of the default configuration.
On the Transaction tab, select to option Set XA Transaction Timeout.


Change the default Maximum Capacity from 15 to a more desired amount.


Ant & Repackage EAR

Before we can deploy the SUI application, we need to configure the SUI application to point to our PeopleSoft environment. The application is deployed by the Change Assistant to PS_HOME\setup\oracle\adf\sce as upd905266_01.zip. Unzip this file and from the unzipped folder go to directory CS_SCE\deploy\core\config. Open file sce_config.properties and modify the following line to reflect your PeopleSoft environment.

SCE_WS_HOST_URL=http://cam90.ps.com/PSIGW/PeopleSoftServiceListeningConnector/

In order for the change to be applied, we need to repackage the EAR file. For this we will use ant that we downloaded before. The download for ant come as a zip file. Unzip the ant download file to any directory. I unzipped it to C:\apps\SUI\Java\apache-ant-1.9.3.

Before we repackage the application, we first need to execute the following command to download all required dependenties for ant:

SET ANT_HOME=C:\apps\SUI\Java\apache-ant-1.9.3
SET JAVA_HOME=C:\apps\SUI\Java\jdk1.7.0_51
SET PATH=%PATH%;%ANT_HOME%\bin

C:\apps\SUI\Java\apache-ant-1.9.3>ant -f fetch.xml -Ddest=system  
Now execute the following command to repackage the application.

SET ANT_HOME=C:\apps\SUI\Java\apache-ant-1.9.3
SET JAVA_HOME=C:\apps\SUI\Java\jdk1.7.0_51
SET PATH=%PATH%;%ANT_HOME%\bin

C:\apps\SUI\Java\apache-ant-1.9.3>ant repackageSCE -f C:\apps\psoft\pt\setup\oracle\adf\sce\CS_SCE\util\build.xml

Output will be something like this:

Buildfile: C:\apps\psoft\pt\setup\oracle\adf\sce\CS_SCE\util\build.xml

unpackageSCE:
     [echo] Unpack the current SCE ear file.
    [unzip] Expanding: C:\apps\psoft\pt\setup\oracle\adf\sce\CS_SCE\deploy\core\
CsSce.ear into C:\apps\psoft\pt\setup\oracle\adf\sce\CS_SCE\deploy\core\CsSce
    [unzip] Expanding: C:\apps\psoft\pt\setup\oracle\adf\sce\CS_SCE\deploy\core\
CsSce\CsSce.war into C:\apps\psoft\pt\setup\oracle\adf\sce\CS_SCE\deploy\core\Cs
Sce\CsSce
   [delete] Deleting: C:\apps\psoft\pt\setup\oracle\adf\sce\CS_SCE\deploy\core\C
sSce\CsSce.war

repackageSCE:
     [echo] Pack the SCE configure file...
    [mkdir] Created dir: C:\apps\psoft\pt\setup\oracle\adf\sce\CS_SCE\deploy\cor
e\config\utf8
[native2ascii] Converting 1 file from C:\apps\psoft\pt\setup\oracle\adf\sce\CS_S
CE\deploy\core\config to C:\apps\psoft\pt\setup\oracle\adf\sce\CS_SCE\deploy\cor
e\config\utf8
      [jar] Updating jar: C:\apps\psoft\pt\setup\oracle\adf\sce\CS_SCE\deploy\co
re\CsSce\CsSce\WEB-INF\lib\CsSuseCommon.jar
     [echo] Pack the SCE common jar with config file complete.
      [war] Building war: C:\apps\psoft\pt\setup\oracle\adf\sce\CS_SCE\deploy\co
re\CsSce\CsSce.war
   [delete] Deleting directory C:\apps\psoft\pt\setup\oracle\adf\sce\CS_SCE\depl
oy\core\CsSce\CsSce
   [delete] Deleting: C:\apps\psoft\pt\setup\oracle\adf\sce\CS_SCE\deploy\core\C
sSce.ear
      [ear] Building ear: C:\apps\psoft\pt\setup\oracle\adf\sce\CS_SCE\deploy\co
re\CsSce.ear
      [ear] Warning: selected ear files include a META-INF/application.xml which
 will be ignored (please use appxml attribute to ear task)
   [delete] Deleting directory C:\apps\psoft\pt\setup\oracle\adf\sce\CS_SCE\depl
oy\core\CsSce

BUILD SUCCESSFUL
Total time: 2 seconds

Deploy SUI

Now we are ready to deploy the SUI application
In the Weblogic console, from the left pane structure, choose Deployments and click on Install.


Provide the path to the repackaged EAR file.


Choose the option to have the deployment installed as an application.



Test Application

Open a browser and navigate to http://localhost:7001/CsSce


Do not try to sign in yet. We still need to enable web services on the PeopleSoft site and we need to setup security, which will be discussed in next blog post.


No comments:

Post a Comment