error when using brackets in in nested query in report builder
when we use a nested query as below it works fine in report builder
select t.id, id (select td.desc from td where td.trd_id = t.id and td.desc = 'AAA') desc from t;
however
when we include brackets in the nested query as in the example below with nvl report builder throws an error.
select t.id, id (select td.value from td where td.trd_id = t.id and nvl(td.desc, 'AAA') = 'AAA') value from t;
The error stack is
REP-0069 - Internal Error
REP 57054 - IN Process job Terminated
REP -300 Oracle error