Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

FOEX Tree Grid getting started - missing right parenthesis error

Jernej KorenNov 3 2025 — edited Nov 3 2025

Hello, I'm testing FOEX Tree Grid in Apex, with some basic departments table using this hierarchichal SQL query:

select dep_id,
parent_dep_id,
short_description
from departments
connect by prior dep_id = parent_dep_id
start with dep_id = 58;

I've mapped the needed columns and left other settings to default:

I get the ‘missing right parenthesis error’ on page load - Any idea why?

Comments
Post Details
Added on Nov 3 2025
1 comment
60 views