Performance Issue With Prospect Delete By Batch Process in ADPRSDEL.SQR (Doc ID 2229898.1)

Last updated on FEBRUARY 03, 2017

Applies to:

PeopleSoft Enterprise CS Recruiting and Admissions - Version 9 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
-----------------------------
System has performance degradation with Prospect Delete by Batch Process.

The process is unusable due to the performance issues that it has. A successful population selection query of 300 rows was used in the Pop Select process for the 'Prospect Delete by Batch'. The prospect delete process did run to success; however, for the 299 students it selected, it takes over 5 hours to run. When reducing the query to only select 100 students, the process took 1.5 hours to run. 

EXPECTED BEHAVIOR
----------------------------------
Expect the prospect delete by batch process to take much less time to complete.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Navigate to Student Recruiting > Delete Prospects > Prospect Delete by Batch (AE SAD_PRS_DEL). Select Population Selection, PS Query and enter/select query name.
2. Save run control and click Run, then OK.
3. Go to Prospect Delete Process and select Run, Publish Prospect Delete (EIPPRSDL job - SQR ADPRSDEL and AE SCC_BAT_RPLY), then OK.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:

Due to this issue, users are unable to delete groups of prospects in a timely manner.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms