This has been identified as an Oracle bug and will be fixed with a patch update before 25C. Source: https://community.oracle.com/customerconnect/discussion/877098/not-able-to-fetch-dependents-details-using-benefits-enrollments-real-time-subject-area/p1

Yes, using Pivot table would help in getting all responses in a single row instead of getting one row for each question response (therefore multiple rows for each candidate). I have a different issue. Anyone has a multiple choice/selection question and able to get all answers (more than 1 answer to the question like some…