1. HCM Data Loading Business Objects
  2. Load eLearning completion and renewal details for legacy assignments to Oracle Learning

Load eLearning completion and renewal details for legacy assignments to Oracle Learning

Use the LearningRecord object and HCM Data Loader to load legacy assignments and completion details for eLearning with a renewal configuration. You can load past renewals, continue the renewal cycle, and let learners review the eLearning content linked to the most recent completion.

  1. Create a learning initiative with a learner audience object, such as an analysis or organization chart. We recommend using an audience object that doesn't contain any learners so that the initiative doesn't create assignments for them. You'll use the initiative number in the LearningRecord.dat file. You'll also associate the specific learners with the assignments in the file.
    Make sure that Learner Reconciliation isn't selected. Otherwise, reconciliation processes can withdraw existing assignments when they don't identify the learners in the initiative audience.
  2. Create the LearningRecord.dat file. Include the initiative number as the AssignmentNumber value and the course number as the LearningItemNumber value. Set LearningRecordStatus to ORA_ASSN_REC_ACTIVE for in-progress and future-dated assignments.
    Caution: Don't include the most recent completion in the .dat file. Otherwise, Oracle Learning sets the assignment status to Bypass Completed. For example, if a learner completed the course in 2018, 2019, and 2020, include the 2018 and 2019 completions. Don't include the 2020 completion.
    METADATA|LearningRecord|LearningRecordId|LearningRecordEffectiveStartDate|LearningRecordEffectiveEndDate|LearningRecordNumber|AssignmentNumber|LearningItemType|LearningItemNumber|AssignmentType|AssignmentSubType|AssignedByPersonNumber|AssignmentAttributionType|AssignmentAttributionNumber|AssignmentAttributionCode|LearnerNumber|LearningRecordStatus|LearningRecordStartDate|LearningRecordDueDate|LearningRecordWithdrawnDate|LearningRecordDeletedDate|LearningRecordCompletionDate|LearningRecordValidFromDate|LearningRecordExpiryDate|LearningRecordTotalActualEffort|LearningRecordTotalActualEffortUOM|LearningRecordReasonCode|LearningRecordComments
MERGE|LearningRecord||2017/01/01||LRN_MF_07041957|OLC928002|ORA_COURSE|HDL_CRS_0704|ORA_REQUIRE_ASSIGNMENT|ORA_EVT_SUBT_ADMIN|8153756|ORA_SPECIALIST|8153756|ORA_WLF_CEO_OFFICE|8153756|ORA_ASSN_REC_COMPLETE|2018/03/01|2018/03/30|||2018/03/10|2018/03/10|2019/03/10|||ORA_SPEC_COMPLT_ELSEWHERE|comment
MERGE|LearningRecord||2017/01/01||LRN_MF_07042004|OLC928002|ORA_COURSE|HDL_CRS_0704|ORA_REQUIRE_ASSIGNMENT|ORA_EVT_SUBT_ADMIN|8153756|ORA_SPECIALIST|8153756|ORA_WLF_CEO_OFFICE|8153756|ORA_ASSN_REC_COMPLETE|2019/03/01|2019/03/30|||2019/03/10|2019/03/10|2020/03/10|||ORA_SPEC_COMPLT_ELSEWHERE|comment
  3. Load the LearningRecord.dat file using HCM Data Loader.
  4. Confirm that the loaded learning assignments are linked to the learning initiative.
    Go to My Client Groups > Learning and Development > Learning Initiative.
  5. For the most recent completion (2020 in this example), load the course learning assignment with LearningRecordStatus set to ORA_ASSN_REC_ACTIVE. Oracle Learning creates the assignment with a substatus of No Offering Selected. 
    METADATA|LearningRecord|LearningRecordId|LearningRecordEffectiveStartDate|LearningRecordEffectiveEndDate|LearningRecordNumber|AssignmentNumber|LearningItemType|LearningItemNumber|AssignmentType|AssignmentSubType|AssignedByPersonNumber|AssignmentAttributionType|AssignmentAttributionNumber|AssignmentAttributionCode|LearnerNumber|LearningRecordStatus|LearningRecordStartDate|LearningRecordDueDate|LearningRecordWithdrawnDate|LearningRecordDeletedDate|LearningRecordCompletionDate|LearningRecordValidFromDate|LearningRecordExpiryDate|LearningRecordTotalActualEffort|LearningRecordTotalActualEffortUOM|LearningRecordReasonCode|LearningRecordComments
