EEO1 Exceptions Report, Errors: REP0069 Internal Error, Rep57054 Job Terminated, Rep1401 Fatal Error (Doc ID 2191627.1)

Last updated on AUGUST 10, 2017

Applies to:

Oracle HRMS (US) - Version 12.1.3 to 12.2.6 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

On :  12.1.3 version, US HR Statutory Reporting

When attempting to  run the EEO Exceptions Report,  it errors out with the following error.

REP-1401: '': Fatal PL/SQL error occurred.
REP-0069: Internal error
REP-57054: In-process job terminated:Terminated with error:
REP-1401: MSG-00001: tmp008:


REP-1401: '': Fatal PL/SQL error occurred.
REP-0069: Internal error
REP-57054: In-process job terminated:Terminated with error:
REP-1401: MSG-00001: tmp008:

REP-1401: '': Fatal PL/SQL error occurred.


Report Builder: Release 10.1.2.3.0 - Production on Thu Jul 14 07:46:30 2016

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Program exited with status 1
Concurrent Manager encountered an error while running Oracle*Report for your concurrent request 6678558.

Review your concurrent request log and/or report output file for more detailed information

And from the Diagnostics from the View Request form there was an additional error

'ORA-06502 PL/SQL numeric or value error. character string buffer too small
ORA-06512 at "APPS_PER_PERUSEOX_XMLP_PKG", line 506




Steps to Reproduce:
The issue can be reproduced at will with the following steps:

1. Log into an HRMS Manager responsibility
2. Run the EEO Suite of Reports
3. The EEO Exceptions Report errors out


Changes

 

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