My Oracle Support Banner

Using 3C Engine To Cancel Checklists Takes 3.5 Hours To Run (Doc ID 3059207.1)

Last updated on NOVEMBER 14, 2024

Applies to:

PeopleSoft Enterprise CS Campus Community - Version 9 and later
Information in this document applies to any platform.

Symptoms

 
Pop select queries that join to the SCC_PS_ADMP_BND record run a very long time due to multiple rows being selected for the same student/application/program.
Joining  to this bind record when using the 3c engine to delete checklists may  takes hours to delete 100 student check lists.
 
The issue can be reproduced at will with the following steps:
Campus Community > 3c engine > run 3 c engine for a population of applicants using a pop select query that joins to the SCC_PS_ADMP_BND record.
 

 

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.