Prashant

Author Archives: Prashant

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

Continue reading
1

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

Continue reading
15

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

Continue reading
1

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

Continue reading

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

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

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

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

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

Continue reading

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

Continue reading