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 activity attempts using OTBI

To update an activity attempt using LearningRecordActivityAttemptV3, identify it using either the ActivityAttemptId or ActivityAttemptNumber value. These values aren't available in 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.

Tip: To distinguish learner attempts from observer attempts, include Activity Attempt Assignee and Activity Attempt Assignee Type in the analysis.

Validations

Here's how the load process validates activity attempts:

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.
Checks whether the attempt is already Completed, Exempted, or Not Passed. If yes, it doesn't update the ActivityAttemptStatus value.

Example of updating an attempt

You can update learner activity attempts and learner and observer attempts for observation checklist activities. Here's an example of updating learning activity attempts.

METADATA|LearningRecordActivityAttemptV3|ActivityAttemptId|ActivityAttemptNumber|LearningRecordId|LearningRecordNumber|ActivityId|ActivityNumber|ActivityAttemptStatus|ActivityAttemptDate|ActivityAttemptReasonCode|ActivityAttemptActualScore|ActivityAttemptActualEffort|ActivityAttemptNote
MERGE|LearningRecordActivityAttemptV3||OLC8148976||OLC11314157||OLC516028|ORA_ASSN_TASK_COMPLETED|2022/01/20|ORA_SP_COMPLT_HIGH_CERT||2|Admin completion notes 
MERGE|LearningRecordActivityAttemptV3||OLC8148975||OLC11314157||OLC517057|ORA_ASSN_TASK_COMPLETED|2021/01/20|ORA_SP_COMPLT_ELSEWHERE||3|Admin completion notes