Prashant

Author Archives: Prashant

PeopleSoft Critical Update includes 15 remotely exploitable flaws

Oracle’s critical security update is out and it includes 284 flaws for Oracle products. Out of these 284 flaws, 20 impacts PeopleSoft applications such as HCM, SCM, Campus community, PeopleTools 8.55, 8.56 and even the latest PeopleTools release 8.57. What is Oracle Critical Patch update? A Critical Patch Update is a collection of patches for […]

PeopleTools 8.57 – Page field property window in Application Designer

One of the newest features in PeopleSoft development area is ‘Page Field property window’ in Application Designer. This feature added in PeopleTools 8.57 is an excellent addition and is sure to improve developers’ productivity as it comes in really handy and provides easy access to ‘Page Field Property’ information. When you open a page in […]

PeopleTools 8.57 – Database Name shown in Application Designer Title Bar

Every PeopleTools release comes with new features to help customers utilize PeopleSoft application to its fullest. It’s not just the end users who get benefited from latest features, but there are tools that improve productivity of PeopleSoft developers also. Latest version of PeopleTools – 8.57 is also packed with hundreds of features that are designed […]

PeopleTools 8.57 is available now

Long wait is over now… PeopleTools 8.57 which was available for Oracle Cloud customers for past few months, is now available for everyone. PeopleTools 8.57 was released on Jan 14, 2019 and can be downloaded from Oracle Software Delivery Cloud (known as edelivery). These new files are now available in DPK format only as VCDs […]

PUM : Import Error – No module named yaml

Deploying PeopleSoft Images is fairly straight forward as long as you follow the directions properly. Sometimes even a slight deviation from the defined process might cause issues with your PeopleSoft Image. Here is an example when you try to import PeopleSoft Image by running ‘psft-dpk-setup.bat’ file. This file is extracted from first part of downloaded […]

New Features in PeopleSoft Update Manager in PeopleTools 8.57

Peopletools 8.57 currently available for Cloud customers, will soon be available for rest of the customers. While you wait for general release of PeopleTools 8.57 you can still take a look at its new features. To review new features in PeopleTools 8.57, you can simply download latest PUM (PeopleSoft Update Manager) images. For FSCM, latest […]

Find Size of PeopleSoft Tables and indexes [SQL]

What is the biggest pain for PeopleSoft Admins/DBA or any PeopleSoft consultant supporting the application? That’s when performance of PeopleSoft application is really sluggish. There are hundreds of things that could go wrong and one of those is directly related to size of your PeopleSoft database. PeopleSoft database consists of PeopleSoft Tables, indexes and few other objects […]

SQL to find when PeopleSoft table was built and analyzed in Oracle

Ever wondered when a PeopleSoft table was last built / altered or when its database stats were gathered ? Many times, you need to know that information to analyze what’s happening with a table. For example, your table may not be working correctly or the performance may be degraded. You may want to check when […]

PeopleSoft Jobs – PeopleSoft Interview Questions Set # 01

Looking for a PeopleSoft job? We’re here to help. We’ve compiled a huge database of PeopleSoft interview questions, which will help you sail through any interview for PeopleSoft jobs. The questions in this and other posts on “PeopleSoft Interview Questions” are good to know irrespective of whether you’re looking for a PeopleSoft developer jobs, PeopleSoft […]

New Features in PeopleTools 8.57

This post includes concise information about the new features in PeopleTools 8.57. We will post about these features in detail in other posts for PeopleTools 8.57. Below is based on comparison of features between PeopleTools 8.56 and PeopleTools 8.57. Quick Navigation Application DesignerApplication EngineBI PublisherIntegration BrokerPeopleCodePeopleSoft Deployment PackagesFluid User InterfacePivot GridPortal TechnologyProcess SchedulerSearchSecurity AdministrationSystem […]

PeopleTools 8.57 Highlights [VIDEO]

Oracle recently released highlight video for PeopleTools 8.57. At first PT8.57 will be available for customers on Oracle Cloud. Below is the video that was published on Oracle’s Youtube Channel. Let us know in the comments section what do you think about these new features.

SQL to find PeopleSoft portal objects hidden from navigation

You can hide PeopleSoft portal objects (e.g. content reference) from PeopleSoft Navigation. This can be done by navigating to ‘Structure and Content’ and selecting the checkbox ‘Hide from portal navigation’. Navigate to PeopleTools > Portal > Structure and Content Incase you don’t have access to this page to view the configuration, you can check this […]

Unable to select recurrence when running PeopleSoft processes

Recurrences as the name suggests are used to run PeopleSoft processes repeatedly. You could create multiple recurrence selecting different date & time to create a schedule such as daily, monthly etc. Once a recurrence is created, it can be used to schedule a process to run multiple times based on the recurrence settings. If you’re […]

How to find current status of PeopleSoft process scheduler

Process Scheduler plays an important role in PeopleSoft application by performing batch transactions & running processes and reports. Due to its significance in PeopleSoft architecture, availability of process scheduler become critical. Most of the organizations deploy multiple process scheduler to handle the requests. Still at times, process scheduler can behave erratically (specially when running on […]

How to monitor connections to PeopleSoft Database

Ever wondered how many users are connected to PeopleSoft database? This is different than users who login into PeopleSoft application via web. You can find users who make direct SQL connection with your PeopleSoft database. This includes anyone using SQL client tool, PeopleSoft development tools and connections made by PeopleSoft server such as application server […]

Change PeopleSoft Access ID & Password in PeopleTools 8.56 & 8.55

PeopleSoft Access ID also known as Owner ID is the owner of PeopleSoft tables. In Oracle, it’s commonly used as ‘SYSADM’ and ‘sa’ for SQL server. All PeopleSoft tables belongs to this user id and this ID is created during the database creation. You may need to change password for PeopleSoft access id /owner id […]

How to access SQL for a Private PS query of another user

PS query is a powerful tool for end users to fetch data from PeopleSoft application and users can create public and private queries. Although public queries can be viewed by anyone having access to Query Viewer or Query Manager but private queries can only be seen by the user who created them. But there could […]

Add welcome message to PeopleSoft Home Page

How do you notify PeopleSoft users about an event that has a system wide impact such as planned downtime or any other important update? Do you broadcast emails or post notice on internal portal or do you put a custom message for PeopleSoft login screen ? Here is how to put custom message on PeopleSoft […]

Where should we send this?