Skip to content

Instantly share code, notes, and snippets.

@psadmin-io
psadmin-io / downloadToExcel.cfg
Last active Aug 29, 2015
If you on PeopleTools 8.51.19, 8.52.08, or 8.53 and higher, this option can be added to you app server's config file to change how the Download to Excel feature handles numeric columns. Without this parameter set, the leading zero's in a column will disappear because excel will treat those columns as integers. This parameter changes numeric colu…
View downloadToExcel.cfg
[Domain Settings]
;=========================================================================
; General settings for this Application Server.
;=========================================================================
;-------------------------------------------------------------------------
; Use Old Download To Excel Behavior - 0 New Behavior - 1
;
FormatIntsInCharFldsForDownloadToExcel=0
@psadmin-io
psadmin-io / UpdateNodeRoutings.sql
Last active Aug 29, 2015
This script will update the node definitions and all the routings associated with those nodes in a database. The prior node name is assumed to start with the Application prefix (HR, FS, ELM), so you need to change that value to match your system. You will be prompted for the new node names.
View UpdateNodeRoutings.sql
declare
v_elmnode varchar2(8);
v_hrnode varchar2(8);
v_fsnode varchar2(8);
begin
v_elmnode := '&ELMNodeName';
v_hrnode := '&HRNodeName';
v_fsnode := '&FSNodeName';
@psadmin-io
psadmin-io / resetVM.sh
Created Jul 20, 2015
Reset PeopleSoft Image VM
View resetVM.sh
/usr/sbin/oraclevm-template --cleanup
/usr/sbin/oraclevm-template --enable
@psadmin-io
psadmin-io / LM92U009.txt
Last active Aug 29, 2015
Sample Input file for wget-batch.bat
View LM92U009.txt
https://updates.oracle.com/Orion/Services/download/ELM-920-UPD-009_OVA_1of10.zip?aru=19001523&patch_file=ELM-920-UPD-009_OVA_1of10.zip&agreement_id=147613,ELM-920-UPD-009_OVA_1of10.zip
https://updates.oracle.com/Orion/Services/download/ELM-920-UPD-009_OVA_2of10.zip?aru=19001523&patch_file=ELM-920-UPD-009_OVA_2of10.zip&agreement_id=147613,ELM-920-UPD-009_OVA_2of10.zip
https://updates.oracle.com/Orion/Services/download/ELM-920-UPD-009_OVA_3of10.zip?aru=19001523&patch_file=ELM-920-UPD-009_OVA_3of10.zip&agreement_id=147613,ELM-920-UPD-009_OVA_3of10.zip
https://updates.oracle.com/Orion/Services/download/ELM-920-UPD-009_OVA_4of10.zip?aru=19001523&patch_file=ELM-920-UPD-009_OVA_4of10.zip&agreement_id=147613,ELM-920-UPD-009_OVA_4of10.zip
https://updates.oracle.com/Orion/Services/download/ELM-920-UPD-009_OVA_5of10.zip?aru=19001523&patch_file=ELM-920-UPD-009_OVA_5of10.zip&agreement_id=147613,ELM-920-UPD-009_OVA_5of10.zip
https://updates.oracle.com/Orion/Services/download/ELM-920-UPD-009_OVA_6of10.zip?aru=19001523&patch
@psadmin-io
psadmin-io / wget-batch.bat
Last active Jul 19, 2016
A modified version of Oracle's wget.sh script to download PeopleSoft Images from Oracle Support.
View wget-batch.bat
rem ---------------------------------------------------------------------------
rem Usage: wget-batch.bat <inputFile> <email> <password>
rem
rem <inputFile> is a plain text file that has the URL and Output Filename
rem separated by a comma (no spaces)
rem
rem Dan Iverson - 2015-06-12
rem This script takes 3 parameters: inputFile, email, password.
rem Filename is a text file with URL,Filename from the Oracle wget.sh script.
rem Email and Password are your Oracle Support login credentials.