Installing FSCM 9.0 PeopleBooks for SQL Server on Windows

Problem: Procedure for installing PeopleBooks for Financials/Supply Chain Management (FSCM) 9.0 unclear.

Solution:

The documentation for installing PeopleBooks is available in the PeopleTools Installation guide. In this case, FSCM 9.0 was installed on PeopleTools 8.49 on the Microsoft SQL Server database.

Locating PeopleBooks Online

Oracle’s PeopleSoft documentation is located at:

http://www.oracle.com/technetwork/documentation/psftent-090284.html

The PeopleTools 8.49 documentation can be found online at:

http://download.oracle.com/docs/cd/E05406_01/psft/html/docset.html

The actual document used was “PeopleTools 8.49 Installation for Microsoft SQL Server”, available at:

http://download.oracle.com/docs/cd/E05406_01/psft/acrobat/hwtools849_itmss.pdf

Appendix D (“Installing PeopleBooks”) gives details on how to install PeopleBooks.

Downloading PeopleBooks

If you do not have the installation media for PeopleBooks, it can be downloaded from E-Delivery (http://edelivery.oracle.com). After logging on to E-Delivery (you must have proper credentials from Oracle to do so), make the following selections from the drop-down list:

Select a Product Pack: PeopleSoft Enterprise

Platform: Microsoft Windows (32-bit)

Then click Go.

Scroll down the list of results and select “PeopleSoft Enterprise – Financials & Supply Chain Management 9.0 Media Pack”.

To download the PeopleBooks CD, select “PeopleSoft Enterprise Financials and Supply Chain Management 9.0 PeopleBooks (CD) B34053-01 334 MB”, which should be the third item on the list.

After download B34053-01.zip, unzip the contents of the file into a folder. The extracted files are:

09/13/2006  06:25 PM                13 media.inf
09/13/2006  06:28 PM        31,241,789 setup.aix
09/13/2006  06:28 PM        14,368,946 setup.exe
09/13/2006  06:28 PM        51,998,975 setup.hp
09/13/2006  06:29 PM        76,273,147 setup.hp-ia64
09/13/2006  06:28 PM       122,835,905 setup.jar
09/13/2006  06:28 PM        22,474,009 setup.linux
09/13/2006  06:28 PM        24,603,476 setup.solaris
08/28/2003  06:41 PM                78 setup.tru64
09/13/2006  06:28 PM            66,560 setup.unix
09/13/2006  06:28 PM        14,341,453 setupwin32Console.exe

Installing PeopleBooks

For Windows, run setup.exe.

The InstallShield Wizard for PeopleBooks appears.

After accepting the terms of the license agreement, enter the PeopleSoft license code. If the PeopleSoft installation is a demo instance, PeopleSoft master level license codes from may be used. These are available from:

http://www.oracle.com/us/support/licensecodes/peoplesoft-enterprise/index.html

For Financial & Supply Chain Management:

Database                License Code
Microsoft SQL Server    137fff-ffffff-fffffff-19ff81-7ym4o2

Then click Next.

On the next screen, since only FSCM 9.0 is installed, click “Generate search collection on this product only”. Then click Next.

Select the webserver you have installed, and whether PIA is installed. In this case, choose “BEA WebLogic Server” and “Yes”. Then click Next.

Next, enter the path to PS_HOME and the web server.

Enter the path to PS_HOME: E:PT849FS900

Enter the path to WebLogic: E:beaweblogic92

(Enter the path to PSOL directory: E:PT849FS900webservfsdmoapplicationspeoplesoftPSOLhtmldoc)

Then click Next.

Enter the installation directory for PeopleBooks: E:PT849FS900webservfsdmoapplicationspeoplesoftPSOLhtmldoc

Then click Next.

Select the products for which you want to install PeopleBooks. By default, all PeopleBooks are selected.

Then click Next.

Select “Continue installing with currently selected PeopleBooks”.

Then click Next. Then click Next again to continue installing. The “Generating Search Collection” progress bar takes a few minutes to complete.

Configuring Online Help

After logging on to PeopleSoft as the superuser (VP1), navigate to PeopleTools > Web Profile > Web Profile Configuration. Click Search.

To determine which web profile is being used, check the configuration.properties file:

E:PT849FS900webservfsdmoapplicationspeoplesoftPORTALWEB-INFpsftdocsfsdmoconfiguration.properties

or any other configuration.properties file.

Troubleshooting

1. When Help link clicked, the following message appears:

Error 404--Not Found
From RFC 2068 Hypertext Transfer Protocol -- HTTP/1.1:
10.4.5 404 Not Found
The server has not found anything matching the Request-URI. No indication is given of whether 
the condition is temporary or permanent.

If the server does not wish to make this information available to the client, the status code 
403 (Forbidden) can be used instead. The 410 (Gone) status code SHOULD be used if the server 
knows, through some internally configurable mechanism, that an old resource is permanently 
unavailable and has no forwarding address.

Solution: Regenerate search collection:

In the %PS_HOME%webserv%domain_name%applicationspeoplesoftPSOLhtmldocadmin there are several batch files. Run mkcollection.bat from Command Prompt with the following options:

mkcollection.bat {PSOL.war path} {PS_HOME} WEBLOGIC {Weblogic_path} htmldoc ENG psbooks

For example:

E:PT849FS900webservfsdmoapplicationspeoplesoftPSOLhtmldocadmin> mkcollection.bat E:PT849FS900webservfsdmoapplicationspeoplesoftPSOL E:PT849FS900 WEBLOGIC E:beaweblogic92 htmldoc ENG psbooks

The ENG language code can be replaced depending on what languages you have installed.

After running mkcollection.bat
usage:
mkcollections.bat APPLICATION_PATH PSOL_PSHOME WEBSERVER PSOL_WEBSERVER_HOME SUBFOLDER [LANG] [DOCTYPE]
Where WEBSERVER is OAS, WEBLOGIC or WEBSPHERE
or
mkcollections.bat APPLICATION_PATH [SUBFOLDER] [LANG]  [DOCTYPE]

2. When running mkcollection.bat, the following error appears:

java.io.FileNotFoundException:
E:PT849FS900webservfsdmoapplicationspeoplesoftPSOLhtmldoccfrjscolltypes.js
(The system cannot find the file specified)

        at java.io.FileInputStream.open(Ljava.lang.String;)V(Native Method)
        at java.io.FileInputStream.<init>(FileInputStream.java:106)
        at java.io.FileInputStream.<init>(FileInputStream.java:66)
        at com.peoplesoft.pt.psol.common.DocTypes$DocType.getTitle(DocTypes.java:304)
        at com.peoplesoft.pt.psol.common.DocTypes.getDocTypeTitle(DocTypes.java:91)
        at com.peoplesoft.pt.psol.scan.doScan(scan.java:373)
        at com.peoplesoft.pt.psol.scan.main(scan.java:846)
Collection created: 0/1

java.io.FileNotFoundException:
E:PT849FS900webservfsdmoapplicationspeoplesoftPSOLhtmldocdanjscolltypes.js
(The system cannot find the file specified)

        at java.io.FileInputStream.open(Ljava.lang.String;)V(Native Method)
        at java.io.FileInputStream.<init>(FileInputStream.java:106)
        at java.io.FileInputStream.<init>(FileInputStream.java:66)
        at com.peoplesoft.pt.psol.common.DocTypes$DocType.getTitle(DocTypes.java:304)
        at com.peoplesoft.pt.psol.common.DocTypes.getDocTypeTitle(DocTypes.java:91)
        at com.peoplesoft.pt.psol.scan.doScan(scan.java:373)
        at com.peoplesoft.pt.psol.scan.main(scan.java:846)
Collection created: 0/1

java.io.FileNotFoundException:
E:PT849FS900webservfsdmoapplicationspeoplesoftPSOLhtmldocdutjscolltypes.js
(The system cannot find the file specified)

        at java.io.FileInputStream.open(Ljava.lang.String;)V(Native Method)
        at java.io.FileInputStream.<init>(FileInputStream.java:106)
        at java.io.FileInputStream.<init>(FileInputStream.java:66)
        at com.peoplesoft.pt.psol.common.DocTypes$DocType.getTitle(DocTypes.java:304)
        at com.peoplesoft.pt.psol.common.DocTypes.getDocTypeTitle(DocTypes.java:91)
        at com.peoplesoft.pt.psol.scan.doScan(scan.java:373)
        at com.peoplesoft.pt.psol.scan.main(scan.java:846)
Collection created: 0/1
E:PT849FS900webservfsdmoapplicationspeoplesoftPSOLhtmldocdutjscolltypes.js
(The system cannot find the file specified)

Solution: Copy E:PT849FS900webservfsdmoapplicationspeoplesoftPSOLhtmldocengjscolltypes.js to E:PT849FS900webservfsdmoapplicationspeoplesoftPSOLhtmldoccsrjs, E:PT849FS900webservfsdmoapplicationspeoplesoftPSOLhtmldocdanjs, and E:PT849FS900webservfsdmoapplicationspeoplesoftPSOLhtmldocdutjs.

Or specify the ENG parameter in the mkcollection.bat command.

Eventually the issue was resolved by rebooting the server. Perhaps there isn’t enough memory on the machine to host all the applications that the server is running, and rebooting the server freed the memory.

Other tips tried:

Copied E:PT849FS900webservfsdmoapplicationspeoplesoftPSOLWEB-INFlibwinx86psjniverity.dll to E:PT849FS900webservfsdmoapplicationspeoplesoftPSOLWEB-INFlib

E:PT849FS900webservfsdmoapplicationspeoplesoftPSOLWEB-INFweb.xml

Leave a Comment


NOTE - You can use these HTML tags and attributes:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>


This site uses Akismet to reduce spam. Learn how your comment data is processed.