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…
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| [Domain Settings] | |
| ;========================================================================= | |
| ; General settings for this Application Server. | |
| ;========================================================================= | |
| ;------------------------------------------------------------------------- | |
| ; Use Old Download To Excel Behavior - 0 New Behavior - 1 | |
| ; | |
| FormatIntsInCharFldsForDownloadToExcel=0 |
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.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| declare | |
| v_elmnode varchar2(8); | |
| v_hrnode varchar2(8); | |
| v_fsnode varchar2(8); | |
| begin | |
| v_elmnode := '&ELMNodeName'; | |
| v_hrnode := '&HRNodeName'; | |
| v_fsnode := '&FSNodeName'; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /usr/sbin/oraclevm-template --cleanup | |
| /usr/sbin/oraclevm-template --enable |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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
/ 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.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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. |