ZA TYE Validation Report Error ORA-06502 ORA-06512 (Doc ID 2186116.1)

Last updated on SEPTEMBER 23, 2016

Applies to:

Oracle HRMS (South African) - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

When attempting to run Tax Year End Data Validation and Preprocess(1) concurrent program,
the following error occurs.

ERROR

Param Test Debug value
Program Name is NULL checking for PLSQL package name !!!
Old encoding=UTF-8
SELECT tag charset FROM fnd_lookup_values WHERE lookup_type = 'FND_ISO_CHARACTER_SET_MAP' AND lookup_code = SUBSTR(USERENV('LANGUAGE'), INSTR(USERENV('LANGUAGE'), '.') + 1) AND language = 'US'
New encoding=US-ASCII
BEGIN PAY_XML_GEN_PKG.EXEC_REPORT_MAP_FUNCTION ( :1, :2, :3, :4 ); END;
Problem:java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "APPS.PAY_ZA_EOY_VAL", line 4218
ORA-06512: at "APPS.PAY_ZA_EOY_VAL", line 4889
ORA-06512: at line 1
ORA-06512: at "APPS.PAY_XML_GEN_PKG", line 37
ORA-06512: at line 1

Exception inside runProgramjava.sql.SQLException: ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "APPS.PAY_ZA_EOY_VAL", line 4218
ORA-06512: at "APPS.PAY_ZA_EOY_VAL", line 4889
ORA-06512: at line 1
ORA-06512: at "APPS.PAY_XML_GEN_PKG", line 37
ORA-06512: at line 1


STEPS

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

1. Apply patch 23759898:R12.PAY.B for the ZA: TY2016/17 REPORTING CHANGES FOR BRS - PHASE II
2. Login Under ZA HRMS Manager
3. (N) Processes and Reports - Submit Processes and Reports - Run Tax Year End Data Validation and Preprocess(1) concurrent program
4. Check logfile and see error


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