MERGE|LearningRecord||2017/01/01||LRN_MF_07042018|OLC928002|ORA_COURSE|HDL_CRS_0704|ORA_REQUIRE_ASSIGNMENT|ORA_EVT_SUBT_ADMIN|8153756|ORA_SPECIALIST|8153756|ORA_WLF_CEO_OFFICE|8153756|ORA_ASSN_REC_ACTIVE|2020/03/01|2020/03/30|||||||||
  6. Load the learner's offering learning assignment with LearningRecordStatus set to ORA_ASSN_REC_ACTIVE. Oracle Learning links this offering assignment to the Active course assignment and updates the substatus of the course assignment to Not Started. 
    METADATA|LearningRecord|LearningRecordId|LearningRecordEffectiveStartDate|LearningRecordEffectiveEndDate|LearningRecordNumber|AssignmentNumber|LearningItemType|LearningItemNumber|AssignmentType|AssignmentSubType|AssignedByPersonNumber|AssignmentAttributionType|AssignmentAttributionNumber|AssignmentAttributionCode|LearnerNumber|LearningRecordStatus|LearningRecordStartDate|LearningRecordDueDate|LearningRecordWithdrawnDate|LearningRecordDeletedDate|LearningRecordCompletionDate|LearningRecordValidFromDate|LearningRecordExpiryDate|LearningRecordTotalActualEffort|LearningRecordTotalActualEffortUOM|LearningRecordReasonCode|LearningRecordComments
MERGE|LearningRecord||2017/01/01||LRN_MF_07042027|AN_MF_07042027|ORA_CLASS|HDL_CRS_0704_OF1|ORA_REQUIRE_ASSIGNMENT|ORA_EVT_SUBT_ADMIN|8153756|ORA_SPECIALIST|8153756|ORA_WLF_CEO_OFFICE|8153756|ORA_ASSN_REC_ACTIVE|2020/03/01|2020/03/30|||||||||
  7. Load the offering activities using the LearningRecordActivityAttempt.dat file. Set ActivityAttemptStatus to ORA_ASSN_TASK_COMPLETED and provide the course completion date as the ActivityAttemptDate value. 
    METADATA|LearningRecordActivityAttempt|ActivityAttemptId|LearningRecordId|LearningRecordNumber|ActivityId|ActivityNumber|ActivityAttemptStatus|ActivityAttemptDate|ActivityAttemptReasonCode|ActivityAttemptActualScore|ActivityAttemptActualEffort|ActivityAttemptNote
MERGE|LearningRecordActivityAttempt|||LRN_MF_07042027||HDL_CRS_0704_OF1_A1|ORA_ASSN_TASK_COMPLETED|2020/03/09||||

    After the file successfully loads, Oracle Learning sets the offering assignment status to Completed and the corresponding course assignment status to Completed. It then evaluates the initiative renewal rules and creates the next appropriate course assignment with a substatus of No Offering Selected.

    The learning initiative used for this load doesn't behave like a regular learning initiative because the assignments are linked to the initiative using HCM Data Loader rather than created from its learner audience:

    • The Select Learners page doesn't list the learners whose assignments were loaded and linked to the initiative.
    • Changes to the initiative don't apply to the learners whose assignments were loaded and linked to it.
    • The initiative isn't dynamic because you didn't define dynamic person criteria when you created it.

    To make the learning initiative dynamic:

    1. Go to My Client Groups > Learning and Development > Learning Initiatives
    2. Edit the existing initiative and add the appropriate dynamic person criteria. For example, identify learners by department or job role. Learners are added when they meet the criteria and removed when they no longer meet it.
    3. In the advanced rules, select Withdraw assignments of incomplete learners no longer a part of the learning initiative target audience.
    4. Submit your changes.
    5. Manually withdraw the learners whose assignments were loaded and linked to the initiative using HCM Data Loader. These learners aren't listed on the Select Learners page, so the new dynamic criteria don't apply to them.

    6. Reconcile the learning initiative.

      1. Go to My Client Groups > Learning and Development > Learning Catalog.
      2. Search for and open the relevant course.
      3. On the course details page, go to the Learners > Learning Initiative tab.
      4. Search for and select the initiative.
      5. Select Actions > Reconcile Learning Assignments.