This is an attempt to list PeopleSoft meta-tables along with some kind of description for every table. The list will be broken into categories (pages, records, components, and so forth). Please feel free to add to or correct the list, this is a wiki page, so jump in!
PeopleSoft Projects
PSPROJECTDEFN table stores information about projects created in Application Designer.
Try it out:
SELECT * FROM PSPROJECTDEFN
WHERE PROJECTNAME = 'Your_Project_name';
PSPROJECTITEM table stores objects inserted into your Application Designer project.
Try it out:
SELECT * FROM PSPROJECTITEM
WHERE PROJECTNAME = 'Your_Project_name';
Portal Structure
PSPRSMDEFN is a Portal Structure Definition table. A good example is to use this table to find portal path for a specific component. Take a closer look on how this is done!.
PSPRSMPERM: Shows the permission lists that are assigned to a portal registry structure (content reference). The permission list name is under field PORTAL_PERMNAME.
XLAT Tables
XLATTABLE: Stores translate values (PeopleSoft version prior to 8.4).
PSXLATDEFN: Stores all fields that have Xlat values. This table does not store any Xlat values.
PSXLATITEM: Stores fields with their actual translate values (PeopleSoft version 8.4 and above).
Record & Field Tables
PSRECDEFN: Stores informations about tables. One row for each table. Field count and record type are two fields that are stored on this table.
CASE RECTYPE
WHEN 0 THEN 'Table'
WHEN 1 THEN 'View'
WHEN 2 THEN 'Derived'
WHEN 3 THEN 'Sub Record'
WHEN 5 THEN 'Dynamic View'
WHEN 6 THEN 'Query View'
WHEN 7 THEN 'Temporary Table'
ELSE TO_CHAR(RECTYPE)
END CASE
PSRECFIELD: Stores records with all their fields (sub-records are not expanded)
PSRECFIELDALL: Stores records with all their fields (sub-records are expanded)
PSINDEXDEFN: Contains 1 row per index defined for a table.
PSKEYDEFN: Containes 1 row per key field defined for an index.
PSDBFIELD: You got it, stores information about fields.
CASE FIELDTYPE
WHEN 0 THEN 'Character'
WHEN 1 THEN 'Long Character'
WHEN 2 THEN 'Number'
WHEN 3 THEN 'Signed Number'
WHEN 4 THEN 'Date'
WHEN 5 THEN 'Time'
WHEN 6 THEN 'DateTime'
WHEN 8 THEN 'Image'
WHEN 9 THEN 'Image Reference'
ELSE TO_CHAR(FIELDTYPE)
END CASE
PSDBFLDLABL: Stores field label information.
Process Definition Table(s)
PS_PRCSDEFNPNL: Stores the process definition name, process type(sqr report, application engine...), and the component name associated with the process definition.
PS_PRCSDEFN: Process definitions table. The record stores processes that can run within the Process Scheduler. Security information such as components and process groups are also stored on this table.
Message Catalog Tables
PSMSGCATDEFN: Stores information about PeopleSoft message catalogs such as message set number, message number and the actual message text.
PSMSGCATLANG: language table.
-- Example
SELECT * FROM PSMSGCATDEFN
WHERE LAST_UPDATE_DTTM > TO_DATE('03-DEC-07', 'DD-MON-YY')
AND LAST_UPDATE_DTTM < TO_DATE('05-DEC-07', 'DD-MON-YY')
ORDER BY MESSAGE_SET_NBR, MESSAGE_NBR;
-- This will return messages that has been last update/added between 2 specific dates.
Previous PeopleSoft message catalog tables:
PS_MESSAGE_CATALOG: Stores information about PeopleSoft message catalogs such as message set number, message number and the actual message text.
MESSAGE_SET_TBL: Message set description table.
-- Example
SELECT * FROM PS_MESSAGE_CATALOG
WHERE LAST_UPDATE_DTTM > TO_DATE('03-DEC-07', 'DD-MON-YY')
AND LAST_UPDATE_DTTM < TO_DATE('05-DEC-07', 'DD-MON-YY')
ORDER BY MESSAGE_SET_NBR, MESSAGE_NBR;
-- This will return messages that has been last update/added between 2 specific dates.
Menu Tables
PSMENUDEFN: Store Menu related information. No related component info on this table.
PSMENUITEM: List the menu with all components attached to it.
Component Tables
PSPNLGRPDEFN: Stores component related information only.
PSPNLGROUP: This table will give you information regarding a specific component along with the names of pages attached to it.
Pages
PSPNLDEFN: Stores pages definitions.
CASE PNLTYPE
WHEN 0 THEN 'Page'
WHEN 1 THEN 'Sub page'
WHEN 2 THEN 'Secondary page'
ELSE TO_CHAR(PNLTYPE)
END CASE
PSPNLFIELD: Stores all items used by each page definition.
CASE FIELDTYPE
WHEN 0 THEN 'Static Text'
WHEN 1 THEN 'Frame'
WHEN 2 THEN 'Group Box'
WHEN 3 THEN 'Statis Image'
WHEN 4 THEN 'Edit Box'
WHEN 5 THEN 'Dropdown List'
WHEN 6 THEN 'Long Edit Box'
WHEN 7 THEN 'Check Box'
WHEN 8 THEN 'Radio Button'
WHEN 9 THEN 'Image'
WHEN 10 THEN 'Scroll Bar'
WHEN 11 THEN 'Subpage'
WHEN 12 THEN 'Peoplecode Command - (Button/Hyperlink Destination)'
WHEN 13 THEN 'Scroll Action - (Button/Hyperlink Destination)'
WHEN 14 THEN 'Toolbar Action - (Button/Hyperlink Destination)'
WHEN 15 THEN 'External Link - (Button/Hyperlink Destination)'
WHEN 16 THEN 'Internal Link - (Button/Hyperlink Destination)'
WHEN 17 THEN 'Process - (Button/Hyperlink Destination)'
WHEN 18 THEN 'Secondary Page'
WHEN 19 THEN 'Grid'
WHEN 20 THEN 'Tree'
WHEN 21 THEN 'Secondary Page - (Button/Hyperlink Destination)'
WHEN 23 THEN 'Horizontal Rule'
WHEN 24 THEN 'Tab Separator'
WHEN 25 THEN 'Html Area'
WHEN 26 THEN 'Prompt Action - (Button/Hyperlink Destination)'
WHEN 27 THEN 'Scroll Area'
WHEN 29 THEN 'Page Anchor'
WHEN 30 THEN 'Chart'
WHEN 31 THEN 'Push Button/Link'
WHEN 32 THEN 'Analytic Grid'
ELSE TO_CHAR(FIELDTYPE)
END CASE
Security
PSPRSMPERM: Portal Structure Permissions.
PSAUTHITEM: Page Permissions. This table stores the information about the page level access for a permission list.
PSROLECLASS: Role Classes table. A many to many relationship table between Roles and Permission Lists.
PSROLEDEFN: This table stores information about Peoplesoft Role definitions. Users get permissions to PeopleSoft objects through Roles, which are assigned Permission Lists.
PSROLEUSER: This table stores information about the Users in Peoplesoft and the roles assigned to them.
PSCLASSDEFN: Permissions List definitions table. Permission list name can be found under Field Name CLASSID.
PSOPRDEFN: Users/Operator definition table. This table stores information about PeopleSoft users. This is the core table for User Profile Manager.
PSOPRCLS: Users/Operator and Perm list mapping Table. This table stores information about PeopleSoft users and the permission lists attached to those users.
A User gets these permission lists indirectly through the roles which are attached to the user
Here is an example query post that uses all of the above security tables!
URL Definitions
PSURLDEFN: Stores URL definitions. Here is the path to create URL definitions in PeopleSoft Root >> PeopleTools >> Utilities >> Administration >> URLs
Application Classes
PSAPPCLASSDEFN: Application Class Definitions table. You can use field PACKAGEROOT to search for a specific Application Package.
PeopleSoft Query Tables
PSQRYDEFN: Stores query related info.
PSQRYFIELD: Stores all fields used in a query (both the fields in the Select and Where clause).
PSQRYCRITERIA: Stores criteria query fields. You can get the name of the fields by joining the PSQRYFIELD table.
PSQRYEXPR: Stores query expressions.
PSQRYBIND: Stores query bind variables.
PSQRYRECORD: Stores all records used in all aspects of query creation
PSQRYSELECT: Stores all SELECT requirements by select type. Example would be sub select, join, ect.
PSQRYLINK: Stores the relationships to child queries.
PSQRYEXECLOG: Query run time log table that stores (only 8.4x and higher)
PSQRYSTATS: Query run time statistics table such as count of query execution, and date time of last execution (only in 8.4x and higher).
SQL Objects
PSSQLDEFN: Stores SQL object definitions.
PSSQLDESCR: Stores SQL objects descriptions, and description long.
PSSQLTEXTDEFN: Stores actual SQL text. You can filter by SQLTYPE field to get SQL objects of interest such as Views SQLs and Application Engine SQLs.
-- When SQL type is:
0 = Stand alone SQL objects
1 = Application engine SQL
2 = Views SQLs
Application Engines
PSAEAPPLDEFN: Table that stores Application Engine program definitions.
PSAEAPPLSTATE: Stores application engine STATE records and a flag to indicate if the record is the default STATE record.
PSAESECTDEFN: Application engine section information and also stores last user id to update a specific section.
PSAESECTDTLDEFN: AE section along with descriptions and wither the section is active or not.
PSAEAPPLTEMPTBL: If your application engine uses Temp tables it will show on this record.
PSAESTEPDEFN: Steps in application engines are stored in this table.
PSAESTMTDEFN: Stores your application engine actions and along with their types, such as "Do Select" and so on.
PSAESTEPMSGDEFN: Application engine message action definition table.
AEREQUESTTBL: Application Engine request table behind the AE run control page.
AEREQUESTPARM: Application Engine request parameters table behind the AE run control page.
PeopleCode Tables
PSPCMNAME: PeopleCode Reference table.
PSPCMPROG: Store actual PeopleCode programs (actual code behind PeopleCode events).
Process Request Tables
PSPRCSQUE: This record contains the process request information to run a process request.
PSPRCSRQST: This record contains the process request information to run a process request.
PS_PMN_PRCSLIST: A view to list all process requests in the Process Monitor except for "Delete" (runstatus = 2) process requests.
Other Useful Tables
PSSTATUS: Stores PeopleSoft information such as PS Tools release version and the UNICODE_ENABLED boolean flag where a value of 1 indicates the DB is to be treated by Tools as a UNICODE DB.
PSCHGCTLLOCK: Description as explained by PeopleSoft "This table contains a a row for every object that is currently locked by any user. When the user requests to lock an object in the Application Designer, first this table is searched to see if the object is locked by another user. If it is not found, a row is inserted into the table. When the user requests to unlock an object, the row in this table is deleted."
Visit this post to see how could you make use of this table.
PSMAPFIELD: Stores Field mapping of Activity
PS_PRCSRUNCNTL: Run Control record stores Run Control IDs created online.
Thursday, August 26, 2010
Tuesday, August 10, 2010
PUB/SUB services Bounce
Servername:/apps> cd hrprd
Servername:/apps/hrprd> . ./psconfig.sh
Servername:/apps/hrprd> cd appserv
Servername:/apps/hrprd/appserv> psadmin
PSADMIN -- Tools Release: 8.49.25
Copyright (c) 1988, 2003, Oracle. All rights reserved.
--------------------------------
PeopleSoft Server Administration
--------------------------------
1) Application Server
2) Process Scheduler
3) Search Server
q) Quit
Command to execute (1-3, q): 1
--------------------------------------------
PeopleSoft Application Server Administration
--------------------------------------------
1) Administer a domain
2) Create a domain
3) Delete a domain
4) Import domain configuration
q) Quit
Command to execute (1-4, q) : 1
Tuxedo domain list:
1) HRPRD
Select domain number to administer: 1
--------------------------------
PeopleSoft Domain Administration
--------------------------------
Domain Name: HRPRD
1) Boot this domain
2) Domain shutdown menu
3) Domain status menu
4) Configure this domain
5) TUXEDO command line (tmadmin)
6) Edit configuration/log files menu
7) Messaging Server Administration menu
8) Purge Cache
9) Preload File Cache
10) Clean IPC resources of this domain
q) Quit
Command to execute (1-10, q) : 5
Loading command line administration utility ...
tmadmin - Copyright (c) 1996-1999 BEA Systems, Inc.
Portions * Copyright 1986-1997 RSA Data Security, Inc.
All Rights Reserved.
Distributed under license by BEA Systems, Inc.
Tuxedo is a registered trademark.
> shutdown -g PUBSUB
Shutting down server processes ...
Server Id = 300 Group Id = PUBSUB Machine = Servername: shutdown succeed
ed
Server Id = 302 Group Id = PUBSUB Machine = Servername: shutdown succeed
ed
Server Id = 301 Group Id = PUBSUB Machine = Servername: shutdown succeed
ed
Server Id = 200 Group Id = PUBSUB Machine = Servername: shutdown succeed
ed
Server Id = 202 Group Id = PUBSUB Machine = Servername: shutdown succeed
ed
Server Id = 201 Group Id = PUBSUB Machine = Servername: shutdown succeed
ed
Server Id = 100 Group Id = PUBSUB Machine = Servername: shutdown succeed
ed
Server Id = 102 Group Id = PUBSUB Machine = Servername: shutdown succeed
ed
Server Id = 101 Group Id = PUBSUB Machine = Servername: shutdown succeed
ed
9 processes stopped.
> boot -g PUBSUB
INFO: BEA Tuxedo, Version 9.1, 64-bit, Patch Level 036
INFO: Serial #: 650522264137-2065448083901, Expiration NONE, Maxusers 1000000
INFO: Licensed to: Oracle-Peoplesoft-ISV
Booting server processes ...
exec PSBRKHND -p 1,600:1,1 -s PSBRKHND_dflt:BrkProcess -- -C psappsrv.cfg -D HRP
RD -S PSBRKHND_dflt :
process id=22564 ... Started.
exec PSBRKHND -p 1,600:1,1 -s PSBRKHND_dflt:BrkProcess -- -C psappsrv.cfg -D HRP
RD -S PSBRKHND_dflt :
process id=22569 ... Started.
exec PSBRKDSP -s PSBRKDSP_dflt:Dispatch -- -C psappsrv.cfg -D HRPRD -S PSBRKDSP_
dflt :
process id=22572 ... Started.
exec PSPUBHND -p 1,600:1,1 -s PSPUBHND_dflt:PubConProcess -- -C psappsrv.cfg -D
HRPRD -S PSPUBHND_dflt :
process id=22577 ... Started.
exec PSPUBHND -p 1,600:1,1 -s PSPUBHND_dflt:PubConProcess -- -C psappsrv.cfg -D
HRPRD -S PSPUBHND_dflt :
process id=22580 ... Started.
exec PSPUBDSP -s PSPUBDSP_dflt:Dispatch -- -C psappsrv.cfg -D HRPRD -S PSPUBDSP_
dflt :
process id=22583 ... Started.
exec PSSUBHND -p 1,600:1,1 -s PSSUBHND_dflt:SubConProcess -- -C psappsrv.cfg -D
HRPRD -S PSSUBHND_dflt :
process id=22590 ... Started.
exec PSSUBHND -p 1,600:1,1 -s PSSUBHND_dflt:SubConProcess -- -C psappsrv.cfg -D
HRPRD -S PSSUBHND_dflt :
process id=22593 ... Started.
exec PSSUBDSP -s PSSUBDSP_dflt:Dispatch -- -C psappsrv.cfg -D HRPRD -S PSSUBDSP_
dflt :
process id=22596 ... Started.
9 processes started.
Servername:/apps/hrprd> . ./psconfig.sh
Servername:/apps/hrprd> cd appserv
Servername:/apps/hrprd/appserv> psadmin
PSADMIN -- Tools Release: 8.49.25
Copyright (c) 1988, 2003, Oracle. All rights reserved.
--------------------------------
PeopleSoft Server Administration
--------------------------------
1) Application Server
2) Process Scheduler
3) Search Server
q) Quit
Command to execute (1-3, q): 1
--------------------------------------------
PeopleSoft Application Server Administration
--------------------------------------------
1) Administer a domain
2) Create a domain
3) Delete a domain
4) Import domain configuration
q) Quit
Command to execute (1-4, q) : 1
Tuxedo domain list:
1) HRPRD
Select domain number to administer: 1
--------------------------------
PeopleSoft Domain Administration
--------------------------------
Domain Name: HRPRD
1) Boot this domain
2) Domain shutdown menu
3) Domain status menu
4) Configure this domain
5) TUXEDO command line (tmadmin)
6) Edit configuration/log files menu
7) Messaging Server Administration menu
8) Purge Cache
9) Preload File Cache
10) Clean IPC resources of this domain
q) Quit
Command to execute (1-10, q) : 5
Loading command line administration utility ...
tmadmin - Copyright (c) 1996-1999 BEA Systems, Inc.
Portions * Copyright 1986-1997 RSA Data Security, Inc.
All Rights Reserved.
Distributed under license by BEA Systems, Inc.
Tuxedo is a registered trademark.
> shutdown -g PUBSUB
Shutting down server processes ...
Server Id = 300 Group Id = PUBSUB Machine = Servername: shutdown succeed
ed
Server Id = 302 Group Id = PUBSUB Machine = Servername: shutdown succeed
ed
Server Id = 301 Group Id = PUBSUB Machine = Servername: shutdown succeed
ed
Server Id = 200 Group Id = PUBSUB Machine = Servername: shutdown succeed
ed
Server Id = 202 Group Id = PUBSUB Machine = Servername: shutdown succeed
ed
Server Id = 201 Group Id = PUBSUB Machine = Servername: shutdown succeed
ed
Server Id = 100 Group Id = PUBSUB Machine = Servername: shutdown succeed
ed
Server Id = 102 Group Id = PUBSUB Machine = Servername: shutdown succeed
ed
Server Id = 101 Group Id = PUBSUB Machine = Servername: shutdown succeed
ed
9 processes stopped.
> boot -g PUBSUB
INFO: BEA Tuxedo, Version 9.1, 64-bit, Patch Level 036
INFO: Serial #: 650522264137-2065448083901, Expiration NONE, Maxusers 1000000
INFO: Licensed to: Oracle-Peoplesoft-ISV
Booting server processes ...
exec PSBRKHND -p 1,600:1,1 -s PSBRKHND_dflt:BrkProcess -- -C psappsrv.cfg -D HRP
RD -S PSBRKHND_dflt :
process id=22564 ... Started.
exec PSBRKHND -p 1,600:1,1 -s PSBRKHND_dflt:BrkProcess -- -C psappsrv.cfg -D HRP
RD -S PSBRKHND_dflt :
process id=22569 ... Started.
exec PSBRKDSP -s PSBRKDSP_dflt:Dispatch -- -C psappsrv.cfg -D HRPRD -S PSBRKDSP_
dflt :
process id=22572 ... Started.
exec PSPUBHND -p 1,600:1,1 -s PSPUBHND_dflt:PubConProcess -- -C psappsrv.cfg -D
HRPRD -S PSPUBHND_dflt :
process id=22577 ... Started.
exec PSPUBHND -p 1,600:1,1 -s PSPUBHND_dflt:PubConProcess -- -C psappsrv.cfg -D
HRPRD -S PSPUBHND_dflt :
process id=22580 ... Started.
exec PSPUBDSP -s PSPUBDSP_dflt:Dispatch -- -C psappsrv.cfg -D HRPRD -S PSPUBDSP_
dflt :
process id=22583 ... Started.
exec PSSUBHND -p 1,600:1,1 -s PSSUBHND_dflt:SubConProcess -- -C psappsrv.cfg -D
HRPRD -S PSSUBHND_dflt :
process id=22590 ... Started.
exec PSSUBHND -p 1,600:1,1 -s PSSUBHND_dflt:SubConProcess -- -C psappsrv.cfg -D
HRPRD -S PSSUBHND_dflt :
process id=22593 ... Started.
exec PSSUBDSP -s PSSUBDSP_dflt:Dispatch -- -C psappsrv.cfg -D HRPRD -S PSSUBDSP_
dflt :
process id=22596 ... Started.
9 processes started.
Peopletools PT8.50 Peoplebooks Instalation
Tools Peoplebooks
===============================================================================================================================================
Servername:/apps/psportal> bash
Servername:/apps/psportal> cd Environment_name
Servername:/apps/psportal/Environment_name> . ./psconfig.sh
Servername:/apps/psportal/Environment_name> clear
Servername:/apps/psportal/Environment_name> cd
Servername:/export/home/psportal> cd tempPT850/pplbooks/pt850/InstData/Solaris/NoVM/
Servername:/export/home/psportal/tempPT850/pplbooks/pt850/InstData/Solaris/NoVM> export DISPLAY=localhost:0.0
Servername:/export/home/psportal/tempPT850/pplbooks/pt850/InstData/Solaris/NoVM> sh ./install.bin -i console
Preparing to install...
Extracting the installation resources from the installer archive...
Configuring the installer for this system's environment...
Launching installer...
Preparing CONSOLE Mode Installation...
===============================================================================
PeopleSoft
Enterprise PeopleTools 8.50 PeopleBooks - Revision 1(created with InstallAnywhere)
---------------------------------------------------------------------------------------------
===============================================================================
Introduction
------------
InstallAnywhere will guide you through the installation of PeopleSoft
Enterprise PeopleTools 8.50 PeopleBooks - Revision 1.
It is strongly recommended that you quit all programs before continuing with
this installation.
Respond to each prompt to proceed to the next step in the installation. If you
want to change something on a previous step, type 'back'.
You may cancel this installation at any time by typing 'quit'.
PRESS <ENTER> TO CONTINUE:
===============================================================================
Choose Install Set
------------------
Please choose the Install Set to be installed by this installer.
->1- Typical
2- Customize...
ENTER THE NUMBER FOR THE INSTALL SET, OR PRESS <ENTER> TO ACCEPT THE DEFAULT
: 1
===============================================================================
Get User Input - Advanced Web Server
------------------------------------
Select from the options
->1- WebLogic
2- Websphere
ENTER A COMMA-SEPARATED LIST OF NUMBERS REPRESENTING THE DESIRED CHOICES, OR
PRESS <ENTER> TO ACCEPT THE DEFAULT:
===============================================================================
PS_HOME Directory
-----------------
Enter the path to your PeopleTools root folder, also known as PS_HOME e.g.
Windows: C:\pt850
Unix : /usr/apps/pt850
PS_HOME (DEFAULT: /apps/psportal/Environment_name):
===============================================================================
PS_HOME Validation
------------------
Is this correct?
/apps/psportal/Environment_name
->1- Yes
2- No
ENTER THE NUMBER FOR YOUR CHOICE, OR PRESS <ENTER> TO ACCEPT THE DEFAULT:
:
===============================================================================
Advanced Search Collection
--------------------------
Do you want to automatically create the search collection during this install? (You can generate search collection after the install)
->1- Build search collection
2- Do not build search collection
ENTER A COMMA-SEPARATED LIST OF NUMBERS REPRESENTING THE DESIRED CHOICES, OR
PRESS <ENTER> TO ACCEPT THE DEFAULT:
===============================================================================
Collection Build Confirmation
-----------------------------
You selected: Build search collection
If this is not correct, type 'back' and change your selection.
PRESS <ENTER> TO CONTINUE:
===============================================================================
Web server root directory
-------------------------
Enter the location of the web server root folder name. Examples:
Windows WebLogic: C:\Oracle\Middleware\wlserver_10.3
Unix WebLogic: /home/data1/Oracle/Middleware/wlserver_10.3
Windows Websphere: c:\was7\AppServer
Unix Websphere: /home/data/was7/AppServer
WebServer Root Folder Name (DEFAULT: /export/home/psportal)
: /apps/wls
===============================================================================
Web Server path validation
--------------------------
Is this correct?
/apps/wls
->1- Yes
2- No
ENTER THE NUMBER FOR YOUR CHOICE, OR PRESS <ENTER> TO ACCEPT THE DEFAULT:
:
===============================================================================
Important Information
---------------------
Please read before continuing:
PeopleSoft Internet Architecture must reside directly under the PS_HOME where
PeopleBooks will be installed. Verity must also be installed under PS_HOME.
If your system does not meet the minimum installation requirements, full-text
search will be disabled. See "Setting Up the PeopleSoft Pure Internet
Architecture" in the PeopleTools Installation Guide for further information.
Click Cancel from the graphical installer, or type 'quit' from the console if
you would like to exit setup now.
IMPORTANT INFORMATION COMPLETE. PRESS <ENTER> TO CONTINUE:
===============================================================================
Choose Install Folder
---------------------
Specify PSOL folder, located within your PeopleTools directory. Examples:
WebLogic: C:pt850\webserv\peoplesoft\applications\peoplesoft\PSOL.war
Websphere: /home/data1/pt850/webserv/peoplesoft/installedApps/peoplesoftNodeCel
l/peoplesoft.ear\PSOL.war
Where is your PSOL folder located under PIA?
Default Install Folder: /export/home/psportal/PeopleSoft
Enterprise PeopleTools 8.50 PeopleBooks - Revision 1
ENTER AN ABSOLUTE PATH, OR PRESS <ENTER> TO ACCEPT THE DEFAULT
: /apps/psportal/Environment_name/webserv/peoplesoft_server1/applications/peoplesoft/PSOL.war
INSTALL FOLDER IS: /apps/psportal/Environment_name/webserv/peoplesoft_server1/applica
tions/peoplesoft/PSOL.war
IS THIS CORRECT? (Y/N): y
===============================================================================
Advanced Online Library Directory
---------------------------------
Enter PeopleBooks Online Library Directory Name
PeopleBooks Online Library Name (DEFAULT: htmldoc):
===============================================================================
Overwrite Options
-----------------
Please note:
If at any time the installer prompts whether to overwrite existing files,
please select to OVERWRITE ALL.
PRESS <ENTER> TO CONTINUE:
===============================================================================
Pre-Installation Summary
------------------------
Please Review the Following Before Continuing. You may also type 'quit' or
'back'.
Product Name:
PeopleSoft
Enterprise PeopleTools 8.50 PeopleBooks - Revision 1
Install Folder:
/apps/psportal/Environment_name/webserv/peoplesoft_server1/applications/peoplesoft/PSOL.war
Online Library Folder Name
htmldoc
Disk Space Information (for Installation Target):
Required: 90,179,028 bytes
Available: 11,535,824,896 bytes
PRESS <ENTER> TO CONTINUE:
===============================================================================
Installing...
-------------
[==================
==================
==================
==================]
[------------------
------------------
------------------
---
1- Yes to All
2- Yes
3- No
4- No to All
A newer file named "colltypes.js" already exists at "/apps/psportal/Environment_name/
webserv/peoplesoft_server1/applications/peoplesoft/PSOL.war/htmldoc/eng/js".
Do you want to overwrite the existing file?: 1
---------------]
===============================================================================
Full Search Collection Build
----------------------------
The collection build is about to begin. Please press Enter to begin the
process, and be patient while the build completes. Each collection can take as
long as one hour to create.
No status messages will display during the process.
PRESS <ENTER> TO CONTINUE:
===============================================================================
Installation Complete
---------------------
Congratulations. PeopleSoft
Enterprise PeopleTools 8.50 PeopleBooks - Revision 1 has been successfully
installed to:
/apps/hrprd/webserv/peoplesoft/applications/peoplesoft/PSOL.war/htmldoc
To use your PeopleBooks web site, please consult the PeopleTools Installation
Guide for your environment.
Detailed instructions are available in the Appendix section titled "Installing
PeopleBooks".
Open your PeopleBooks at the URL:
http://xxxx:yy/PSOL/htmldoc/index.htm
where xxxx=localhostname of this server
yy=PSOL port number
PRESS <ENTER> TO EXIT THE INSTALLER:
===============================================================================================================================================
Servername:/apps/psportal> bash
Servername:/apps/psportal> cd Environment_name
Servername:/apps/psportal/Environment_name> . ./psconfig.sh
Servername:/apps/psportal/Environment_name> clear
Servername:/apps/psportal/Environment_name> cd
Servername:/export/home/psportal> cd tempPT850/pplbooks/pt850/InstData/Solaris/NoVM/
Servername:/export/home/psportal/tempPT850/pplbooks/pt850/InstData/Solaris/NoVM> export DISPLAY=localhost:0.0
Servername:/export/home/psportal/tempPT850/pplbooks/pt850/InstData/Solaris/NoVM> sh ./install.bin -i console
Preparing to install...
Extracting the installation resources from the installer archive...
Configuring the installer for this system's environment...
Launching installer...
Preparing CONSOLE Mode Installation...
===============================================================================
PeopleSoft
Enterprise PeopleTools 8.50 PeopleBooks - Revision 1(created with InstallAnywhere)
---------------------------------------------------------------------------------------------
===============================================================================
Introduction
------------
InstallAnywhere will guide you through the installation of PeopleSoft
Enterprise PeopleTools 8.50 PeopleBooks - Revision 1.
It is strongly recommended that you quit all programs before continuing with
this installation.
Respond to each prompt to proceed to the next step in the installation. If you
want to change something on a previous step, type 'back'.
You may cancel this installation at any time by typing 'quit'.
PRESS <ENTER> TO CONTINUE:
===============================================================================
Choose Install Set
------------------
Please choose the Install Set to be installed by this installer.
->1- Typical
2- Customize...
ENTER THE NUMBER FOR THE INSTALL SET, OR PRESS <ENTER> TO ACCEPT THE DEFAULT
: 1
===============================================================================
Get User Input - Advanced Web Server
------------------------------------
Select from the options
->1- WebLogic
2- Websphere
ENTER A COMMA-SEPARATED LIST OF NUMBERS REPRESENTING THE DESIRED CHOICES, OR
PRESS <ENTER> TO ACCEPT THE DEFAULT:
===============================================================================
PS_HOME Directory
-----------------
Enter the path to your PeopleTools root folder, also known as PS_HOME e.g.
Windows: C:\pt850
Unix : /usr/apps/pt850
PS_HOME (DEFAULT: /apps/psportal/Environment_name):
===============================================================================
PS_HOME Validation
------------------
Is this correct?
/apps/psportal/Environment_name
->1- Yes
2- No
ENTER THE NUMBER FOR YOUR CHOICE, OR PRESS <ENTER> TO ACCEPT THE DEFAULT:
:
===============================================================================
Advanced Search Collection
--------------------------
Do you want to automatically create the search collection during this install? (You can generate search collection after the install)
->1- Build search collection
2- Do not build search collection
ENTER A COMMA-SEPARATED LIST OF NUMBERS REPRESENTING THE DESIRED CHOICES, OR
PRESS <ENTER> TO ACCEPT THE DEFAULT:
===============================================================================
Collection Build Confirmation
-----------------------------
You selected: Build search collection
If this is not correct, type 'back' and change your selection.
PRESS <ENTER> TO CONTINUE:
===============================================================================
Web server root directory
-------------------------
Enter the location of the web server root folder name. Examples:
Windows WebLogic: C:\Oracle\Middleware\wlserver_10.3
Unix WebLogic: /home/data1/Oracle/Middleware/wlserver_10.3
Windows Websphere: c:\was7\AppServer
Unix Websphere: /home/data/was7/AppServer
WebServer Root Folder Name (DEFAULT: /export/home/psportal)
: /apps/wls
===============================================================================
Web Server path validation
--------------------------
Is this correct?
/apps/wls
->1- Yes
2- No
ENTER THE NUMBER FOR YOUR CHOICE, OR PRESS <ENTER> TO ACCEPT THE DEFAULT:
:
===============================================================================
Important Information
---------------------
Please read before continuing:
PeopleSoft Internet Architecture must reside directly under the PS_HOME where
PeopleBooks will be installed. Verity must also be installed under PS_HOME.
If your system does not meet the minimum installation requirements, full-text
search will be disabled. See "Setting Up the PeopleSoft Pure Internet
Architecture" in the PeopleTools Installation Guide for further information.
Click Cancel from the graphical installer, or type 'quit' from the console if
you would like to exit setup now.
IMPORTANT INFORMATION COMPLETE. PRESS <ENTER> TO CONTINUE:
===============================================================================
Choose Install Folder
---------------------
Specify PSOL folder, located within your PeopleTools directory. Examples:
WebLogic: C:pt850\webserv\peoplesoft\applications\peoplesoft\PSOL.war
Websphere: /home/data1/pt850/webserv/peoplesoft/installedApps/peoplesoftNodeCel
l/peoplesoft.ear\PSOL.war
Where is your PSOL folder located under PIA?
Default Install Folder: /export/home/psportal/PeopleSoft
Enterprise PeopleTools 8.50 PeopleBooks - Revision 1
ENTER AN ABSOLUTE PATH, OR PRESS <ENTER> TO ACCEPT THE DEFAULT
: /apps/psportal/Environment_name/webserv/peoplesoft_server1/applications/peoplesoft/PSOL.war
INSTALL FOLDER IS: /apps/psportal/Environment_name/webserv/peoplesoft_server1/applica
tions/peoplesoft/PSOL.war
IS THIS CORRECT? (Y/N): y
===============================================================================
Advanced Online Library Directory
---------------------------------
Enter PeopleBooks Online Library Directory Name
PeopleBooks Online Library Name (DEFAULT: htmldoc):
===============================================================================
Overwrite Options
-----------------
Please note:
If at any time the installer prompts whether to overwrite existing files,
please select to OVERWRITE ALL.
PRESS <ENTER> TO CONTINUE:
===============================================================================
Pre-Installation Summary
------------------------
Please Review the Following Before Continuing. You may also type 'quit' or
'back'.
Product Name:
PeopleSoft
Enterprise PeopleTools 8.50 PeopleBooks - Revision 1
Install Folder:
/apps/psportal/Environment_name/webserv/peoplesoft_server1/applications/peoplesoft/PSOL.war
Online Library Folder Name
htmldoc
Disk Space Information (for Installation Target):
Required: 90,179,028 bytes
Available: 11,535,824,896 bytes
PRESS <ENTER> TO CONTINUE:
===============================================================================
Installing...
-------------
[==================
==================
==================
==================]
[------------------
------------------
------------------
---
1- Yes to All
2- Yes
3- No
4- No to All
A newer file named "colltypes.js" already exists at "/apps/psportal/Environment_name/
webserv/peoplesoft_server1/applications/peoplesoft/PSOL.war/htmldoc/eng/js".
Do you want to overwrite the existing file?: 1
---------------]
===============================================================================
Full Search Collection Build
----------------------------
The collection build is about to begin. Please press Enter to begin the
process, and be patient while the build completes. Each collection can take as
long as one hour to create.
No status messages will display during the process.
PRESS <ENTER> TO CONTINUE:
===============================================================================
Installation Complete
---------------------
Congratulations. PeopleSoft
Enterprise PeopleTools 8.50 PeopleBooks - Revision 1 has been successfully
installed to:
/apps/hrprd/webserv/peoplesoft/applications/peoplesoft/PSOL.war/htmldoc
To use your PeopleBooks web site, please consult the PeopleTools Installation
Guide for your environment.
Detailed instructions are available in the Appendix section titled "Installing
PeopleBooks".
Open your PeopleBooks at the URL:
http://xxxx:yy/PSOL/htmldoc/index.htm
where xxxx=localhostname of this server
yy=PSOL port number
PRESS <ENTER> TO EXIT THE INSTALLER:
PT 8.50 Date Fromat ERROR in SQR
ORA-01830: date format picture ends before converting entire input string
TRUNC(TO_DATE(DAT1.UPD_DTTM)) = to_date($AsOfDate, 'DD-MON-YYYY') – solution AND TRUNC(TO_DATE(DAT1.UPD_DTTM)) = to_date($AsOfDate, 'DD-MON-YYYY HH24:MI:SS')
TRUNC(TO_DATE(DAT1.UPD_DTTM)) = to_date($AsOfDate, 'DD-MON-YYYY') – solution AND TRUNC(TO_DATE(DAT1.UPD_DTTM)) = to_date($AsOfDate, 'DD-MON-YYYY HH24:MI:SS')
Configuration Files Locations
Ps configuration - /apps/environment_name/
Configuration. properties – Server_name:/apps/ environment_name/webserv/peoplesoft/applications/peoplesoft/PORTAL/WEB-INF/psftdocs/hdprd>
Integration broker.properties - /apps/ environment_name/webserv/peoplesoft/applications/peoplesoft/PSIGW/WEB-INF
Configuration. properties – Server_name:/apps/ environment_name/webserv/peoplesoft/applications/peoplesoft/PORTAL/WEB-INF/psftdocs/hdprd>
Integration broker.properties - /apps/ environment_name/webserv/peoplesoft/applications/peoplesoft/PSIGW/WEB-INF
Peoplesoft & UPK help Integration
Peoplesoft & UPK help Integration
This document list the steps that are to be performed to integrate the peoplesoft’s people books help with the UPK content help.
Before proceeding further, it is advised to go through chapter 5 of UPK deployment guide. This chapter explains in details that are to be performed to integrate with UPK help contents.
D$268601/
Below steps is the summary of above chapter and also includes a step which is not included by ORACLE. Information in brackets are w.r.t HR development and test environment.
• Search for f1search.htm file in web server where peoplebooks are installed and rename it to PeopleBooks_f1search.htm.
(Renamed the f1search.htm in folder http://Servername:19580/PSOL/htmldoc to PeopleBooks_f1search.htm.)
• Copy pst8_gateway.html and odcontenturl.js from PST8/hemi of UPK content foder to htmldoc folder of peoplebooks.
(Copy pst8_gateway.html and odcontenturl.js from http://Servername:19580/PSOL/upk/PST8/hemi to http://Servername:19580/PSOL/htmldoc)
• Copy esacape.js also from the directory mentioned in step 2 (This is not mentioned in deployment/content administration guide but required).
• Rename pst8_gateway.html to f1search.htm.
• Rename odcontenturl.js to odcustomurl.js and changed the variables as below:
OD_DEFAULT_URL =
OD_DEFAULT_URL = "http://Servername:19580/PSOL/upk/";
PBOOKS_URL =
PBOOKS_URL = http://Servername:19580/PSOL/htmldoc/PeopleBooks_f1search.htm";
• Reboot the web server.
This document list the steps that are to be performed to integrate the peoplesoft’s people books help with the UPK content help.
Before proceeding further, it is advised to go through chapter 5 of UPK deployment guide. This chapter explains in details that are to be performed to integrate with UPK help contents.
D$268601/
Below steps is the summary of above chapter and also includes a step which is not included by ORACLE. Information in brackets are w.r.t HR development and test environment.
• Search for f1search.htm file in web server where peoplebooks are installed and rename it to PeopleBooks_f1search.htm.
(Renamed the f1search.htm in folder http://Servername:19580/PSOL/htmldoc to PeopleBooks_f1search.htm.)
• Copy pst8_gateway.html and odcontenturl.js from PST8/hemi of UPK content foder to htmldoc folder of peoplebooks.
(Copy pst8_gateway.html and odcontenturl.js from http://Servername:19580/PSOL/upk/PST8/hemi to http://Servername:19580/PSOL/htmldoc)
• Copy esacape.js also from the directory mentioned in step 2 (This is not mentioned in deployment/content administration guide but required).
• Rename pst8_gateway.html to f1search.htm.
• Rename odcontenturl.js to odcustomurl.js and changed the variables as below:
OD_DEFAULT_URL =
OD_DEFAULT_URL = "http://Servername:19580/PSOL/upk/";
PBOOKS_URL =
PBOOKS_URL = http://Servername:19580/PSOL/htmldoc/PeopleBooks_f1search.htm";
• Reboot the web server.
Subscribe to:
Posts (Atom)