Installing Peoplesoft 9.2

Installing Peoplesoft 9.2 on PeopleTools 8.54

(0) Install Oracle 12c database .
(1) Install the Webserver Weblogic 12x (without creating a domain)
(2) Install the App server Tuxedo 12x
(3) Install the Peopletools 8.54
(4) Install the application (say 9.2 fscm)
(5) Create a financials database say FSCMDMO manually using the steps given in the installation guide. Set SGA_POOL_SIZE to the order of 2 Gig. Run the 7 Peoplesoft scripts like createdb.sql, utlspaces.sql , psadmin.sql, connect.sql etc as in the  installation guide using appropriate database userids.
(6) Run Data Mover using Accesss Id (SYSADM) and click Database setup . If installing multi language setup, select all the languages and run Peoplesoft FSCM database setup . Automatically dms script will be created . Run that script .
(7) Check the database release by querying the table PSOPTIONS for field TOOLSREL. If the TOOLSREL is 8.53, we may have to run the additional scripts like rel854.sql script . Run other scripts as in the installation guide like pt854tls.sql and pt854xxx.sql for multi-language scripts as mentioned in
     the installation guide.
(8) Copy PeopleTools projects like PPLTLS84CUR, PPLTLSML, PPLTLS84CURML , PPLTBLSPC as mentioned in the installation guide and run Alter Audit scripts to sync database structures with Peopletools definitions
(9) Create App Server domain by going into psadmin utility . Set domain connectivity password without fail
(10)Install PIA which will create a domain in webserver and a site. Go and set properties for Webserver. Set PTWEBSERVER password . Ensure it is encrypted properly . Give the app server password same as the domain connectivity password mentioned above  .
(11)Start App Server domain. Check App Designer connectivity using App-Server-name:WSL port number.
(12) Start the webserver domain and connect through PIA .

You are all set.

Comments

Post a Comment

Popular posts from this blog

Component Interface Example

Component Interface Example This is an example of a CI code written in AE program for a CI with 2 scroll levels. =========================================================== Local ApiObject &MYSESSION; Local ApiObject &MYCI; &MYSESSION = %Session; &MYCI = &MYSESSION.GetCompIntfc(CompIntfc.STUDENT_CI); &MYCI.STUDENT_ID = "213"; rem &MYCI.STUDENT_NAME = "fald"; If Not &MYCI.get() Then    &MYCI.Create(); End-If; &MYCI.STUDENT_NAME = "fald,robert jam"; &MYLEVEL1 = &MYCI.STUDENT_COU; For &I = 1 To &MYLEVEL1.Count    &ITEM = &MYLEVEL1.Item(&I);    &ITEM.COURSE = "ORACLE";       &MYLEVEL2 = &ITEM.STUD_ADDR;    &COUNT = &MYLEVEL2.Count;       For &J = 1 To &COUNT       &LVL2ITEM = &MYLEVEL2.Item(&J);    ...
Read more

ExcelToCI Example

Image
Introduction This document details the minimal details used by an Excel To CI template for loading Vendor Information into Peoplesoft Financials. Tables Populated The comment  "has rows" indicate the minimal set of tables that will be populated through the ExcelToCI interface. Excel To CI Template File Clone the ExcelToCI template file from the %PS_HOME%\excel folder .  Connect Information Tab Give Web server machine name something like  hostname.domainsuffix name as configured in the web server domain menu . Then give other details as per the example below . Template Tab This is the template tab that has details of the tables involved for which we are going to provide input.  There will be lot of fields but we will choose which fields we will provide input for. Data Input Tab This is the tab where we should do data entry  Staging &submission Click Submit button . After processing, the O...
Read more

PeopleSoft workflow

Image
Requirement To implement custom workflow to approve Course Addition in an Educational training centre. Approach Define the required components needed to create the workflow – The Rules, Roles, Routings and the Business Process Maps and code logic to route the worklist to the approver. Sl. No Test Scenario Expected Results 1 Create a course in the Courses page and try to approve the course with the role of “CENTRE CLERK” The page should not allow the user with the role of CENTRE CLERK to approve the course. The course should be forced to be saved in Pending Approval status 2 Navigate to the Course Approvals page as user with “CENTRE CLERK” role and try to approve the transaction. The page should not allow the user with the role of CENTRE CLERK to approve the course. The course should be forced to be saved in Pending Approval status 3 Navigate to the Course Approvals through clic...
Read more