My Oracle Support Banner

Integrated Daily Wage (IDW) Audit Report Completed Error ORA-06512: at "APPS.PAY_MX_IDW_AUDIT_PKG", line 1762 (Doc ID 2553082.1)

Last updated on DECEMBER 03, 2019

Applies to:

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

Symptoms

On : 12.1.3 version, PAY Reports

When attempting to run IDW Audit Report the following error occurs.

ERROR
-----------------------
BEGIN PAY_MX_IDW_AUDIT_PKG.level_cnt := PAY_MX_IDW_AUDIT_PKG.level_cnt; FETCH PAY_MX_IDW_AUDIT_PKG.G
ET_GRE INTO pay_magtape_generic.ret_vals(5), pay_magtape_generic.ret_vals(6), pay_magtape_generic.r
et_vals(7), pay_magtape_generic.ret_vals(8), pay_magtape_generic.ret_vals(9), pay_magtape_generic.re
t_vals(10), pay_magtape_generic.ret_vals(11); END;
Exiting pay_magtape_generic.curs_fetch
Entering pay_magtape_generic.curs_no_data
Exiting pay_magtape_generic.curs_no_data
Entering pay_magtape_generic.open_formula
Exiting pay_magtape_generic.open_formula
Entering pay_magtape_generic.tab_is_open1189495757
Exiting pay_magtape_generic.tab_is_open
Entering pay_magtape_generic.setup_return_values
Exiting pay_magtape_generic.setup_return_values
Exiting pay_magtape_generic.new_formula
IANA Charset = ISO-8859-1
pay_mx_idw_audit_pkg.generate_gre_xml_header 5
pay_mx_idw_audit_pkg.generate_gre_xml_header 10
pay_mx_idw_audit_pkg.generate_gre_xml_header 15
Error in pay_mx_idw_audit_pkg.generate_gre_xml_header - -6502 - ORA-06502: PL/SQL: numeric or value error: character string buffer too small <<<<<<
pay_payroll_actions_bru 10
pay_payroll_actions_bru 30
-------------------------------------------------------------------------
 Out } pyfldlf
 In { pylogseh
  In { pyxpmsh
  Out } pyxpmsh
  In { pylogpop
  Out } pylogpop
HR_6881_HRPROC_ORA_ERR
SQLERRMC ORA-20001:
ORA-06512: at "APPS.HR_UTILITY", line 949
ORA-06512: at "APPS.PAY_MX_IDW_AUDIT_PKG", line 1762
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_SQL", line 1825
ORA-06512: at "APPS.PAY_MAG_TAPE", line 59
ORA-06512: at line 1

SQL_NO 2549
TABLE_NAME pay_mag_tape.run_xml_proc
APP-PAY-06881: Error ORA-20001:
ORA-06512: at "APPS.HR_UTILITY", line 949
ORA-06512: at "APPS.PAY_MX_IDW_AUDIT_PKG", line 1762
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_SQL", line 1825
ORA-06512: at "APPS.PAY_MAG_TAPE", line 59
ORA-06512: at line 1
has occurred in table pay_mag_tape.run_xml_proc at location 2549

Cause: an oracle error has occurred. The failure was reported on table pay_mag_tape.run_xml_proc at location 2549 with the error text ORA-20001:ORA-06512: at "APPS.HR_UTILITY", line 949
ORA-06512: at "APPS.PAY_MX_IDW_AUDIT_PKG", line 1762
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_SQL", line 1825
ORA-06512: at "APPS.PAY_MAG_TAPE", line 59
ORA-06512: at line 1
.

Action: Please contact your support representative.

  In { pyxipmt
message text = Error ORA-20001:
ORA-06512: at "APPS.HR_UTILITY", line 949
ORA-06512: at "APPS.PAY_MX_IDW_AUDIT_PKG", line 1762
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_SQL", line 1825
ORA-06512: at "APPS.PAY_MAG_TAPE", line 59
ORA-06512: at line 1

message level = F,F
payroll_id text = 0
source_id text = 8,41652784
line_text = 17, Error ORA-20001:
line_text = 41, ORA-06512: at "APPS.HR_UTILITY", line 949
line_text = 52, ORA-06512: at "APPS.PAY_MX_IDW_AUDIT_PKG", line 1762
line_text = 20, ORA-06512: at line 1
line_text = 39, ORA-06512: at "SYS.DBMS_SQL", line 1825
line_text = 42, ORA-06512: at "APPS.PAY_MAG_TAPE", line 59
line_text = 20, ORA-06512: at line 1
line_text = 1,


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


1. Submit the Single Request > IDW Audit Report

2. Observe the error message

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot submit the IDW Audit Report successfully

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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