If you have supported PeopleSoft for long enough, you might have checked the Process Monitor to find many processes that continue to have the Distribution Status as “posting” even after the process has run to Success. This is especially true when you have restarted a process.
In such a situation, how would you quickly retrieve a file that was generated by the successful process?
PeopleSoft generates all files that are to be shown in the Process Monitor, to a temporary folder. After a successful post, the temporary folder is deleted. This simple SQL statement will tell you the location (on the server) of this temporary folder so that you can pick the file up from there.
SELECT PRCSNAME, PRCSTYPE, PRCSOUTPUTDIR FROM PS_CDM_LIST WHERE PRCSINSTANCE = 'Your Process Instance'
Alternatively, you can change the status to Not Posted using the below scripts and then use the Re-send Content Radio button to force posting.
UPDATE PSPRCSRQST SET DISTSTATUS = 4 WHERE PRCSINSTANCE = 'Your Process Instance'; UPDATE PSPRCSQUE SET DISTSTATUS = 4 WHERE PRCSINSTANCE = 'Your Process Instance'; UPDATE PS_CDM_LIST SET DISTSTATUS = 4 WHERE PRCSINSTANCE = 'Your Process Instance';