Argument out of range error
One possible reason:

Bug 18162779 : ORA-01428: ARGUMENT '000000000000000000' IS OUT OF RANGE

Try running the query after setting the below:

alter session set  "_disable_function_based_index" = TRUE;