Examples of managing learning assignments on behalf of line managers using HCM Data Loader

Here are examples of how to create, update, and purge learning assignments on behalf of line managers in Oracle Learning using the LearningRecord object and HCM Data Loader.

Create a learning assignment

Here's how you can create a required course assignment with an Active status.

METADATA|LearningRecord|LearningRecordId|LearningRecordEffectiveStartDate|LearningRecordEffectiveEndDate|LearningRecordNumber|AssignmentNumber|LearningItemType|LearningItemNumber|AssignmentType|AssignmentSubType|AssignedByPersonNumber|AssignmentAttributionType|AssignmentAttributionNumber|AssignmentAttributionCode|LearnerNumber|LearningRecordStatus|LearningRecordStartDate|LearningRecordDueDate|LearningRecordWithdrawnDate|LearningRecordDeletedDate|LearningRecordCompletionDate|LearningRecordValidFromDate|LearningRecordExpiryDate|LearningRecordReasonCode|LearningRecordComments|ActualScore|LearningRecordPurgeFlag

MERGE|LearningRecord||2023/06/07||LRN-060720211-HDL|ASN-060720211-HDL|ORA_COURSE|OLC199059|ORA_REQUIRE_ASSIGNMENT|ORA_EVT_SUBT_MANAGER|300100010473116|ORA_PERSON|300100010473116||300100010473118|ORA_ASSN_REC_ACTIVE|2023/06/07|2023/06/30|||||||Course Req Active Asgn||

Update a learning assignment

Here's how you can update a course assignment status from Active to Completed.

METADATA|LearningRecord|LearningRecordId|LearningRecordEffectiveStartDate|LearningRecordEffectiveEndDate|LearningRecordNumber|AssignmentNumber|LearningItemType|LearningItemNumber|AssignmentType|AssignmentSubType|AssignedByPersonNumber|AssignmentAttributionType|AssignmentAttributionNumber|AssignmentAttributionCode|LearnerNumber|LearningRecordStatus|LearningRecordStartDate|LearningRecordDueDate|LearningRecordWithdrawnDate|LearningRecordDeletedDate|LearningRecordCompletionDate|LearningRecordValidFromDate|LearningRecordExpiryDate|LearningRecordReasonCode|LearningRecordComments|ActualScore|LearningRecordPurgeFlag

MERGE|LearningRecord||2023/06/07||LRN-060720211-HDL|ASN-060720211-HDL|ORA_COURSE|OLC199059|ORA_REQUIRE_ASSIGNMENT|ORA_EVT_SUBT_MANAGER|300100010473116|ORA_PERSON|300100010473116||300100010473118|ORA_ASSN_REC_COMPLETE|||||||||Course Req Active Asgn||

Purge a learning assignment

Here's how you can purge the deleted course assignment by setting LearningRecordPurgeFlag to Y.

METADATA|LearningRecord|LearningRecordId|LearningRecordEffectiveStartDate|LearningRecordEffectiveEndDate|LearningRecordNumber|AssignmentNumber|LearningItemType|LearningItemNumber|AssignmentType|AssignmentSubType|AssignedByPersonNumber|AssignmentAttributionType|AssignmentAttributionNumber|AssignmentAttributionCode|LearnerNumber|LearningRecordStatus|LearningRecordStartDate|LearningRecordDueDate|LearningRecordWithdrawnDate|LearningRecordDeletedDate|LearningRecordCompletionDate|LearningRecordValidFromDate|LearningRecordExpiryDate|LearningRecordReasonCode|LearningRecordComments|ActualScore|LearningRecordPurgeFlag

MERGE|LearningRecord||2023/06/07||LRN-060720211-HDL|ASN-060720211-HDL|ORA_COURSE|OLC199059|ORA_REQUIRE_ASSIGNMENT|ORA_EVT_SUBT_MANAGER|300100010473116|ORA_PERSON|300100010473116||300100010473118|ORA_ASSN_REC_DELETE|||||||||Course Req Active Asgn||Y