SQL Query to Extract Loaded Courses from Oracle Fusion

 Below query can be used to extract loaded course, change the Source System Owner value according to your value.

SELECT DISTINCT
'CourseV3' "OBJECT_NAME",
TO_CHAR(wlfli.EFFECTIVE_START_DATE,'DD/MM/YYYY') AS EFFECTIVE_START_DATE,        
    TO_CHAR(wlfli.EFFECTIVE_END_DATE,'DD/MM/YYYY') EFFECTIVE_END_DATE,
wlfli.LEARNING_ITEM_NUMBER AS COURSE_NUMBER,
wlflitl.NAME AS TITLE,
wlflitl.DESCRIPTION_SHORT AS SYLLABUS,
TO_CHAR(wlfli.START_DATE, 'DD/MM/YYYY') AS PUBLISH_START_DATE,
TO_CHAR(wlfli.END_DATE, 'DD/MM/YYYY') AS PUBLISH_END_DATE,
wlflc.MINIMUM_TRAINING_HOURS AS MinimumExpectedEffort,
wlflc.MAXIMUM_TRAINING_HOURS AS MaximumExpectedEffort,
(select distinct person_number 
  from per_all_people_f 
where person_id = wlfli.OWNED_BY_ID 
) OwnedByPersonNumber,
hrcik.SOURCE_SYSTEM_OWNER,
hrcik.SOURCE_SYSTEM_ID
FROM 
WLF_LEARNING_ITEMS_F wlfli,
HRC_INTEGRATION_KEY_MAP hrcik,
WLF_LEARNING_ITEMS_F_TL wlflitl,
WLF_LI_COURSES_F wlflc
WHERE 
wlfli.LEARNING_ITEM_ID = hrcik.SURROGATE_ID
AND wlfli.LEARNING_ITEM_ID = wlflitl.LEARNING_ITEM_ID
AND wlfli.LEARNING_ITEM_ID = wlflc.LEARNING_ITEM_ID(+)
AND hrcik.SOURCE_SYSTEM_OWNER = 'HRC_SQLLDR'
AND wlfli.CREATED_BY like 'FUSION_APPS_HCM_ESS_LOADER_APPID'
AND wlflitl.LANGUAGE = USERENV('LANG')