Haven't posted much about Excel but this one has been the most common request from business users.
This is a macro to override the "Save As" filename.
Haven't posted much about Excel but this one has been the most common request from business users.
This is a macro to override the "Save As" filename.
This SQL will search for filenames that contain characters other than
I've been running into situations where our application engines are not clearing the temp tables even after process instance has been deleted.
Also, multiple occurrences of the process halting for no reason.
Oracle's workaround is to clear the temp tables and restart the process.
But which temp tables do you clear?
Try this script.
I want to import PeopleSoft configuration files without going through the UI.
Let's use a .bat file.
I want to remove worklist entries which have dead links.
But they only gave me a screenshot of the worklist page.
I want to export all my query results from Oracle SQL Developer
I have two (2) options.
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.
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:
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.
%EffdtCheck %InsertSelect %InsertValues %Join %KeyEqual %SQL %SelectAll %SelectDistinct %SelectByKey %SelectByKeyEffDt
Now for some examples...
I need two things today.
Step by step guide below.
PeopleTools Object Type Reference
Jump to see the entire list.