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:
Use the below SQL to extract assignment rules defined 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…
*FROM Clause wlf_learning_items_f wlif, wlf_learning_items_f_tl wlift Value Attributes Table Alias *Value Column Name SUBSTR(wlift.name,1,150) Value Column Type VARCHAR2 Value Column Length 150 Description Column Name Description Column Type Description Column Length ID Column Name TO_CHAR(wlif.LEARNING_ITEM_ID) ID Column Type VARCHAR2 ID Column Length 40 Enabled Flag Column Name Start Date Column…