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.SQLSyntaxErrorExceptContent
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,
Tagged:
2