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


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