Prashant

Author Archives: Prashant

Find Size of PeopleSoft Tables and indexes [SQL]

What is the biggest pain for PeopleSoft Admins/DBA or any PeopleSoft consultant supporting the application? That’s when performance of PeopleSoft application is really sluggish. There are hundreds of things that could go wrong and one of those is directly related to size of your PeopleSoft database. PeopleSoft database consists of PeopleSoft Tables, indexes and few other objects […]

Continue reading
1

PeopleSoft Jobs – PeopleSoft Interview Questions Set # 01

Looking for a PeopleSoft job? We’re here to help. We’ve compiled a huge database of PeopleSoft interview questions, which will help you sail through any interview for PeopleSoft jobs. The questions in this and other posts on “PeopleSoft Interview Questions” are good to know irrespective of whether you’re looking for a PeopleSoft developer jobs, PeopleSoft […]

Continue reading
6

New Features in PeopleTools 8.57

This post includes concise information about the new features in PeopleTools 8.57. We will post about these features in detail in other posts for PeopleTools 8.57. Below is based on comparison of features between PeopleTools 8.56 and PeopleTools 8.57.   Quick Navigation Application DesignerApplication EngineBI PublisherIntegration BrokerPeopleCodePeopleSoft Deployment PackagesFluid User InterfacePivot GridPortal TechnologyProcess SchedulerSearchSecurity AdministrationSystem and Server […]

Continue reading

Quickest way to find hidden portal objects [SQL]

You can hide PeopleSoft portal objects (e.g. content reference) from PeopleSoft Navigation. This can be done by navigating to ‘Structure and Content’ and selecting  the checkbox ‘Hide from portal navigation’. Navigate to PeopleTools > Portal > Structure and Content  Incase you don’t have access to this page to view the configuration, you can check this […]

Continue reading

How to find current status of PeopleSoft process scheduler

Process Scheduler plays an important role in PeopleSoft application by performing batch transactions & running processes and reports. Due to its significance in PeopleSoft architecture, availability of process scheduler become critical. Most of the organizations deploy multiple process scheduler to handle the requests. Still at times, process scheduler can behave erratically (specially when running on […]

Continue reading

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

Change PeopleSoft Access ID & Password in PeopleTools 8.56 & 8.55

PeopleSoft Access ID also known as Owner ID is the owner of PeopleSoft tables. In Oracle, it’s commonly used as ‘SYSADM’  and ‘sa’ for SQL server. All PeopleSoft tables belongs to this user id and this ID is created during the database creation. You may need to change password for PeopleSoft access id /owner id […]

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

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