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:
select 'MERGE' "METADATA"
,'CourseDefaultAccess' "CourseDefaultAccess" ,to_char(wapf.effective_start_date,'RRRR/MM/DD') "EffectiveStartDate" ,to_char(wapf.effective_end_date,'RRRR/MM/DD') "EffectiveEndDate" ,wapf.ACCESS_PERMISSION_NUMBER "DefaultAccessNumber"
,wlif.learning_item_number "CourseNumber"
,wapf.FOLLOW_SPEC "FollowSpecialization"
,wapf.ASSIGN_AS_MANAGER "MgrInitialStatus" ,wapf.ASSIGN_FOR_SELF "SelfInitialStatus" ,wlif.SS_VIEW_MODE "SelfViewMode"
from WLF_ACCESS_PERMISSIONS_F wapf
,WLF_LEARNING_ITEMS_F wlif
where 1=1
and wapf.access_permission_id= wlif.access_permission_id
--and trunc(sysdate) between wapf.effective_start_date and wapf.effective_end_date
and trunc(sysdate) between wlif.effective_start_date and wlif.effective_end_date
and wlif.learning_item_number = 'OLC251051'