Author Archives: Prashant
Author Archives: Prashant
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 readingEver wondered when a PeopleSoft table was last built / altered or when its database stats were gathered ? Many times, you need to know that information to analyze what’s happening with a table. For example, your table may not be working correctly or the performance may be degraded. You may want to check when was the […]
Continue readingLooking 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 readingThis 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 readingOracle recently released highlight video for PeopleTools 8.57. At first PT8.57 will be available for customers on Oracle Cloud. Below is the video that was published on Oracle’s Youtube Channel. Let us know in the comments section what do you think about these new features.
Continue readingYou 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 readingRecurrences as the name suggests are used to run PeopleSoft processes repeatedly. You could create multiple recurrence selecting different date & time to create a schedule such as daily, monthly etc. Once a recurrence is created, it can be used to schedule a process to run multiple times based on the recurrence settings. If you’re […]
Continue readingProcess 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 readingEver 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 readingPeopleSoft 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 readingPS query is a powerful tool for end users to fetch data from PeopleSoft application and users can create public and private queries. Although public queries can be viewed by anyone having access to Query Viewer or Query Manager but private queries can only be seen by the user who created them. But there could […]
Continue readingHow 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 […]
Continue readingSo you created an awesome private query and now you want to share it with another user. Since it’s a private query only the user id who created the query will have access to it. One way is to change the ps query from private to public. By making it public, everyone who has access […]
Continue readingThere is a general difference between public and private query. As the name suggests, public query is available for everyone whereas private query can be used by the person who created it. But there could be a scenario, where you want to transfer private query of one user to another. This could happen when someone […]
Continue readingIf 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 […]
Continue readingYou 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 readingYou 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 readingHave 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