PeopleSoft Maintenance | PeopleSoft Tutorial

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 […]

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 […]

Get Count of All PeopleSoft Tables with one SQL

While performing upgrades or applying maintenance to your PeopleSoft applications, you might want to get row count of all your PeopleSoft tables. There are few ways of doing it which we will discuss below and finally the one which I think is the easiest and most efficient way. Option 1: Running UPGCOUNT AE UPGCOUNT is […]

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 […]

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 […]

Uninstalling Change Assistant 8.54 using CA setup for 8.53

You might know that on one machine, you can have only one version of PeopleSoft Change Assistant installed at a time. If you try to install another version of CA, it would first uninstall the existing version and then allow you to install newer CA version. If you use Change Assistant setup for PeopleTools 8.53.x […]

How To Change Default Location Of Virtual Box Image Files

By default Virtual Box files are stored in C: drive under user directory. You may want to change this default location for variety of reasons, one of the most common would be disk space constraints or security concerns. If you wish to change the default path to other drive/directory you can do so as shown […]

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 […]

PeopleSoft Image Import Failed in Oracle Virtual Box

PeopleSoft Images have been made available for over an year now and you might have deployed one or more types of these PeopleSoft images. But you may still get some errors while deploying Virtual Images. One of the most common error that you may get is when you try to import these PeopleSoft Images into […]

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 […]

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 […]

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 […]

How To Change Logo Inside PeopleSoft Application

Default Oracle Logo is visible in top left corner in the PeopleSoft PIA, but if you want you can change the logo to something else. E.g Logo of your organization etc. You can change the logo by simply saving your customized image with the same name that is being referred online by the current PeopleSoft […]

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 […]

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 […]

Error While Installing NetExpress 5.1 RunTime License

Installing, compiling and running COBOLS in PeopleSoft is fairly simple but when you get issues then sometimes it may take longer to solve those. Though there might be a small configuration change that may fix it, but at times it may get critical depending on the situation and issue at hand. When you install Micro […]

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 […]

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 […]

1 2 Next »

Archive