1. HCM Data Loading Business Objects
  2. Guidelines for loading learning paths to Oracle Learning using SpecializationV3

Guidelines for loading learning paths to Oracle Learning using SpecializationV3

Specializations are called learning paths in newer Redwood environments. If activity sequencing is turned on, load them using the SpecializationV3 object. If it's turned off, use the Specialization object.

Tip: Unused attributes can get deprecated, so always use the most recent .dat file.

To verify that the learning path successfully loaded, go to My Client Groups > Learning and Development > Learning Catalog.

Here's the hierarchy and processing order for the SpecializationV3 learning objects:

  1. SpecializationV3

    1. SpecializationDefaultAccessV3

    2. SpecializationSectionV3

      1. SpecializationSectionActivityV3
  2. SpecializationV3Translation
  3. SpecializationSectionV3Translation

Create the complete learning path hierarchy in two loads.

  1. In a single SpecializationV3 .dat file, load the SpecializationV3 object.

    Make sure that the SpecializationNumber doesn't exceed 26 characters. Otherwise, the autogenerated section number for the default section will exceed 30 characters and result in an HCM Data Loader error.

  2. After the step 1 load completes successfully, in a separate SpecializationV3 .dat file, load the SpecializationSectionV3 and SpecializationSectionActivityV3 components.

    • Make sure that the .dat file also includes the parent SpecializationV3 reference, even if you aren't updating the parent. Otherwise, the load process fails.
    • For all activities, include the parent SpecializationSectionV3 row in the .dat file.

Effective dates

When you load current learning, set the effective start date to the device date. For future-dated learning, use the same future date. Updates aren't applied to end-dated learning.

Default section

The load process automatically sets these values for the default section of a learning path:

  • Sets the Title value to Default Section.
  • Generates the SpecializationSectionNumber value using the parent SpecializationNumber value and the _SEC suffix.  For example, if SpecializationNumber is SPECIAL-202104280937-HDL, the generated SpecializationSctionNumber is SPECIAL-202104280937-HDL_SEC.
  • Sets the SectionPosition value to 1. If you add more sections to the learning path, set the SectionPosition values in the appropriate sequence, starting with 2.
  • Sets the ShowSectionIfSingleSectionExists value to N so learners see the activities but not the default section attribute values. If you add more sections, the load process ignores any value for this attribute. This attribute corresponds to the Enable as a visible section to learners option on the Activities tab of the learning path details page.

SpecializationV3 .dat file structure with attributes

METADATA|SpecializationV3|SpecializationId|EffectiveStartDate|EffectiveEndDate|SpecializationNumber|Title|ShortDescription|Description|PublishStartDate|PublishEndDate|CoverArtFile|CoverArtFileName|SourceType|SourceId|SourceInfo|OwnedByPersonId|OwnedByPersonNumber|MinimumExpectedEffort|MaximumExpectedEffort|SourceSystemOwner|SourceSystemId|GUID|DescriptionText|ShowSectionIfSingleSectionExists

METADATA|SpecializationDefaultAccessV3|DefaultAccessId|DefaultAccessNumber|EffectiveStartDate|EffectiveEndDate|FollowCommunity|SelfViewMode|SelfInitialStatus|SelfEnrollForm|SelfActivateApprove|SelfEnrollQuestionnaire|SelfQuestionnaireCode|SelfPrereqType|SelfWithdrawPrereqDays|MgrInitialStatus|MgrActivateApprove|MgrWithdrawPrereqDays|MgrMarkComplete|SourceSystemId|SourceSystemOwner|GUID|SpecializationId|SpecializationNumber

METADATA|SpecializationSectionV3|SpecializationSectionId|SpecializationSectionNumber|EffectiveStartDate|EffectiveEndDate|Title|Description|DescriptionText|CompletionRuleType|NumberOfActivitiesToComplete|SequenceRuleType|SequenceRuleSectionNumber|InitialAssignmentStatusOfActivities|SectionPosition|SpecializationId|SpecializationNumber|SourceSystemOwner|SourceSystemId|GUID

METADATA|SpecializationSectionActivityV3|ActivityId|EffectiveStartDate|EffectiveEndDate|ActivityNumber|SpecializationSectionId|SpecializationSectionNumber|CourseLearningItemId|CourseLearningItemNumber|SequenceRuleType|SequenceRuleActivityNumber|ActivityPosition|ActivityCompletionType|SourceSystemId|SourceSystemOwner|GUID