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

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

Continue reading

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

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
7

PeopleTools 8.56: How to Install PeopleTools 8.56

Oracle finally released the latest version of PeopleTools i.e. PeopleTools 8.56 on June 90, 2017. The biggest feature of PeopleTools 8.56 is Elasticsearch, which was released ahead of schedule in PeopleTools 8.55.11 itself. Apart from Elasticsearch, there are some nice features likes Classic+, which we’ll explore in upcoming posts. This post is to help you install […]

Continue reading

How to Install PowerShell on Oracle Linux, RHEL and CentOS

Windows PowerShell is getting more common now-a-days with Oracle PeopleSoft DPKs needing you to run PowerShell scripts. In fact, it is not just limited to PeopleSoft – it is pretty common with Administrators, who manage Linux, Windows and networked clients. Way back in 2001, ex-Microsoft CEO Steve Ballmer branded Linux “a cancer” during the height […]

Continue reading