Population Select Bind Records Contain EFFDT Redundancy Which Slows the Performance of Processes that Use These Records
(Doc ID 2798878.1)
Last updated on FEBRUARY 01, 2024
Applies to:
PeopleSoft Enterprise CS Campus Community - Version 9.2 and laterPeopleSoft Enterprise CS Financial Aid - Version 9.2 and later
Information in this document applies to any platform.
Symptoms
Population Select bind records use effective dated logic in a table that is a view and therefore has the effective dated logic already included. The following SQL, from PS_SCC_PS_FINA_BND, is an example:
PS_SCC_PRI_NAME_VW, being a view, already has the EFFDT logic built into it, so adding it again reduces the efficiency of that bind and can make any query attached to that bind take a very long time to run.
Cause
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
| Symptoms |
| Cause |
| Solution |
| References |