Archive

Category Archives for "PeopleSoft Basics"

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

Continue reading

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

Continue reading

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

Continue reading
2

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

Continue reading

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

Continue reading
1

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

Continue reading

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

Continue reading

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

Continue reading

ChartField Request and Approval

In PeopleSoft FSCM, ‘ChartField Request’  page gives an option to request any additions or modifications of the ChartField values and to submit them for approval. Once approved, the process saves the new ChartField value to the corresponding base tables. Chartfield Request and Approval option will provide an effective and efficient way of managing ChartField. It’ll […]

Continue reading

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

Continue reading

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

Continue reading
1 2 3