1) Install Database (SQL Server, Oracle)
2) Install PeopleTools
3) Install PeopleSoft Application in the same directory as above
4) Install Oracle Web Logic
5) Install tuxedo in the same directory as above
6) Install Application from setup\PsMpDbInstall
*** Below scripts change from version to version
7) Depending on Application Database Version install Non Unicode rel850.sql till the latest version. You will find this in peopletools\scripts directory.Please make sure you are executing these sql's against your database.
7a) Open PS_HOME\bin\client\winx86\pscfg.exe (configuration manager).
7b) Leave server name blank. in Database name : findev (or what ever database name you have used to create database), user id : VP1, connect id : people , connect password : peop1e and click OK.
8) start Data Mover by running PS_HOME\bin\client\winx86\psdmt.exe and login as VP1/VP1 and open storeddl.dms (leave RUN DDLMSS.DMS and Comment the other platform-specific scripts). Click Run button on the menu or cntl + R.
9) start Data Mover by running PS_HOME\bin\client\winx86\psdmt.exe.and login with ACCESS ID AND EXECUTE msgtlsupg.dms WHICH YOU CAN FIND IN peopletools\scripts DIRECTORY
10) Launch Application Designer and sign on to your database with a valid PeopleSoft user ID, which is VP1 /VP1.
11) Select Tools, Copy Project, From File.
12) In the resulting dialog box, change the import directory to PS_HOME\projects, select PPLTLS84CUR from the list of projects and click the Select button.
13) After the copy is complete, the copy PPLTLS84CURDEL from same location
14) Altering PeopleTools Tables
Launch Application Designer with a valid PeopleSoft user ID and sign on to the installed database.
2. Select File, Open.
3. Select Project, enter PPLTLS84CUR in the name dialog box, and click OK.
4. Select Build, Project.The Build dialog box appears:
5. Select Create Tables and Alter Tables in the Build Options region (Create Indexes and Create Trigger will automatically be selected).
6. Select Build script file in the Build Execute Options region.
7.Click Settings.The Build Settings dialog box appears.
8.Select the Scripts tab.
9. Select Write Alter comments to script.
10. Select the Alter tab and ensure that the Adds, Changes, Renames, and Deletes check boxes are selected in the Alter Any region.Drop column if data present should be selected in the Drop Column Options region, and Truncate data if field too short should be selected in the Change Column Length Options region.
Make sure that the option Alter by Table Rename is selected in the Alter Table Options region
11. Select the Create tab and ensure that the Skip table if it already exists, Recreate view if it already exists, and Recreate index only if modified options are selected.
12. Click OK. The Build dialog box reappears.
13. Click Build.
14. Click Close when the process is completed.
15. Run the generated SQL script in your platform-specific query tool to bring your database structure in sync with the PeopleSoft PeopleTools tables.
15) Invoke Data Mover by running PS_HOME\bin\client\winx86\psdmt.exe and login as ACCESSID
16) Depending on Application Database Version install ptxxxtls.dms till the latest version
17) Run the tlsupgnoncomp.dms Data Mover script in the PS_HOME\scripts directory
18) Close data mover and Open Data Mover using a valid PeopleSoft Operator ID, such as PS for HRMS or VP1
19) Run the msgtleng.dms Data Mover Script in the PS_HOME\scripts directory
20) Run the ptstreng.dms Data Mover script in the PS_HOME\scripts directory.
21) Run the storept.dms Data Mover script in the PS_HOME\src\cbl\base directory.
22) Run the ptdefnsec.dms Data Mover script in the PS_HOME\scripts directory
23) Please run this SQL against your database
INSERT INTO PSTBLSPCCAT VALUES ('APLARGE','findev','R','DMS',NULL);
24) Run the createvw.dms Data Mover script in the PS_HOME\scripts directory
