Costing Process Fails with ORA-06502: PL/SQL: numeric or value error
(Doc ID 2123107.1)
Last updated on DECEMBER 11, 2023
Applies to:
Oracle Payroll - Version 12.1.3 to 12.1 HRMS RUP9 [Release 12.1]Information in this document applies to any platform.
This note provides a brief overview of
Symptoms
Problem Statement:
Costing process fails with following error, even though result values that are costed are all numeric values.
SQLERRMC ORA-06502: PL/SQL: numeric or value error: character to number conversi
on error
ORA-06512: at "APPS.FND_NUMBER", line 20
SQL_NO 213
TABLE_NAME pay_element_links_f
APP-PAY-06881: Error ORA-06502: PL/SQL: numeric or value error: character to number conversion error
ORA-06512: at "APPS.FND_NUMBER", line 20
has occurred in table pay_element_links_f at location 213
Cause: an oracle error has occurred. The failure was reported on table pay_element_links_f at location 213 with the error text ORA-06502: PL/SQL: numeric or value error: character to number conversion error
ORA-06512: at "APPS.FND_NUMBER", line 20
.
Action: Please contact your support representative.
Steps to Reproduce:
The issue can be reproduced at will with the following steps:
- Run Costing.
- Error occurs.
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 |
Cause |
Solution |
References |