Skip to Main Content

E-Business Suite

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Issue with Handling Learning Items by Instructors

Milan ChandraJan 24 2023

Issue with Handling Learning Items by Instructors

Problem Description
---------------------------------------------------
Business Case:
1. Our Client needs instructor should be only allowed to see a set of courses and offerings where he/she is designated as part of the course instructors.
2. They should be able to see the Learners in the offerings, and update the attendance of the Learners accordingly

3. we have using the below document from oracle(Also attached in attachments):
Understanding Access Control in Oracle Learning PAGE 47 from the doc
4. we have used the below SQL query from this doc
5. Advanced Method: Handling Learning Items by Instructors
The following SQL predicate example should be used when there is a need for a specific instructor role, where instructor should be only allowed to see a set of courses and offerings where he/she is designated as part of the course instructors.

6. But it only gives access to the Offerings, and not the Learners.

Is there any way we can also view the learners along with offerings for the Instructor Role??

Comments
Post Details
Added on Jan 24 2023
0 comments
41 views