Transaction Management SAD_SL_SMP / SCC_SL_SMP Process Performance Issue (Doc ID 1989124.1)

Last updated on JANUARY 30, 2017

Applies to:

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

Symptoms

ACTUAL BEHAVIOR  
---------------------
The SAD_SL_SMP / SCC_SL_SMP runs very slowly. When running the CTM process to promote test scores to production records for one university it took just shy of 4 hours to "process" 5396 records (732 matches were found and test scores loaded from the 5396 records processed) in a development environment. In production their application engine staging table for ACT currently holds some 100,000 plus records and the application engine search/match/post process takes approx. 20 minutes to run. They also load IELTS scores via PDL in this same production environment. That staging record currently holds 1186 records and it takes approx. 16 minutes for the CTM process to run in PROD. If they extrapolate the process times from their current IELTS load which is a much lower volume test, as far as the number of records received, than ACT, there is concern about the performance issue that a large test, such as ACT will cause. They can receive upwards of 20,000 ACT records per year.

EXPECTED BEHAVIOR
------------------------
Expect faster processing.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run the Transaction Management process to perform search/match and post staging data by selecting the Prospect Data Load - SMP or SAD_SL_SMP application engine.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, this will impact the performance of production loads of external test scores.

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