How the Integration Broker Handles Incoming Requests (Understanding PeopleSoft Integration Broker Part 2)
Let’s discuss how the integration broker handles incoming requests. It is assumed that you’ve already read the Part 1 of this series – Understanding PeopleSoft Integration Broker. There is a series of events which happen when a PeopleSoft Integration Broker receives incoming requests. 1) When a request is received by a Listening Connector, the first […]
Continue reading
1
Understanding PeopleSoft Integration Broker – Introduction (Part 1)
PeopleSoft Integration Broker can be daunting for those who are new to Integration Broker and hence, this post has been written with the intend of helping those who want to learn PeopleSoft Integration Broker. Skills for understanding PeopleSoft Integration Broker are PeopleTools, PeopleCode and Application Engine are a must. Additional experience in XML, SOAP, HTTP, […]
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 readingSyntel PS Admin Interview Questions
Below is the list of questions which are submitted by one of our readers who gave interview in Syntel for a PeopleSoft Admin role. These questions were actual interview questions that were asked.. Tell me something about your experience Current environment Have you worked on PeopleTools Upgrade How often do you do monthly install in […]
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