I'm getting error ORA-01841: (full) year must be between -4713 and +9999, and not be 0

Hi,

I'm getting error ORA-01841: (full) year must be between -4713 and +9999, and not be 0 while running a query in the BIP Report.

If i'm passing from_date and to_date range for 1 week e.g;= 01-OCT-23 till 07-OCT-23, then report is working fine.

As i increase the from date filter lets say for 10 days, e.g;= 01-OCT-23 till 10-OCT-23, then report is giving error: ORA-01841: (full) year must be between -4713 and +9999, and not be 0 .

This issue is occuring due to condition in query:

and trunc(rhv.processstart) between nvl(:pFromDate,trunc(sysdate)) and nvl(:pToDate,trunc(sysdate))

rhv.processstart column is from the standard table : fusion_ora_ess.request_history_view