Payroll and OTL - EBS (MOSC)

MOSC Banner

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

edited Jul 8, 2019 5:56PM in Payroll and OTL - EBS (MOSC) 7 commentsAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center