The sql will identify duplicate objects in different application designer projects to eliminate duplicate work by developers.
You will find the SQL very handy during the analysis phase of a peoplesoft upgrade project. You 1st need to identify your projects and run compare and report through application designer. This will flag objects in the source database that are different than the target database to be marked for upgrade.
SQL that I find useful in many occasions. It will return a list of permissions that are assigned to a specific user.
Click here -> Compare Report in HTML format to see how you can generate compare reports in HTML or CSV format.
The education presentations from COLLABORATE 08 will be available on questdirect.org website until May 15th.
Filter on PeopleSoft sessions and download the ones you are interested in. Here is the link.
In this post I will show you how to trace an application engine process using the Process Definitions without setting the trace in the Process Scheduler’s psprcs.cfg configuration file.
Navigate to the process definition of the application engine that you would like to trace (PeopleTools > Process Scheduler > Processes). Go to the Overrride Options tab, and from the Parameter List drop down select Append, and in the edit box next to it add the following line:
A quick function that will allow you to verify if a specific vendor has any pending transaction(s).
The SendMail function in PeopleSoft uses the SMTP server to send emails. The first thing to do when troubleshooting problems with emails not being sent is to make sure your SMTP server is up and running. In this post, I will show you how to verify if you can connect to the SMTP server as well as manually sending an email!
Note: I’m using Unix Telnet to connect to the SMTP sever.
Let’s get started by trying to connect to the server:
Open a telnet session and login to the server box you would like to test sending emails from. I will be logging in to a DEV environment.
You can use the SendMail PeopleCode function to send emails from within PeopleCode. You can also call this function from an Application Engine.
Note: Make sure your SMTP server is configured properly or the SendMail function will fail.
One of the requirements I have lately is to compare table data between two different environments (Development and Test).
The Oracle SQL below compares table1 that has 2 key fields and 3 regular fields.
Note: For the SQL below to work, your password needs to be the same in both environments. If not, then
a connection using the below will not be possible.
Here is the SQL to compare the differences in the data in different tables with same structure. Will be helpful for comparing the data between databases. This works in MS SQL Server if both databases are on same server or if there is a linked server configured for the other database.
|how to send hyperlink with email in application engine program.||PeopleSoft Technical||06/13/2013 - 12:55am|
|Saving records||PeopleSoft Technical||06/04/2013 - 11:11am|
|can we alter a trigger in DB2 to add a new column||SQL & PL/SQL||05/29/2013 - 1:31am|
|Required Peoplesoft HRMS Functional Training||PeopleSoft Functional||05/07/2013 - 10:29pm|