Skip to content

Instantly share code, notes, and snippets.

@psadmin-io
psadmin-io / downloadToExcel.cfg
Last active August 29, 2015 14:27
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…
[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 August 29, 2015 14:26
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.
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 July 20, 2015 23:34
Reset PeopleSoft Image VM
/usr/sbin/oraclevm-template --cleanup
/usr/sbin/oraclevm-template --enable
@psadmin-io
psadmin-io / LM92U009.txt
Last active August 29, 2015 14:23
Sample Input file for wget-batch.bat
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 July 28, 2022 15:52
A modified version of Oracle's wget.sh script to download PeopleSoft Images from Oracle Support.
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.