This is my first "fun" post on the site. I've been thinking about this and decided that too much technical stuff just hurts sometimes and you all techies out there need a break and a laugh! So here is a little movie that I found to be funny.
Here is a quick Application Engine section that looks up user's email addresses under a certain ROLE and sends an email notification regarding, well, what ever you'd like.
First, you would need a "Do Select" step to loop through the email addresses (if more than one) and call the PeopleCode step below it to send the email. Your Do Select should have the following SQL:
This was kind of interesting to figure out. What I was going after is the following. I had a drop down box on a page that shows some Business Units. The values however need to be dynamic and change depending on the user viewing/accessing the page.
For example, user1 should only see 52024, 12456 but user2 should be allowed to see 52024, 12456, 45648, and 10235.
To accomplish this I've created a table to store values for each user (lets call it TABLE_1). TABLE_1 has 2 fields (oprid, and business_unit). So now, we have 2 users on the table along with their associated business units.
The 2nd step is to create the dynamic view to pull business units specific to each user. The view will only have one field and that is the business_unit field.
I have written this macro a while back and thought it would be of some benefit for some of you.
I've created a button on an excel sheet that when clicked will fire an excel macro to open the well familiar windows "Browse Save as" box and allow the user to save the file to his/her desired location.
The macro limits the "Save as type" to a .txt file format.
Here is the code:
A very handy PeopleCode function to check for a user role(s) and perform specific actions depending on the value returned.
Generating a sequence number isn't that hard. All what you need to type is the following:
Select from dual to increment your sequence number by one.
What if you want to create a sequence that increments by 3?
The SQL below will order months from Jan to Dec (01 to 12).
Here is a quick SQL snippet to show some Database information. I'm only pulling Database name, date created, database owner Id and database long name.
Here is how you can FTP a file from your windows client machine to a Unix server box.
Open the command line by going to Start > Run and type cmd.
You should see something link this:
This is another quick SQL snippet that I find useful. When would you use it?
Well, you forgot a certain record name, but you know that the record has EMPLID, NAME, EMPL_REC fields on it.
You can query the database to find out what records have the fields you are looking for.
|Peoplesoft Web PIA installation||PeopleSoft Technical||03/15/2017 - 2:20am|
|Populate Multiple Grids on a same Page with diff output based on conditions.||PeopleSoft Technical||03/04/2017 - 1:35pm|
|Updating a row using Peoplecode - Component Interface.||PeopleSoft Technical||02/21/2017 - 11:26pm|
|To load CSV file data into staging table without using file layout||PeopleSoft Technical||01/15/2017 - 8:31am|