Prashant

Author Archives: Prashant

Switching PeopleSoft Home Page from Classic mode to Fluid UI on Desktop computers

Firstly, make sure you’ve enabled the Fluid UI for desktop computers. Now based on your personalization settings, you would be either shown a Fluid UI home page or classic home page. Default setting for desktop computers is to show classic home page. To switch from Classic Home page to Fluid UI , Click on NavBar […]

How To Apply Change Control Locking in PeopleSoft

In order to avert a disaster in PeopleSoft or to enable investigative analysis in PeopleSoft after a disaster, you need to enable change control locking in PeopleSoft. To Enable Change Control Locking in PeopleSoft: Login into the database using application designer Navigate to Tools > Change Control > Administration Check the Change control Locking to activate the […]

Quickly Find Users Who Have Access To DataMover

Datamover is a very powerful tool and access to it should always be controlled especially in PRD environments. In every organization, many users switch departments, roles and responsibilities over a period of time and every once in a while, you should review the security associated with these users to confirm that they don’t have any […]

PeopleTools 8.54: New Features in PeopleSoft Server Administration

Oracle has added great new features with PeopleTools 8.54. One important area where you will notice significant changes is System and Server Administration. Features such as Portable PS_HOME, Container databases are example of newly added features. In this post, you will learn about the new features that have been added to PeopleSoft System and Server […]

Complete List of PeopleSoft Tables

I could not find this else where and hence, I decided to build one myself – a complete list of PeopleSoft tables. Often a times when working on something like a PeopleSoft issue or a PeopleSoft upgrade, you feel the need to have a handly list of PeopleSoft tables. What we’ve tried here is to […]

Unable to open PeopleTools objects in Application Designer

PeopleSoft developers regularly use PeopleSoft Application Designer to view/modify PeopleTools Objects such as fields, records, pages, components etc. Developer’s login access to Application Designer is controlled by PeopleSoft Security configured in PIA. Depending on user’s role you can grant read/write access or read only access. In both the cases developer should be able to open […]

PeopleSoft 9.2 Upgrade: Databases used in Upgrade Initial Pass

In this article, we will discuss about different environments that are used during PeopleSoft 9.2 upgrade initial Pass. You will also learn about the specific use of each of these environments and what they represent. New Release Demo Database (Source) New Release demo database refers to the database delivered with your new PeopleSoft release. If […]

PeopleSoft Upgrade Accelerators

Most of the organizations using PeopleSoft applications are either upgrading their existing PeopleSoft applications to PeopleSoft 9.2 version or are planning to do it in near future. Upgrading a PeopleSoft application can be a huge effort and requires consideration of so many things especially money & time and we all know “Time is Money”. […]

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

Things To Keep In Mind Before Assigning PeopleSoft Administrator Role

PeopleSoft Administrator Role is special system role that can be assigned to user profiles. Unlike other PeopleSoft roles, you can’t see the permission list (PSADMIN) associated to this role. Even if you search for this role in PeopleTools > Security > Permissions & Roles > Roles, you won’t find it. Try to open up the […]

CFO Tool provides details of new features in PeopleSoft Images

CFO or Cumulative Feature Overview tool is used to identify product features available to you when upgrading to a new release. As we mentioned earlier that recently Oracle converted this tool from a excel based utility to a web based tool. Any user can go to the web based CFO tool and see the differences […]

What is TMUSREVT.EXE?

TMUSREVT.EXE is known as Tuxedo Event Broker and is a new process added in PeopleTools 8.54. It’s used for Push Notification feature in PT 8.54. To receive push notifications on a PeopleSoft system, you have to enable push notifications for the server domains where the events are being published. Events are published from application server […]

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

How To Change Colors in Oracle Virtual Box Terminal

If I tell you that I was really unhappy with the coloring scheme of Oracle Virtual Box terminal then I am sure, I won’t be the only one. PeopleSoft Images are delivered with Oracle Linux OS which needs to be deployed on Oracle Virtual Box. If you happen to login as root on the VM […]

How To Download PeopleTools 8.54 from Certifications Tab on Oracle Support

Most of you would already know that PeopleTools 8.54 can be downloaded from Oracle’s edelivery site i.e. edelivery.oracle.com. But do you know that you can also download PeopleTools 8.54 setup files from certifications tab on Oracle support. Go to Certifications tab and then search for certifications for PeopleTools 8.54 as shown below. From the certification […]

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

Export SQL Results To Excel Using SQLPLUS

Here is quick tip on how to easily export SQL results into an excel file. Step 1: Login into database using SQL PLUS Step 2: Set markup using below command SET MARKUP HTML ON Step 3: Spool the output to a file. SPOOL C:\TEMP\MYOUTPUT.XLS Step 4: Run your SQL Query SQL QUERY Step 5: Set […]

PeopleSoft Master Notes for Common Issues

PeopleSoft is such a huge application with so many interconnected pieces that PeopleSoft consultants always find themselves fixing issues related to one or the other tool in PeopleSoft. Most of us usually head over to Oracle support and then start searching for the issues. Sometimes it may take lot of time to find the exact […]

« Previous 1 2 3 4 5 … 9 Next »