1. HCM Data Loading Business Objects
  2. Load midstream legacy assignments to Oracle Learning without eLearning completion details

Load midstream legacy assignments to Oracle Learning without eLearning completion details

Use the LearningRecord object and HCM Data Loader to load midstream legacy assignments for eLearning with a renewal configuration when you don't need to load completion details.

Learners can't review the eLearning content for these completed assignments in their learning history.

  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.

    If you're loading completions for recurring learning, define the appropriate renewal rules for the initiative.

    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. Load completed legacy learning assignments, if you haven't already done so.
  3. 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. 
    METADATA|LearningRecord|LearningRecordId|LearningRecordEffectiveStartDate|LearningRecordEffectiveEndDate|LearningRecordNumber|AssignmentNumber|LearningItemType|LearningItemNumber|AssignmentType|AssignmentSubType|AssignmentSourceType|AssignmentSourceId|AssignmentSourceInfo|AssignedByPersonNumber|AssignmentAttributionType|AssignmentAttributionNumber|AssignmentAttributionCode|LearnerNumber|LearningRecordStatus|LearningRecordSourceType|LearningRecordSourceId|LearningRecordSourceInfo|LearningRecordStartDate|LearningRecordDueDate|LearningRecordWithdrawnDate|LearningRecordDeletedDate|LearningRecordCompletionDate|LearningRecordValidFromDate|LearningRecordExpiryDate|LearningRecordTotalActualEffort|LearningRecordTotalActualEffortUOM|RequestDetailStartDate|RequestDetailCompletionDate|RequestDetailComments|RequestDetailPONumber|LearningRecordReasonCode|LearningRecordComments
MERGE|LearningRecord||2020/01/27||LRNMegMidComp4a|OLC22274002|ORA_COURSE|DSS-COURSE-WLF794-070801-HDL|ORA_REQUIRE_ASSIGNMENT|ORA_EVT_SUBT_ADMIN||||10034|ORA_SPECIALIST|10034|ORA_WLF_CEO_OFFICE|10034|ORA_ASSN_REC_COMPLETE||||2019/01/07|2019/05/01|||2019/04/01|2019/01/07|2019/05/01|10|ORA_DUR_HOUR|||||ORA_SPEC_COMPLT_ELSEWHERE|comments
MERGE|LearningRecord||2020/01/27||LRNMegMidFuture4a|OLC22274002|ORA_COURSE|DSS-COURSE-WLF794- 070801-HDL|ORA_REQUIRE_ASSIGNMENT|ORA_EVT_SUBT_ADMIN||||10034|ORA_SPECIALIST|10034|ORA_WLF_CEO_OFFICE|10034|ORA_ASSN_REC_ACTIVE||||2020/01/29|2020/12/01||||||10|ORA_DUR_HOUR||||||
MERGE|LearningRecord||2020/01/27||LRNRaviMidComp4a|OLC22274002|ORA_COURSE|DSS-COURSE-WLF794-070801-HDL|ORA_REQUIRE_ASSIGNMENT|ORA_EVT_SUBT_ADMIN||||10034|ORA_SPECIALIST|10034|ORA_WLF_CEO_OFFICE|10 045|ORA_ASSN_REC_COMPLETE||||2019/01/07|2019/05/01|||2019/04/10|2019/01/07|2019/05/01|10|ORA_DUR_HOUR|||||ORA_SPEC_COMPLT_ELSEWHERE|comments
MERGE|LearningRecord||2020/01/27||LRNRaviMidCurr4a|OLC22274002|ORA_COURSE|DSS-COURSE-WLF794-070801-HDL|ORA_REQUIRE_ASSIGNMENT|ORA_EVT_SUBT_ADMIN||||10034|ORA_SPECIALIST|10034|ORA_WLF_CEO_OFFICE|10045|ORA_ASSN_REC_ACTIVE||||2019/05/01|2020/12/01||||||10|ORA_DUR_HOUR||||||
MERGE|LearningRecord||2020/01/27||LRNKlausMidCurr4a|OLC22274002|ORA_COURSE|DSS-COURSE-WLF794-070801-HDL|ORA_REQUIRE_ASSIGNMENT|ORA_EVT_SUBT_ADMIN||||10034|ORA_SPECIALIST|10034|ORA_WLF_CEO_OFFICE|10046|ORA_ASSN_REC_ACTIVE||||2019/05/01|2020/05/01||||||10|ORA_DUR_HOUR||||||e
  4. Load the LearningRecord.dat file using HCM Data Loader.
  5. Confirm that the loaded learning assignments are linked to the learning initiative.
    Go to My Client Groups > Learning and Development > Learning Initiatives.

Results:

When a learner with a midstream assignment completes the assignment, Oracle Learning evaluates the initiative renewal rules and creates the next appropriate assignment.