Financial Management - PSFT (MOSC)

MOSC Banner

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?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center