5
PeopleTools 8.53 : Softwares Required to Install HCM 9.2 on Windows 7
So you’ve finally decided to install Oracle’s latest PeopleSoft Version 9.2. That’s a good thing and in this article you will get details of the software that you would need to start installing HCM9.2 with PeopleTools 8.53 on Windows 7. Soon we will be publishing articles on steps that include installation of HCM9.2. Requirement: Application […]
Continue reading(SQR 28) Cannot access the initialization file
When you try to run sqr.exe from a client workstation, you may encounter this error (SQR 28) Cannot access the initialization file xxx\pssqr.ini This error is usually encountered when you try to run SQR on the Client Workstation. To run a SQR from a client workstation, you need to navigate to PS_HOME\bin\sqr\ORA\binw and run sqrw.exe When […]
Continue readingPeopleTools 8.53 – How to Uninstall PeopleSoft PIA from IBM Websphere
You might need to uninstal the PeopleSoft Pure Internet Architecture from IBM WebSphere. In PeopleTools 8.53, you cannot uninstall PeopleSoft PIA simply by deleting <PIA_HOME>\webserv\<profile_name>, without uninstalling it from IBM WebSphere Administration Console. If you happen to delete <PIA_HOME>\webserv\<profile_name>, the IBM WebSphere registry becomes corrupt, and subsequent attempts to install PeopleSoft PIA will fail. The […]
Continue reading
3
How to Find PeopleSoft Processes/PSJobs in a Recurrence
Do 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 readingQuery result set too large, (124,87). Result of (SQL Fetch) is over the maximum result size specified for the application server.
One of the common errors encountered while running a PSQuery is: “Query result set too large, (124,87). Result of (SQL Fetch) is over the maximum result size specified for the application server.“ As the error message suggests, this error has been caused due to huge result size, which the application server is unable to render […]
Continue reading