Fluid Candidate Gateway On PUM22 Is Hung While Connecting - Slow Response Time While Performing Full Table Scan On PS_HRS_APPLICANT (Doc ID 2287763.1)

Last updated on JULY 18, 2017

Applies to:

PeopleSoft Enterprise HCM Candidate Gateway - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

On : 9.2 version, Performance

Response time connecting to TAM Candidate Gateway is seriously degrading after applying PUM22
When executing component HRS_CG_SEARCH_FL and selecting a large number (e.g. 3+ million rows)  from PS_HRS_APPLICANT, Application Servers have become non-responsive.
PSAPPSRV servers are seen to be queueing.

EXPECTED BEHAVIOR
Average response time in Candidate Gateway should be in the 1-3 second timeframe as seen in the pre-PUM22 environments.

STEPS
The issue can be reproduced at will with the following steps:
1. login to the Candidate Gateway
2. observe that connections are spinning and the environment appears hung



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