Announcements for Payroll and OTL can now be found in the Announcements - Payroll and OTL - EBS (MOSC) subcategory. Follow to be sure you don't miss a thing!
ORA-01722: invalid number
Recently some patches were installed. We have a custom process that is run after each payroll to create a file to send to our pensions office. It worked fine until the first pay after patches applied. It now errors with the message ORA-01722 invalid number. Has anyone experienced this? Any ideas on how to resolve?
- It happens only when running the pension interface from the app server, if I take the query and
run it in plsqldeveloper, it runs fine. - We have a field called RESULT_VALUE in pay_run_result_values that has both character strings and
valid numbers. The query for the pension interface converts this field to_number and this is when the error is happening.