Easy Import of Config File

I want to import PeopleSoft configuration files without going through the UI.

Let's use a .bat file.

Remove Dead Worklist Entries

I want to remove worklist entries which have dead links.

But they only gave me a screenshot of the worklist page.

1. Get OPRID of recipient
2. Get OPRID of sender. If you look at the screenshot, it's the guy under FROM column.
3. Get EOAWTHREAD_ID. If worklist is delivered, look at the 2nd value of the Link column.
4. Execute SQL below.

Export All Results from ORACLE SQL DEVELOPER

I want to export all my query results from Oracle SQL Developer

I have two (2) options.

1. Use /*csv*/
2. CTRL + End

Oracle SQL Developer
Version 2.1.1.64
Build MAIN-64.65

SELECT /*csv*/ *
FROM PS_JOB

Or just click on query results and click Ctrl + End.

Use SUBSELECT in PS Query Expression

I encountered this error when I used a subselect in my PSQuery expression.

FROM clauses are not allowed in expressions (50,536)
SQL error. Stmt #: 5682 Error Position: 107 Return: 936 - ORA-00936: missing expression
A SQL error occurred. Please consult your system log for details.
Error in running query because of SQL Error, Code=936, Message=ORA-00936: missing expression (50,380)

Here's the workaround:

SQL To Identify Actual Customized PeopleCode

For some reason, the demo environment is not up to date with all the patches and bundles applied to production.

I need to do a full compare of all the PeopleCode in the system and I need to identify which ones are actual customizations vs patches.

1. Create the compare report.
2. Run this SQL.

Top 10 Awesome Meta-SQL

Here is a list of my top 10 awesome meta-sql that makes my lazy life easier.

%EffdtCheck
%InsertSelect
%InsertValues
%Join
%KeyEqual
%SQL
%SelectAll
%SelectDistinct
%SelectByKey
%SelectByKeyEffDt

Now for some examples...

Create Tooltips + Hyperlink To Another Component

I need two things today.

1. Create a link for every row in the grid. Each link will transfer the page to a new component and use the search keys automatically.
2. Create a hover or mouseover label for the links.

Step by step guide below.

Complete List of PeopleTools Object Types

PeopleTools Object Type Reference

Jump to see the entire list.

Read Multiple Files Using App Engine and FileLayout

I want to process several files using PeopleSoft's filelayout.

Assuming you have created your Application Engine, here's a step by step guide.

SQL to get Child Records

I want a list of PS_JOB's child record.

SELECT RECNAME 
FROM PSRECDEFN
CONNECT BY PRIOR RECNAME = PARENTRECNAME
START WITH PARENTRECNAME = 'Record Name Here';

Send Mail with Multiple Attachments using PT_MCF_MAIL

Using an Application Engine, I want to attach multiple attachments to an outgoing email.

Combine both for Record PeopleCode usage.