EGL9.2: Best Practice to Increase Temp Table Instances for FS_BP and FS_BP_PROC and Other Internal AE Calls.
(Doc ID 2911086.1)
Last updated on NOVEMBER 23, 2022
Applies to:
PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
Goal
There is a requirement to increase the number of temp table instances for Budget Checking processes, with the goal that base tables should never be used for any budget checking.
What is best practice for increasing the temp table instances when it comes to FS_BP and FS_BP_PROC?
Do 'parent' app engines must have the number of instances defined?
Is it sufficient to have the 'called' app engines have the number of instances defined?
For example:
FS_BP, EX_BCHK_ALL, EX_BDCK_ER, CM_CSTACCTG all have calls to FS_BP_PROC.
Do the instance counts need to be updated on just FS_BP_PROC (currently 0), or do they need to be updated on all 4 of the above parent processes?
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Goal |
Solution |