Retro Details Report is Getting Error

Summary

Retro Details Report getting oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: oracle.xdo.XDOException: java.sql.SQLSyntaxErrorExcept

Content

Hi Experts,

While running Retro Details Report query getting below error.

"oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: oracle.xdo.XDOException: java.sql.SQLSyntaxErrorException: ORA-01722: invalid number"

SQL Query:

 

select 'Run Result' retro_type,

        EEV.ELEMENT_ENTRY_ID,

EEV.INPUT_VALUE_ID,

        pn.last_name,

        pn.first_name,

        p.person_number,

        pre.payroll_relationship_number,

rga.assignment_number , /*PS*/

        ret_et.base_element_name retro_element_name,