Error After Adding Custom SQL Condition to WLF_LEARNING_ITEMS_F for Custom Learning Instructor Role

Summary:

Hi Experts,

We have a requirement to create a Custom Learning Instructor role where:

• The Primary Instructor should be able to see only the courses where they are assigned as Primary Instructor.
• The Primary Instructor should be able to update the learner status only for those courses where they are assigned as Primary Instructor.

To implement this, we:

• Create as Custom Job Role for Learning Instructor.
• Created a custom SQL condition on WLF_LEARNING_ITEMS_F
• Derived the SQL from Oracle document:
  “Understanding Oracle Learning Cloud Access Control” (Doc ID 2543292.1).
• Attached the condition to the data security policy of the custom role.