Eirikur Eiriksson (10/23/2016)
The error is pointing to the LISTAGG_CLOB as (as far as I can remember) there is no such function in Oracle. Chances are that it exists as something like this:
CREATE or replace FUNCTION listagg_clob (input varchar2)
RETURN clob
PARALLEL_ENABLE AGGREGATE USING listagg_clob_t;
😎
Are you using the same credentials for both the old and the new report? Could be a permission problem.
I didn't think there was a function like that either, but it's been quite a while since I've used Oracle. In looking at permissions like Eirikur said, be sure to consider synonym permissions as well as the function.