We deal with that same issue, and it's a Peoplesoft thing. We send and receive files through ssh and sftp servers connected to the app servers. We just do a file rename on the linux box once the file is generated and moved using linux command line scripts or directly within a linux job. The developers could write the file rename into the Peoplesoft process itself, but that is a customization to a delivered process or a change to a custom process. We have found it to be a quicker and easier process to just rename it when we send it out.
We do have some run controls in PS that have a filename field where we can dictate the filename either when we build the run control or at runtime we pass a filename value using the ps_modify_runcontrol step in Automic. Most of those are custom processes though and were created or changed to include that filename field when the filename needs to include a specific value for the academic term we are running for. I'm pretty sure you are stuck doing a rename before sending it out unless you can get them to change the PS process itself. :(
------------------------------
Christine Bauder
Assistant Director of Production Services
University of Colorado
Colorado
------------------------------
Original Message:
Sent: Dec 04, 2024 04:42 PM
From: Michele Adamski
Subject: Renaming PeopleSoft output
I feel like I've asked this question here before, but...
I am running a PeopleSoft query that produces a PDF file and emails it. However, the user is dissatisfied with the name of the file, which is just named with the run control ID and the process instance number. If possible, he wants a specific name and variable date.
I've searched on "PS_RUN_PROCESS" and I haven't found any extended options to change the file name. My next step is going to be locating the report on process scheduler server and writing a PowerShell to rename the file and send it to the user, but I thought I'd check here first.
Any input would be appreciated. Thanks!
