1. HCM Data Loading Business Objects
  2. Guidelines for loading an ILT activity and supporting resources, and translations for an Oracle Learning offering

Guidelines for loading an ILT activity and supporting resources, and translations for an Oracle Learning offering

When activity sequencing is on, use InstructorLedActivityV3 to load ILT activities. When it's off, use InstructorLedActivity. The parent ILT or blended offering must already exist. After loading the activity, use InstructorLedActivityTranslation to load translations.

Instructor-led activities can include classroom, instructor, and other resources. Use these components to add resources:

  • You can identify one classroom resource directly on InstructorLedActivity. For other classrooms, use ClassroomReservation. The referenced ClassroomResource needs to already exist.
  • To add instructors, use InstructorReservationV3 when activity sequencing is turned on and InstructorReservation when it's turned off. The referenced InstructorResource needs to already exist.
  • To add unplanned teaching resources, such as flip charts, projectors, and pens, use AdhocResourceV3 when activity sequencing is turned on and AdhocResource when it's turned off.

To verify that the ILT activity loaded, go to My Client Groups > Learning and Development > Learning Catalog.

ILT activity validations

The load process validates that each ILT activity meets these requirements:

  • An online activity has a VirtualClassroomUrl value, or ClassroomResourceNumber identifies an existing classroom resource. If you provide both values, the activity is treated as onsite.
  • ActivityStartTime and ActivityEndTime use 24-hour format, such as 10:00:00 or 19:00:00.
  • TimeZone uses a TZ database name, such as America/Los_Angeles.

Example using InstructorLedActivity

Here's how you can load an ILT activity and its supporting resources using InstructorLedActivity and user keys.

METADATA|InstructorLedActivity|EffectiveStartDate|ActivityNumber|Title|ActivityDate|ActivityStartTime|ActivityEndTime|TimeZone|ExpectedEffort|SelfCompleteFlag|OfferingNumber|VirtualClassroomUrl|ClassroomResourceNumber|SourceType|SourceId|SourceInfo
MERGE|InstructorLedActivity|2018/02/04|ILT-ACT-201802041713-HDL|Title:ILT ACT 201802041713|2018/02/04|10:00:00|19:00:00|America/Los_Angeles|30|Y|OFFERING-201802041712-HDL|http://www.example.com|RSC-201802041710-HDL|FUSION_HCM_LEARNING|201802041713|HCM Learning Source Info for 201802041713

COMMENT Load two AdhocResource components
METADATA|AdhocResource|AdhocResourceNumber|Name|Description|Quantity|ActivityNumber
MERGE|AdhocResource|ADHOC-201802041714-HDL|SS-ADHOC-RESOURCE-1|SS-ADHOC-RESOURCE-1 DESC|30|ILT-ACT-201802041713-HDL
MERGE|AdhocResource|ADHOC-201802041715-HDL|SS-ADHOC-RESOURCE-2|SS-ADHOC-RESOURCE-2 DESC|30|ILT-ACT-201802041713-HDL

COMMENT Load one ClassroomReservation component
METADATA|ClassroomReservation|ClassroomReservationNumber|ClassroomResourceNumber|ActivityNumber
MERGE|ClassroomReservation|CRSV-201802041716-HDL|OLC136311|ILT-ACT-201802041713-HDL

COMMENT Load two InstructorReservation components
METADATA|InstructorReservation|InstructorReservationNumber|InstructorResourceNumber|ActivityNumber
MERGE|InstructorReservation|INSTR-201802041717-HDL|8153762|ILT-ACT-201802041713-HDL
MERGE|InstructorReservation|INSTR-201802041718-HDL|8153771|ILT-ACT-201802041713-HDL

Load ILT activity translations

After you load the ILT activity, use InstructorLedActivityTranslation to load translations for other languages installed for Oracle Learning.

To verify that the translations loaded, change the Oracle Learning language. Then go to My Client Groups > Learning and Development > Learning Catalog, open the offering, and go to Activities.