Affiliations Framework Batch Process SCC_AFL_RUN Performance Degradation

(Doc ID 2240312.1)

Last updated on MAY 09, 2017

Applies to:

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


When running the Affiliations Batch Process (App Engine SCC_AFL_RUN), a poor performance issue is encountered when using population selection to identify active employees or who has a job record.

The Affiliations Batch Process runs within a reasonable time frame.

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

1. Enable Constituent Web Services and WORKFORCE_SYNC using PeopleTools Integration Broker.
2. Set up required affiliation-related setup pages.
3. Develop query for use as population selection.
4. Run the Affiliations Batch Process by navigating to Campus Community, Affiliations, Affiliation Batch Processing

The issue has the following business impact:

Due to this issue, users cannot implement the Slate-PeopleSoft interface project in which the File Parser and CTM/ATM frameworks are being used.


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