Organization Tree Performance Issue in HCM 9.0 and 9.1 (Doc ID 662209.1)

Last updated on NOVEMBER 23, 2015

Applies to:

PeopleSoft Enterprise HRMS Human Resources - Version 9 to 9.1 [Release 9]
Information in this document applies to any platform.

This document was previously published as Customer Connection Solution 201069447


***Checked for relevance on 25-Nov-2013***


Symptoms

System is timing out with an error "Return: 3113 - end-of-file on communication channel" when trying to access the Organizational Development > Position Management > Maintain Position Budgets > Add/Update, add Department, Job Code and click search.

Org Tree performance contains 48000 units, because of this the performance of the systems goes down to unusable! For example Security Program SCRTY_CLSUPD runs for 3 hours without ending, timeout in search dialogs for JOB, POSITION DATA. HRMS and Campus Solutions 9.00 MP2. Oracle 10 with Tools Version 8.49.09

When customer run the standard job "Refresh SJT_CLASS_ALL" that job fails with a time-out, presumably because of the huge amount of data it needs to process. The customer had a closer look at the Application Engine program SCRTY_CLSUPD  and adjusted the SQL code of SQL object in SCRTY_CLSUPD Action: 30ForSe2 Step: Step01. As a result the program now finishes within a few minutes and the data seems to look okay.

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