1. HCM Data Loading Business Objects
  2. Example of Loading Midstream Legacy Assignments Without eLearning Completion Details to Oracle Learning

Example of Loading Midstream Legacy Assignments Without eLearning Completion Details to Oracle Learning

Use these steps to load in legacy learning assignments for eLearning with a renewal configuration, when you don't need to load completion details.

Learners won't be able to review the eLearning content for these completed assignments in their learning history.
  1. Create an initiative with a dummy learner audience object, such as an analysis or organization chart. You use this object to link the appropriate group of learners to the initiative. We recommend that you create a dummy object without any records in it, and link it to the initiative. That way you create an initiative without any associated learners and you can use the initiative number in the LearningRecord.dat file.
    When you create this initiative, if you'll load completions for a recurring learning, make sure that you define the appropriate renewal rules for the initiative. Also when you create the initiative, make sure that Learner Reconciliation isn't selected. This way learners aren't withdrawn if you have reconciliation processes scheduled to run at regular intervals. Normally, the reconciliation processes look at the learner audience for the initiative and reconciles what assignments exist for identified learners. If identified learners don't have assignments, the process creates assignments. If the process doesn't identify any learners, but assignments exist and Learner Reconciliation is selected, the process withdraws the assignments. If Learner Reconciliation isn't selected, the process doesn't withdrawn learner assignments.
  2. Load completed legacy learning assignments, if you haven't already done so.
  3. Create the LearningRecord.dat file and include the initiative number in the Assignment Number field. Include the course number in the Learning Item Number field. The statuses of in-progress assignments should be Active. The statuses of future-dated assignments should be Not Started. 
    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.
  5. Confirm that the learner is in the audience for the learning initiative. Use the Learning Initiative task on the My Client Groups > Learning page.

Results:

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