Guidelines for Updating an Activity Attempt in Oracle Learning Using LearningRecordActivityAttemptV3

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

If you have activity sequencing turned on, you can mark learning assignments as Complete using the LearningRecordActivityAttemptV3 object. If it's turned off, use the LearningRecordActivityAttempt object.

To verify that the activity attempt successfully loaded and assignment statuses successfully changed, use the Learning Assignments task and Manage Activities action on the My Client Groups > Learning page.

ActivityAttemptID or ActivityAttemptNumber from OTBI Analysis

To use LearningRecordActivityAttemptV3, you need to uniquely identify the rows to update using either the ActivityAttemptId or the ActivityAttemptNumber (the user key) attribute value. Since these attributes aren't exposed in Oracle Learning, you need to get the value using an Oracle Transactional Business Intelligence (OTBI) analysis. The attributes are in the Workforce Learning - Learning Records Real Time subject area in the Completion Information > Completion Details > Learner Activity Attempt Information folder. To get a list of all activity attempts for a learner by course, you can use Course Enrollment Number as a filter condition.

Tip: To distinguish between learner and observer attempts, we recommend that you include Activity Attempt Assignee and Activity Attempt Assignee Type in your analysis.

Validations

The load process does these validations:

• When updating activity attempts for observation checklists, it ignores any Score attribute values.
• When learner checklist is enabled, confirms that the learner attempt on an observation check list 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.
• Doesn't update the ActivityAttemptStatus value of attempts already in Completed, Exempted, or Not Passed status.

.dat File Structure with Attributes

METADATA|LearningRecordActivityAttemptV3|ActivityAttemptId|ActivityAttemptNumber|LearningRecordId|LearningRecordNumber|ActivityId|ActivityNumber|ActivityAttemptStatus|ActivityAttemptDate|ActivityAttemptReasonCode|ActivityAttemptActualScore|ActivityAttemptActualEffort|ActivityAttemptNote