Archive

Category Archives for "PeopleSoft Maintenance"
1

How To Change PS stylesheet using SQL

Stylesheets as the name suggests is the piece of code that adds style to your PeopleSoft application. When you log into PeopleSoft application, all the menus, colors , design are controlled by stylesheets. PeopleSoft application comes with a default stylesheet which can vary between different Application releases. Here are the default stylesheets for different PS […]

Continue reading
2

How To Find and Change Current Style Sheet in PeopleSoft

PeopleSoft Style Sheets controls the look and feel of the PeopleSoft Application. There are several style sheets available in PeopleSoft which can be used to change the appearance of PeopleSoft Application. Oracle sets a default style sheet for each application version. Below is the list of default Style Sheet for different Application Version. 9.0 and earlier […]

Continue reading

What are AlterAudit, Sysaudit and DDDAudit reports in PeopleSoft

Alter Audit is a process that identifies any records that require SQL Alter process. i.e. if the Data Designer definition doesn’t match Database definition. All records that are flagged should be Altered. SQL Alter – The primary purpose of the Application Designer’s “SQL Alter” function is to bring SQL tables into accordance with PeopleTools record […]

Continue reading

Access Denied Error while applying PRP patches to PeopleSoft Image

PRP stands for PeopleSoft Release Patchset. With PUM(PeopleSoft Update Manager) process Oracle releases PeopleSoft Images every couple of months that includes latest patches available for PeopleSoft 9.2 application. In between release of two images, if Oracle identifies few critical patches that need to be applied then those patches are delivered as PRP patches. PRP patches can […]

Continue reading

DNS Server Not Reachable Warning Message When Configuring Virtual Box Image

After you’ve successfully imported PeopleSoft Image files into Virtual Box, you need to configure the image to update network and application specific details. During network configuration step, if you choose to disable dynamic IP configuration and use static IP configuration then you will be asked to enter IP address, Gateway and DNS details manually. Below […]

Continue reading

How To Verify Integrity of PeopleSoft Image Files And Perform Check Sum

If you get error anytime when trying to import PeopleSoft Images then you need to make sure that all the separate files for a particular image were downloaded completely without any issues. Sometimes even if the download window may show download as complete but there might be something missing. To verify the integrity of PeopleSoft […]

Continue reading
5

What are different types of PeopleSoft Virtual Images?

As most of you would already know that Oracle is now delivering PeopleSoft Virtual Images that can be used for variety of purposes like Demo, training purposes, applying patches, during upgrade etc. One thing to note here is that there are 3 different types of images currently available and you should review these image types, then decide and deploy […]

Continue reading

How to Get Latest Alerts on PeopleSoft Update Manager

PeopleSoft Update Manager is the new lifecycle management process for PeopleSoft 9.2 customers to use for all their application maintenance needs. PeopleSoft Update Manager will be of limited help if you do not stay current with the latest updates released by Oracle. This article highlights the process you should follow to stay current with any […]

Continue reading

ORA-01555: snapshot too old

We were doing stress testing in PeopleSoft ELM and ran the Mass Enrollment AppEngine. After running for about 90 minutes, it failed with the error ORA-01555: snapshot too old: rollback segment number 19 with name “_SYSSMU19_1270741541$” too small The ORA-01555 error is caused by Oracle read consistency mechanism and is usually associated with long running […]

Continue reading

Error: Micro Focus License Manager service is not running

Trying to run COBOL process from PeopleSoft Process Scheduler and getting ‘Micro Focus License Manager service is not running’ ? In most of the cases it happens when you change or upgrade your windows server on which process scheduler is hosted. Micro Focus License Manager Service is required on run-time systems where compiled COBOLs are […]

Continue reading

PeopleSoft Performance Tuning Using OEM

PeopleSoft Admins or PeopleSoft DBAs or Oracle DBAs know the importance of finding, analyzing, and correcting resource-intensive SQL statements. Those shops which run PeopleSoft on Oracle can make use of Oracle Enterprise Manager (OEM) in isolating and analyzing troublesome SQL statements.  Using OEM, a DBA can quickly discover the SQL statements most responsible for performance degradation and then drill […]

Continue reading

Generating Key Store and Trust Store using Keytool

What is a Keytool? Keytool is a key and certificate management utility. It enables users to administer their own public/private key pairs and associated certificates for use in self-authentication. It also allows users to cache the public keys (in the form of certificates) of their communicating peers. What is a Keystore? Keytool stores the keys […]

Continue reading