Budget Checking (FS_BP) Performance Question
PeopleSoft Financials 9.2.45 - Tools 8.60.11 - Commitment Control
For the FS_BP process (and its called app engines), we are wondering if there are any customers that have set the Re-Use to "Y" for all of the budget checking processes. Per our admins and DBAs, somewhere upwards of 40% of processing of our budget checking is caused by the database having to regenerate SQLs over and over again, rather than re-using the same SQL, and passing bind variables into that SQL (i.e. re-use = 'Y').
We are discussing the possibility of setting all of the re-use flags to "Yes" during our next PUM implementation and testing to see if there are negative effects - but we wanted to see if anyone else has done anything like this?