Population Select Bind Records Contain EFFDT Redundancy Which Slows the Performance of Processes that Use These Records
(Doc ID 2798878.1)
Last updated on OCTOBER 12, 2021
Applies to:PeopleSoft Enterprise CS Financial Aid - Version 9.2 and later
PeopleSoft Enterprise CS Campus Community - Version 9.2 and later
Information in this document applies to any platform.
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.
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