Guidelines for Loading a Course to Oracle Learning Using Course

If you haven't turned on activity sequencing, you can load courses, offerings, activities, and classroom and instructor reservations to the Oracle Learning catalog using the Course object. If you have it turned on, use the CourseV3 object.

To verify that the course successfully loaded, use the Courses task on the My Client Groups > Learning page. To verify that an offering, activities, and classroom and instructor reservations successfully loaded, use the Offerings task.

Here's the hierarchy and processing order for the relevant learning items:

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. Offering Default Access
4. Course Default Access 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

A course file can have a rich text syllabus description and cover art.

• To load rich text, you need to reference a rich text file in the Syllabus attribute, such as an .html file. To load the rich text files, place them all in a folder called ClobFiles and zip the folder. Then include that zip inside the Course.zip file.
• To load cover art, you need to reference an image file in the CoverArtFile and CoverArtFileName attributes, such as a .jpg file. To load the image files, place them in a folder called BlobFiles and zip the folder. Then include that .zip file inside the Course.zip file.

Validations

The load process does these validations:

• On create, the CourseNumber value doesn't exist and the Title and OwnedByPersonID values aren't null
• The Person object exists for the provided OwnedByPersonId value
• The Trailer Video record for the provided TrailerLiId value exists in Oracle Learning
• Checks if a CoverArtFile is provided and if so, that the CoverArtFile extension is one of these valid file formats: .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 either 0 or a positive number
• The MaximumExpectedEffort, MinimumPrice, and MaximumPrice values are a positive number
• The MinimumExpectedEffort value is less than the MaximumExpectedEffort value
• The MinimumPrice value is less than the MaximumPrice value
• It can retrieve the access properties for the learning item