My Oracle Support Banner

Quickpay Retro (Enhanced) ORA-06502: PL/SQL: NUMERIC OR VALUE ERROR: CHAR TO NUM (Doc ID 2633762.1)

Last updated on FEBRUARY 04, 2020

Applies to:

Oracle Payroll - Version 12.2.7 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.7 version, RetroPay Issue

When attempting to run Quick RetroPay (Enhanced) program the following error occurs.

ERROR
-----------------------
Find FREQUENCY_RULES
Using Cached value
 Out } pyxgpar
frequency rule flag=Y
 In { pyxgpar
  In { pyxfcot
  Out } pyxfcot
Find FREQ_RULE_WHOLE_PERIOD
Using Cached value
 Out } pyxgpar
Allow whole period=D
 In { pyxglgr
  In { pyxfcot
  Out } pyxfcot
Using Cached value
 Out } pyxglgr
Legislation Rule FREQ_RULE_DATE = N
Default Frequency Rules Date Code = E
Frequency Rules Date is .... 2019/09/28 00:00:00
stat=begin hr_elements.check_element_freq (p_payroll_id=>:payroll_id,p_bg_id =>
:bus_grp_id,p_pay_action_id => :pay_action_id,p_passed_date => to_date(:frule_da
te, :date_format),p_whole_period_only => :whole_period,p_ele_type_id => :et_id,
p_skip_element => :skip ); end;
payroll_id=121,bus_grp_id=101,pay_action_id=1192431.000000,et_id=1339,
  date_earned=2019/09/28 00:00:00,date_paid=2019/09/28 00:00:00skip=N... Out } pyclet
third party payment = 0
1339....368793....2019/09/28 00:00:00.... In { pybkelku
Value passed to pybkelku : N
Input Value ID (pybkelku) : 6096
 In { pycfind
object found
 Out } pycfind
Lookup Type/Value Set, Indicator : US_DEDUCTION_PROCESSING, 0
Lookup Value befor: N
Lookup Value ind : 0
Lookup Value after:
Lookup Value ind : -1
Lookup Value ind : -1
ValueSet ID, Indicator : US_DEDUCTION_PROCESSING, 0
Oracle error occurred
Table=retro_lookup_meaning
sqlno=1561
ORA-06502: PL/SQL: numeric or value error: character to number conversion error ORA-06512: at line 1

Exitting without success
.
HR_6881_HRPROC_ORA_ERR
SQLERRMC ORA-06502: PL/SQL: numeric or value error: character to number conversion error ORA-06512: at line 1

SQL_NO 1561
TABLE_NAME retro_lookup_meaning
APP-PAY-06881: Error ORA-06502: PL/SQL: numeric or value error: character to number conversion error
ORA-06512: at line 1
has occurred in table retro_lookup_meaning at location 1561

Cause: an oracle error has occurred. The failure was reported on table retro_lookup_meaning at location 1561 with the error text ORA-06502: PL/SQL: numeric or value error: character to number conversion error
ORA-06512: at line 1
.

Action: Please contact your support representative.

 In { pyxipmt
message text = Error ORA-06502: PL/SQL: numeric or value error: character to number conversion error
ORA-06512: at line 1 has occurred in table retro_lookup_meaning at location 1561

Cause: an oracle error has occurred. The failure was reported
message level = F,F
payroll_id text = 121
source_id text = 9,322918540
line_text = 85, Error ORA-06502: PL/SQL: numeric or value error: character to number conversion error
line_text = 20, ORA-06512: at line 1
line_text = 60, has occurred in table retro_lookup_meaning at location 1561
line_text = 0,
line_text = 70, Cause: an oracle error has occurred. The failure was reported


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run Quick RetroPay (Enhanced)


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.