In June, UCSF IT implemented several technical enhancements to PeopleSoft Financials to improve nightly batch processing times. This effort is part of an ongoing project to optimize the PeopleSoft database to improve the application’s performance and reduce downstream delays, including the availability of data in MyReports. Recent modifications to PeopleSoft include new indexes, partitioning, SQL rewrites, and additional tools for database administration.
As a result, we are seeing noticeable improvements in the timing of the nightly refresh batch completion and the availability of the prior day’s data in MyReports. The MyReports team will continue to work with IT partners to monitor and look for further opportunities to reduce processing times.
Keep in mind that longer than usual refresh times are expected between the Prelim and Final Close when two accounting periods are open. On days when refresh processing will not finish before 7 a.m., look for alerts within MyReports to stay apprised of the refresh status. If you have used the MyReports scheduling feature to automate production and delivery of your reports after the June Prelim, Interim, and Final Close, reports will be delivered after the corresponding nightly refresh has completed.