ePerformance - Create Documents Process Fails (Doc ID 661705.1)

Last updated on JULY 11, 2016

Applies to:

PeopleSoft Enterprise HRMS ePerformance - Version 8.8 to 9 [Release 8.8 to 9]
Information in this document applies to any platform.
**** Checked for Relevance on 17-08-2012 ****

Symptoms


When several managers (e.g. > 5) simultaneously launch the process in Manager Self Service, Performance  Management, Performance Document, Create Documents for their direct reports, some of the transactions fail after several minutes with time-out.  Managers cannot expect to have to coordinate when they create these documents for their employees at the specific time of year when the company world wide is performing the Performance Reviews

Analysis of database transactions show an 'exclusive' lock is maintained on EP_INSTALLATION for update of EP_LAST_APPR_ID.

This means that only one request can proceed at a given time and all other requests wait until first process is complete. In the case where there are several direct-reports (e.g. >20 employees) for a manager, then the Create Document process can last several minutes and thus other requests eventually timeout.

Additional Analysis
Looking at a trace of the PeopleCode behind the Create Document reveals the following function call in EP_FUNCTIONS.AppraisalCreation.OnExecute;
&AppraisalId = GetNextNumberWithGaps(EP_INSTALLATION.EP_LAST_APPR_ID, 99999999, 1);

Reference to PeopleBooks states that it may be better to use GetNextNumberWithGapsCommit instead of GetNextNumberWithGaps.

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