My Oracle Support Banner

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.

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.