ePerformance - Create Documents Process Fails
Last updated on MARCH 19, 2018
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 ****
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.
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.
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