1. HCM Data Loading Business Objects
  2. Guidelines for loading a course to Oracle Learning using Course

Guidelines for loading a course to Oracle Learning using Course

When activity sequencing is turned off, use the Course object and HCM Data Loader to load courses and related learning objects to Oracle Learning. When activity sequencing is turned on, use CourseV3.

Use the most recent .dat file because unused attributes can be deprecated.

To verify that the course and related learning objects loaded, go to My Client Groups > Learning and Development > Learning Catalog.

Course object hierarchy and processing order

Here's the hierarchy and processing order for learning objects you can load with Course:

  1. ClassroomResource (processing order: 106030)
  2. ClassroomResourceTranslation (processing order: 106031)

  3. Course (processing order: 106060)

    1. Offering

      1. InstructorLedActivity

        1. ClassroomReservation
        2. InstructorReservation
        3. AdhocResource
      2. SelfPacedActivity
      3. OfferingDefaultAccess
    2. CourseDefaultAccess
  4. CourseTranslation (processing order: 106061)
  5. OfferingTranslation (processing order: 106062)
  6. InstructorLedActivityTranslation (processing order: 106064)
  7. SelfPacedActivityTranslation (processing order: 106065)

  8. CourseOfferingPricingDefaults (processing order: 106070)

    1. CourseOfferingPricingComponent

  9. OfferingCustomPricing (processing order: 106075)

    1. OfferingCustomPricingComponent

Rich text syllabus and cover art

  • Rich text syllabus: Reference the rich text file, such as an .html file, in the Syllabus attribute. Put the file in a ClobFiles folder, compress the folder, and include the .zip file in Course.zip.
  • Cover art: Reference the image file, such as a .jpg file, in the CoverArtFile and CoverArtFileName attributes. Put the file in a BlobFiles folder, compress the folder, and include the .zip file in Course.zip.

Validations

The load process validates that each course meets these requirements:

  • When creating a course, the CourseNumber value is unique, and the Title and OwnedByPersonId values aren't null.
  • The person identified by the OwnedByPersonId value exists in the HCM app.
  • The trailer video identified by the TrailerLiId value exists in Oracle Learning.
  • If you provide a CoverArtFile value, it uses a supported format (.jpeg, .jpg, .bmp, .tiff, .png, or .gif) and can be read.
  • The EffectiveStartDate value isn't empty or null.
  • The PublishStartDate value is before the PublishEndDate value.
  • The MinimumExpectedEffort value is 0 or a positive number.
  • The MaximumExpectedEffort, MinimumPrice, and MaximumPrice values are positive numbers.
  • The MinimumExpectedEffort value is less than the MaximumExpectedEffort value.
  • The MinimumPrice value is less than the MaximumPrice value.
  • The access properties for the learning can be retrieved.

Example of loading a course

Here's how you can load a course using Course and user keys.

METADATA|Course|EffectiveStartDate|CourseNumber|Title|ShortDescription|PublishStartDate|PublishEndDate|MinimumExpectedEffort|MaximumExpectedEffort|CurrencyCode|MinimumPrice|MaximumPrice|TrailerLiNumber|OwnedByPersonNumber|SourceType|SourceId|SourceInfo
MERGE|Course|2018/02/04|COURSE-201802041711-HDL|Title:COURSE 201802041711|ShortDesc:COURSE201802041711|2018/02/04|2019/02/03|0|1|USD|0|0|OLC103778|8153757|FUSION_HCM_LEARNING|201802041711|HCM Learning Source Info for 201802041711 HDL Update