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

Continue reading
3

Cryptojacked PeopleSoft Instances

Cryptojack, a recently coined verb that is not in the dictionaries yet but may soon find its place! The word Cryptojack has been derived from the word hijack, which as per dictionary means: to force someone to give you control of a vehicle, aircraft, or ship that is in the middle of a trip. Someone who hijacks someone else’s ideas or plans uses those ideas and claims to have created them. Several real life incidents […]

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

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