E-BI/XMLP/HCM: BI/XML Publisher Self Service W2 Very Slow Performance Cause CPUs at 100% (Doc ID 1050806.1)

Last updated on MARCH 25, 2013

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.49 and later
PeopleSoft Enterprise HRMS Payroll for North America - Version 9 and later
Information in this document applies to any platform.

Symptoms

On PeopleTools 8.49.18 and HRMS 9, enabling W2s using XMLP in the HCM 9.0 Self Service application for 25,000 users has caused the host CPUs to reach and remain at 100%.

It was believed that the environment was sized properly to accommodate the activities of 25,000 self service users executing the W2 XMLP application.

The issue can be reproduced at will with the following steps:
1. Enable the W2 self-service application for 25,000 users
2. Once users begin accessing the application, observe CPU utilization goes to 100% and remains there, which prevents any further access to the system, and effective use of the system to stop.

Due to this issue, users cannot create W2s using the self service application, which is a Federally mandated reporting application. Additionally, the entire system becomes unavailable to all users because it is overwhelmed by a few SS W2s.

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