BI Publisher - SQL Report with Date Parameter issue
The BIP SQL Report with DATE parameters are failing to run due to errors. The errors are ORA-01830, ORA-01722.
The issue could be reproduced:
We have an SQL Statement:
SELECT ppei1.person_id,
ppei1.pei_information3 Код_ОКПО,
ppei1.pei_information1 Наим_Орг,
ppei2.pei_information23 Номер_УКД
FROM per_people_extra_info ppei1, per_people_extra_info ppei2
WHERE 1=1
AND ppei1.pei_information1 IS NOT NULL
AND ppei1.person_id=ppei2.person_id
AND ppei1.pei_information_category ='KZ_DISS_Organization'
AND ppei2.pei_information_category = 'KZ_DISS_Shifr_nauh_spec'
AND TO_DATE(ppei2.pei_information7, 'YYYY/MM/DD HH24:MI:SS') >=:p_start_date
The issue could be reproduced:
We have an SQL Statement:
SELECT ppei1.person_id,
ppei1.pei_information3 Код_ОКПО,
ppei1.pei_information1 Наим_Орг,
ppei2.pei_information23 Номер_УКД
FROM per_people_extra_info ppei1, per_people_extra_info ppei2
WHERE 1=1
AND ppei1.pei_information1 IS NOT NULL
AND ppei1.person_id=ppei2.person_id
AND ppei1.pei_information_category ='KZ_DISS_Organization'
AND ppei2.pei_information_category = 'KZ_DISS_Shifr_nauh_spec'
AND TO_DATE(ppei2.pei_information7, 'YYYY/MM/DD HH24:MI:SS') >=:p_start_date
2