Supported Create and Update Statuses When Loading Learning Assignments on Behalf of Line Managers

Here are the learning assignments and recommendations that you can create on behalf of line managers for each type of valid learning, in Oracle Learning. You can also see the assignment and recommendation statuses that you can update for that learning type.

Tip: Use the ORA_EVT_SUBT_MANAGER assignment subtype.

Course Assignments

Type Assignments You can Create Updates You Can Make
Required or Voluntary Active Active to Completed or Bypass Completed
Active to Withdrawn
Active to Delete
Completed or Bypass Completed to Active
Completed or Bypass Completed to Delete
Withdrawn to Delete
Delete to Purge

Here's what the load process does if sequencing exists and you create a required course assignment and the learner has a completed and unexpired assignment for the same course:

  • Creates a course assignment with an Active status, which forces the learner to complete the course again
  • Expires the existing completed learning assignment with an expiration date that's the same as the due date (LearningRecordDueDate) of the new course assignment

And here's what the load process does if sequencing exists you create a voluntary course assignment and the learner has a completed and unexpired assignment for the same course:

  • Creates a course assignment with an Active status
  • Expires the existing completed learning assignment with an expiration date that's the same as the start date (LearningRecordStartDate) of the new course assignment

If sequencing doesn't exist, the load process creates the course assignment with a Completed status.

Offering Assignments

Assignment Type Assignments You can Create Updates You Can Make
Required or Voluntary Active Active to Withdrawn
Active to Delete
Completed to Delete
Withdrawn to Delete
Delete to Purge

You can't load active offering assignments for a learner whose employment was terminated. Also, as the table shows, you can't create a Completed offering assignment for any learner. You can load Completed assignments at the course level, as shown in the table of the preceding Course Assignments section. Then use the ActualScore attribute in the LearningRecord.dat file to load a passing score for the corresponding offering assignment.

Here's what the load process does if sequencing exists and you create a required offering assignment and the learner has a completed and unexpired assignment for the same offering:

  • Creates an offering assignment with an Active status, which forces the learner to complete the offering again
  • Expires the existing completed learning assignment with an expiration date that's the same as the due date (LearningRecordDueDate) of the new offering assignment

And here's what the load process does if sequencing exists, you create a voluntary offering assignment, and the learner has a completed, unexpired assignment for the same offering:

  • Creates an offering assignment with an Active status
  • Expires the existing completed learning assignment with an expiration date that's the same as the start date (LearningRecordStartDate) of the new offering assignment

If sequencing doesn't exist, the load process creates the offering assignment with a Completed status.

Specialization Assignments

Type Assignments You can Create Updates You Can Make
Required or Voluntary Active Active to Completed or Bypass Completed
Active to Withdrawn
Active to Delete
Completed or Bypass Completed to Active
Completed or Bypass Completed to Delete
Withdrawn to Delete
Delete to Purge

Video or Learning Journey Assignments

Type Assignments You can Create Updates You Can Make
Required or Voluntary Active Active to Withdrawn
Delete to Purge

Noncatalog Learning Assignments

Type Assignments You can Create Updates You Can Make
Required or Voluntary Request Approved Request Approved to Delete
Completed or Bypass Completed Completed or Bypass Completed to Delete