1. HCM Data Loading Business Objects
  2. Guidelines for updating activity attempts using LearningRecordActivityAttemptV3

Guidelines for updating activity attempts using LearningRecordActivityAttemptV3

Use the LearningRecordActivityAttemptV3 object and HCM Data Loader to update activity attempts in Oracle Learning when activity sequencing is turned on.

To verify that the activity attempt loaded and assignment statuses changed, go to My Client Groups > Learning and Development > Learning Assignments.

To mark a learning assignment as Completed, start with the lowest-level child object, such as an activity attempt. Oracle Learning completion logic then updates the related higher-level assignments, such as the offering and course assignments.

Identify and update activity attempts

To update an activity attempt using LearningRecordActivityAttemptV3:

  • Identify the learning assignment using LearningRecordNumber. Then identify the activity using ActivityNumber or the attempt using ActivityAttemptNumber.
  • For observation checklist activities, use TaskOwner to identify the learner (ORA_LEARNER) or observer (ORA_OBSERVER) task to update.
  • For learning with a single activity, you can mark the learning assignment Completed using LearningRecord. For learning with multiple activities, update the individual activity attempts using LearningRecordActivityAttemptV3.

Activity attempt IDs and activity attempt numbers aren't available on Oracle Learning pages, so get them from an Oracle Transactional Business Intelligence (OTBI) analysis. In the Workforce Learning - Learning Records Real Time subject area, go to Completion Information → Completion Details → Learner Activity Attempt Information. To get all activity attempts for a learner and course, use Course Enrollment Number as a filter.

Validations

Here's how the load process validates activity attempts:

  • Checks whether the attempt is already Completed, Exempted, or Not Passed. If yes, it doesn't update the ActivityAttemptStatus value.
  • Ignores any Score values when updating activity attempts for observation checklists.

  • When learner checklist is enabled, confirms that the learner attempt for an observation checklist is completed before the observer activity attempt is completed.

    Make sure that the learner attempt is already completed or that the same .dat file includes the learner attempt row before the observer attempt row.

Examples of updating activity attempts

Using an activity attempt number:

METADATA|LearningRecordActivityAttemptV3|LearningRecordNumber|ActivityAttemptNumber|ActivityAttemptStatus|ActivityAttemptDate|ActivityAttemptNote
MERGE|LearningRecordActivityAttemptV3|OLC945664|OLC948143|ORA_ASSN_TASK_COMPLETED|2026/02/06|Updating activity for an event

Using an activity number:

METADATA|LearningRecordActivityAttemptV3|LearningRecordNumber|ActivityNumber|ActivityAttemptStatus|ActivityAttemptDate|ActivityAttemptNote
MERGE|LearningRecordActivityAttemptV3|OLC945654|OLC948133|ORA_ASSN_TASK_COMPLETED|2026/02/06|Updating activity using activity number for self-paced learning