Guidelines for loading legacy learning and translations using HCM Data Loader

Use HCM Data Loader to load completed external learning that won't be used going forward but needs to appear in learners' learning history. Use LegacyLearningItem to create the learning, LearningRecord to associate it with learners, and LegacyLearningItemTranslation to load translations.

Legacy learning doesn't have linked rich media content because it isn't active learning in the Oracle Learning catalog.

To verify that the legacy learning loaded, check the appropriate learner's learning history. To verify translated text, first change the Oracle Learning language and then check the learner's learning history.

Validations

Here's how the load process validates legacy learning:

  • Confirms that the LearningItemNumber value is unique, alphanumeric, and doesn't start with OLC.
  • Confirms that EffectiveStartDate is on or before the start date of any effective-dated record that references the legacy learning item, such as a learning assignment. By default, EffectiveEndDate is the end of time. You can't change the effective start or end date of an existing legacy learning item.
  • Confirms that OwnedByPersonId isn't null.
  • Confirms that a Person object exists for the provided PersonId or OwnedByPersonId value.

Example of creating a legacy learning

Here's how you can create a legacy learning using a source key.

COMMENT: Data for Business Object LegacyLearningItem
METADATA|LegacyLearningItem|EffectiveStartDate|LearningItemNumber|Title|ShortDescription|OwnedByPersonNumber|SourceType|SourceId|SourceInfo|SourceSystemOwner|SourceSystemId
MERGE|LegacyLearningItem|2017/07/26|LEGACY-201710161121-HDL|Title:Legacy LI 201710161121|DescShort:LEGACY-201710161121|8153756|FUSION_HCM_LEARNING|201710161121|HCM Learn 201710161121 Source Info|VISION|201710161121

Example of loading a legacy learning translation

Here's how you can load a French translation of the title and short description for an existing legacy learning using its source key.

COMMENT: Data for Business Object LegacyLearningItemTranslation
METADATA|LegacyLearningItemTranslation|EffectiveStartDate|Language|LearningItemNumber|Title|ShortDescription|SourceSystemOwner|SourceSystemId
MERGE|LegacyLearningItemTranslation|2017/07/26|FR|LEGACY-201710161121-HDL|French Title:Legacy LI 201710161121|French ShortDesc:LEGACY-201710161121|VISION|201710161121