Prashant

Author Archives: Prashant

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

How to copy or share private ps query with another user

So you created an awesome private query and now you want to share it with another user. Since it’s a private query only the user id who created the query will have access to it. One way is to change the ps query from private to public. By making it public, everyone who has access […]

How to transfer private ps query from one user to another

There is a general difference between public and private query. As the name suggests, public query is available for everyone whereas private query can be used by the person who created it. But there could be a scenario, where you want to transfer private query of one user to another. This could happen when someone […]

Find PeopleSoft Navigation for a component using PIA

If you know the component name & have SQL access, you can use this SQL to find the navigation to the component. However there is an easier way to find the navigation to a component or page from PIA. Navigate to Enterprise Components > Find Object Navigation. On this page, you have different options to […]

Find PeopleSoft Navigation for a component using SQL

You can use below SQL to find PeopleSoft Navigation to a component. In below SQL replace the value of PORTAL_URI_SEG2 with your component name. SELECT DISTINCT REVERSE(LTRIM(SYS_CONNECT_BY_PATH (REVERSE(PORTAL_LABEL),’ >- ‘),’ >- ‘)) “NAVIGATION” FROM PSPRSMDEFN P WHERE PORTAL_OBJNAME = ‘PORTAL_ROOT_OBJECT’ START WITH PORTAL_URI_SEG2 = ‘PRCSDEFN’ — Replace with your Component Name CONNECT BY PRIOR PORTAL_PRNTOBJNAME […]

Quickly Change Translate Values from PIA

You might know that you can modify translate values for PeopleSoft field from Application Designer by simply opening the field properties and navigating to ‘Translate Values’ tab. To perform this action, you need to have access to application designer. But did you know you could do the same from PIA very quickly? Yes, you can […]

Faster Way to find solution on Oracle Support

Have your tried to search for a solution on Oracle Support but you get similar search results even if you change your search term? Not sure if it happened with you but it has sure happened a lot with us. Looks like Oracle has few top results (may be popular) that are ranked higher than […]

Your PeopleSoft application is at a risk of getting HACKED..

Your PeopleSoft application is really at a risk of getting hacked as a security vulnerability was found recently. Due to this, any hacker can easily get into your PeopleSoft application and can access critical data such as payroll, personal info, financial information without need for a valid username and password. It’s a scary thought for […]

New Features in PeopleTools 8.56

PeopleTools 8.56 released on June 09 2017 comes with new features for development, system etc. Unlike PeopleTools 8.55 list of new features is not big but there are few changes worth noting. PeopleTools 8.56 Operating System Support PeopleTools 8.56 won’t support the following OS SuSE Linux Solarix x86-64 Linux on Z system As per Oracle, […]

PeopleTools 8.56 Certifications

Whenever you plan to upgrade PeopleSoft or any other software that is related to PeopleSoft such as Operating system, Database, Office application, you always want to check if it’s certified with version of PeopleSoft application you plan to use. This information is provided by Oracle under PeopleTools certifications. I get these questions a lot from […]

PeopleTools 8.56 is available now

On June 09 2017, Oracle released PeopleTools 8.56. It was announced on Oracle’s Blog and with links to PeopleTools 8.56 reference documents. Before you take a deep dive into PeopleTools 8.56, watch below video to understand what’s new in this latest version of PeopleTools. See : How to Install PeopleTools 8.56

PSnVision opens blank excel

PS/nVision is the reporting tool which many users love to use for reporting and its easy to use with lot of nice features. But at times when it doesn’t work, it becomes not-so-nice tool. In this post we will discuss how to fix the issue when PS/nVision opens up blank excel and doesn’t show the output. […]

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

Difference between PeopleSoft Cloud Architecture and PeopleSoft Cloud Manager

It’s very easy for someone to get confused with PeopleSoft Cloud Architecture and PeopleSoft Cloud Manager but both have really simple explanation. One is referred to the set of features use to get cloud like features and another is used to move and deploy in-house PeopleSoft environments to Oracle Cloud. Difference between PeopleSoft Cloud Architecture […]

What is PeopleSoft Cloud Manager?

PeopleSoft Cloud Manager (PCM) is the latest feature offered by Oracle for PeopleSoft customers. It was made publicly available in Feb 2017. PeopleSoft Cloud Manager is based on the similar principle that were used by PCA (PeopleSoft Cloud Architecture). PCA allowed customers to take benefit of cloud like features such as dynamic scaling and quick […]

What is Puppet and what’s its significance in PeopleSoft?

If you’re familiar with PeopleTools 8.55 , then you must have heard about DPKs. DPK are the deployment kits which automates the installation and configuration of PS environment. DPK uses Puppet and Hiera for performing these automation and configuration tasks. What is Puppet? Puppet is an open source configuration management tool and produced by Puppet […]

What is PeopleSoft DPK?

With release of PeopleTools 8.55, Oracle introduced the concept of DPK i.e. Deployment Kits. Before we discuss about DPKs, we need to learn about how PeopleSoft system works. You might already know that PeopleSoft architecture comprises of different layers i.e. Database Server, Application Server, Web Server and Process Scheduler. When you deploy a PS environment, […]

« Previous 1 2 3 4 5 … 10 Next »