Guidelines for Purging Oracle Learning Assignments
You can purge, or permanently delete, any types of learning assignments with a Deleted status from Oracle Learning. This means course, offering, specialization, legacy, noncatalog, and self-service learning.
Purging a Deleted assignment also purges any of this related data:
- Complete date-effective history.
- Event assignment profile, including request details and assignment rules data, when the assignment profile links to only the current learning assignment. If the assignment profile also links to other assignments, the assignment profile data isn't purged.
- Assignment tasks-related data.
- Related offering assignments and related data are purged when you purge the corresponding course assignment. This happens only when the course and offering assignments are eligible for purge and have the Deleted status.
Course and Offering Assignment
When a course assignment links to multiple offering assignments, purging one of the offering assignments won't affect the other linked offering assignments, regardless of their statuses. Also, purging an offering assignment won't purge the corresponding course assignment. But purging a course assignment also recursively purges the linked offering assignments and their related data, as long as all offering assignments have a Deleted status. If even one offering assignment has a different status, the purge ends in error.
Learning Initiative Assignments
Purging a course or specialization assignment linked to a learning initiative doesn't affect other learning assignments linked to the initiative.
Sample .dat File
COMMENT COURSE LEARNING RECORD PURGE
METADATA|LearningRecord|LearningRecordId|LearningRecordEffectiveStartDate|LearningRecordEffectiveEndDate|LearningRecordNumber|AssignmentNumber|LearningItemType|LearningItemNumber|LearnerNumber|LearningRecordStatus|LearningRecordPurgeFlag
DELETE|LearningRecord||2021/03/11||OLC207847|OLC207848|ORA_COURSE|OLC397407|8153756|ORA_ASSN_REC_DELETED|Y