Want to find out the queries that are set to run on recurrence? Here is a SQL that you can run.
Continue readingHere is a quick SQL that you can run to find out PeopleSoft users that are logged into PeopleSoft via PIA web login.
Continue readingWhat 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 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 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 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 readingStylesheets 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 readingIf you plan to use Oracle – the most powerful database in the world, there is one skill you need to learn anyhow whether you want to become Oracle PL/SQL programmer or Oracle database administrator. The skill is SQL. The greatest fact about learning SQL is that the skill works across databases. Even if tomorrow […]
Continue readingMany a times you come across a situation when you need to find records behind a page or records associated with a field and so on. Most of such situations arise from the need to debug an issue and find a resolution for the same. In this article you will find a few helpful SQL […]
Continue readingCommon Database Errors Following is a list of known SQL errors, and potential solutions to the problems that they represent. Known Database Error Codes Database Error Code SQL State Message Solution DB2 -803 23505 SQL0803N One or more values in the INSERT statement, UPDATE statement, or foreign key update caused by a DELETE statement are […]
Continue readingSQL Monitoring was instrumented and available for command line use in the first release of the Oracle Database 11g. The graphical user interface to monitor active running SQL made its debut in Grid Control 10.2.0.5 and Database Control 11.1.0.7. Basically, the data from the GV$ views, is aggregated and presented in a user-friendly interactive fashion […]
Continue readingWriting a good SQL helps your organization in several ways. It has a manifold effect, which many developers do not realize either because they do not care or they do not know. This about the time you can save by writing a good SQL. No need of DBAs to be involved, you can avoid urgent […]
Continue readingDo you want to find out all processes and jobs running under a particular recurrence? Use this SQL below: SELECT process_job_name, description, recurname FROM ps_prcsrecur a, (SELECT p.prcsname AS Process_Job_name, p.descr AS Description, p.recurname AS recurname FROM ps_prcsdefn p UNION SELECT jp.prcsjobame AS Process_Job_name, (SELECT j.descr FROM ps_prcsdefn j WHERE j.prcsname = jp.prcsname) AS Description, jp.recurname AS recurname FROM ps_prcsjobdefn j, ps_prcsjobitem jp WHERE j.prcsjobname = jp.prcsjobname) b WHERE b.recurname = a.recurname AND a.recurname = :1 ORDER BY 1
Continue reading