Audit Report Fails With ORA-06502: PL/SQL: Numeric or Value Error: Character String Buffer too Small (Doc ID 1593506.1)

Last updated on AUGUST 25, 2017

Applies to:

Oracle Human Resources - Version 12.1 HRMS RUP5 and later
Information in this document applies to any platform.

Symptoms

In PRODUCTION
R12.HR_PF.B.delta.5

When running audit report for PER_ABSENCE_ATTENDANCES get following error in log file:

ERROR
----------------------------------
Arguments
------------
TABLE='PER_ABSENCE_ATTENDANCES'
initialise='Y'
P_TEMPLATE_NAME='Not Defined'
------------

APPLLCSP Environment Variable set to :

Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are :
American_America.UTF8

'.,'

Enter Password:
MSG-00001: tmp003:
REP-1401: 'beforereport': Fatal PL/SQL error occurred.
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "APPS.PY_AUDIT_REP_PKG", line 1366

REP-0069: Internal error
REP-57054: In-process job terminated:Terminated with error:
REP-1401: MSG-00001: tmp003:
REP-1401: 'beforereport': Fatal PL/SQL error occurred.
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "APPS.PY_AUDIT_REP_PKG", line 1366






STEPS TO REPRODUCE


Navigation :run concurrent request : Audit Report
1.parameter : PER_ABSENCE_ATTENDANCES



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