PeopleSoft Basics – PeopleSoft Tutorial

New features in Process Scheduler for PeopleTools 8.57

PeopleTools 8.57 has several new updates to process scheduler as well. These are not major updates but small changes that can help in day to day activities. Here are the changes to PeopleSoft process scheduler in PeopleTools 8.57. Report Distribution to network share Report Distribution currently supports moving reports to FTP, FTPS, SFTP, HTTP, HTTPS […]

IBM ILOG CPLEX in PeopleSoft

Few days ago when PeopleTools 8.57 was made available for everyone on Oracle Software delivery cloud (formerly known as edelivery), I downloaded the install files for PeopleTools 8.57. During the download I noticed a new setup file – V980877-01.zip. This zip file was for ILOG CPLEX 12.7.1 for PeopleTools 8.57. As I wasn’t sure what […]

5 fairly new terms in PeopleSoft applications you may not know about

In last few years, PeopleSoft technology has evolved a lot with addition of new tools, techniques and processes. If you haven’t been paying attention and are still working on old PeopleTools then you’re missing a lot on these exciting new features such as Fluid, Classic Plus, PUM , Elastic search etc. Introduction of all these […]

7 things every PeopleSoft consultant should know to have command in PeopleSoft

Role of a PeopleSoft consultant has changed over the years. Not only you have to be an expert in at least one area, but you must also be familiar with other PeopleSoft skills. I know many PeopleSoft consultants getting laid off because they couldn’t adapt to the changing technology. I’ve compiled a list of 7 […]

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

What is PeopleSoft Remote Cobol Call?

Not all the PeopleSoft modules use Cobol and even those which use Cobols — not all of them use the Remote Call. PeopleSoft Cobol programs that use remote call can be found in NA Payroll, FSCM etc. PeopleSoft Remote Call programs can be frustrating at times. Sometimes they may break for no reason. And of […]

How to Verify if PeopleTools Install was Unicode or Non-Unicode

When you install PeopleTools, you’re asked whether the database is Unicode or Non-Unicode. Many-a-times, people make an incorrect selection because of incorrect information they had (I’ve heard comments like “I thought the database is Unicode but it turned out that production database was created as Unicode but the development database was created as Non-Unicode.” There […]

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

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

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

Archive

Quick hack to find information faster on Oracle Support

Application Engine new features in PeopleTools 8.57

4 Frameworks to get the most out of your PeopleSoft applications