My Oracle Support Banner

Error (SQR 1501) when Running EEO-1 Job Analysis (PER017) Report with Employees in New Ethnic Groups (Doc ID 2060721.1)

Last updated on FEBRUARY 15, 2018

Applies to:

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


When attempting to Run EEO-1 Job Analysis Report, the following error occurs:

EEO-1 Job Analysis Report
  $Estab: 1064
(SQR 1501) Field element out of range (-1) for array 'workforce-array', field 'column', on line 721.

SQR for PeopleSoft: Program Aborting.

The issue can be reproduced at will with the following steps:
1. Navigation: Main Menu > Workforce Monitoring > Meet Regulatory Rqmts > EEO Reports > EEO-1 Job Analysis
2. Run report for Establishment 1064
3. Go to Process Monitor and note process runs to Error


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.