BI Publisher (MOSC)

MOSC Banner

BI Publisher - SQL Report with Date Parameter issue

edited Apr 26, 2019 3:56AM in BI Publisher (MOSC) 11 comments
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

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