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'