BIP – Query to extract assignment rules at course level in Oracle Learning Cloud
Use the below SQL to extract assignment rules defined at course level:
-
-
HDL – Loading CoverArt File at Course Level
While creating the Courses in Oracle Learning Cloud, there is a capability to load CoverArt for each course. If no cover art is loaded, the learner is presented with a blue strip film. HCM Data Loaders provides an option to bulk upload the CoverArt file for multiple courses at one go. All the cover art…
-
Reports (BIP) – Query to get learning outcomes
Oracle Learning Cloud supports to define learning outcomes against each course as shown in below fig: For reporting and integration purposes, there is a need to extract the learning outcomes assigned against each course. Learning outcomes are stored as profile relationship against each course. Below query can be used to extract the asked data:
-
-
Reports (BIP) – Query to extract default Access Group data for a Course/Offering
In Oracle Learning cloud, Learning Admin can define the Default access at Course or offering level. Course.dat can be used to load this information. In order to extract this information from DB in HDL format, please use below query: Also, learners can be assigned using Access Groups. To extract this information below SQL can be…