Using REST APIs to Create and Manage Learning Assignment Profiles in Oracle Learning Cloud- Part 3

Oracle has provided detailed documentation on loading learning renewal assignment rules and triggering future renewals for learning initiatives. However, the setup has changed with the introduction of the Redwood Learning Catalog, including Learning Assignment Profiles.

In this document, I will explain these changes and the steps required to load Learning Assignment Profiles, historical learning assignments, and current learning assignments, as well as trigger future renewal records.

1. Define a Blank User Group

Define a User Group that are not associated with any criteria to identify the target audience.

2. Setup New Learning Assignment Profile

Get Ritwick Chatterjee’s stories in your inbox

Join Medium for free to get updates from this writer.

Remember me for faster sign in

Create a Learning Assignment Profile using the above-mentioned user group and note down the Learning Assignment Profile number. Ensure that “Withdraw active assignment for persons no longer in the audience list” is unchecked. The profile will be loaded through the REST API.

Accept:application/json
Content-Type:application/json
REST-Framework-Version:9

https://iazbqy-dev2.fa.ocs.oraclecloud.com/hcmRestApi/resources/11.13.18.05/learningAssignmentProfiles

{
  "dataSecurityPrivilege": "ORA_LEARN_SPECIALIST",
  "assignAs": "IP_MYLEARNING",
  "assignmentProfileTitle": "Expires 365 days after completion- RestAPILoad-3",
  "assignmentProfileStartDate": "2026-10-01",
  "assignmentType": "ORA_REQUIRE_ASSIGNMENT",
  "assignmentRecordStatus": "ORA_ASSN_REC_ACTIVE",

  "assignmentDueDateType": "ORA_RELATIVE_DATE",
  "assignmentDueIn": 30,
  "assignmentDueInUnits": "ORA_DAYS",

  "processingRule": "ORA_WLF_ASSGN_PRULE_AUTOMATIC",
  "processingFrequency": "ORA_WLF_ASSGN_PRO_FREQ_DEFAULT",
  "ongoingDueDateType": "ORA_RELATIVE_DATE",
  "ongoingDueIn": 30,
  "ongoingDueInUnits": "ORA_DAYS",
  "withdrawOnProcessing": "N",

  "enableRenewals": "Y",
  "validityPeriodBeginRule": "ORA_AFT_COMP",
  "validityPeriodExpiryRule": "ORA_EXP_RELATIVE_DATE",
  "renewalPeriod": "ORA_REL_TO_PRIOR_COMPLETION",
  "renewalOption": "ORA_RENEW_BF",
  "dueInNumber": 365,
  "dueInUOM": "ORA_DAYS",
  "reassignNumber": 30,
  "reassignUOM": "ORA_DAYS",

  "existingCompletionValidityRule": "ORA_FORCE_RETAKE_EXP_COMPL_CD",
  "retakeRule": "ORA_RETAKE_LEARNING",
  "increaseMaximumCapacity": "N",
  "waivePrerequisites": "N",
  "withdrawOnProcessing": "N",
  "learningItemNumber": "OLC479963",

  "learningAssignmentProfileCriteria": [
    {
       "assignmentProfileCriteriaType": "ORA_LEARNING_ORGANIZATION",
       "assignmentProfileCriteriaTypeNumber": "OLC489991"

    }
  ]
}

3. Learning Assignment Load.

Load past completions, replace assignment number with learning assignment profile (will be loaded through HDL)

Load most recent record with Not Started status (will be loaded through HDL)

Update the status to Completion to trigger the renewal rule (will be loaded through HDL)

METADATA|LearningRecord|LearningRecordEffectiveStartDate|LearningRecordEffectiveEndDate|LearningRecordStartDate|LearningRecordCompletionDate|LearningRecordDueDate|LearningRecordValidFromDate|LearningRecordNumber|AssignmentNumber|LearningItemType|LearningItemNumber|AssignmentType|AssignmentSubType|AssignedByPersonNumber|AssignmentAttributionType|AssignmentAttributionNumber|AssignmentAttributionCode|LearnerNumber|LearningRecordStatus|LearningRecordReasonCode|LearningRecordComments|LearningRecordTotalActualEffort|ActualScore|SourceSystemOwner|SourceSystemId
MERGE|LearningRecord|2026/10/09||2026/10/01||2026/10/31|2026/10/01|IP_RENEWAL_105224_2026|OLC249095|ORA_ELEARNING|OLC479963|ORA_REQUIRE_ASSIGNMENT|ORA_EVT_SUBT_ADMIN|971835|ORA_SPECIALIST|971835|IP_MYLEARNING|105224|ORA_ASSN_REC_ACTIVE||This record was added as part of the Renewal test|||IPDEV2|IP_RENEWAL_105224_2026_1HDL_ID
MERGE|LearningRecord|2026/10/09||2026/10/01||2026/10/31|2026/10/01|IP_RENEWAL_309105_2026|OLC249095|ORA_ELEARNING|OLC479963|ORA_REQUIRE_ASSIGNMENT|ORA_EVT_SUBT_ADMIN|971835|ORA_SPECIALIST|971835|IP_MYLEARNING|309105|ORA_ASSN_REC_ACTIVE||This record was added as part of the Renewal test|||IPDEV2|IP_RENEWAL_309105_2026_1HDL_ID
MERGE|LearningRecord|2026/10/09||2026/10/01||2026/10/31|2026/10/01|IP_RENEWAL_267890_2026|OLC249095|ORA_ELEARNING|OLC479963|ORA_REQUIRE_ASSIGNMENT|ORA_EVT_SUBT_ADMIN|971835|ORA_SPECIALIST|971835|IP_MYLEARNING|267890|ORA_ASSN_REC_ACTIVE||This record was added as part of the Renewal test|||IPDEV2|IP_RENEWAL_267890_2026_1HDL_ID
MERGE|LearningRecord|2026/10/09||2026/10/01||2026/10/31|2026/10/01|IP_RENEWAL_975283_2026|OLC249095|ORA_ELEARNING|OLC479963|ORA_REQUIRE_ASSIGNMENT|ORA_EVT_SUBT_ADMIN|971835|ORA_SPECIALIST|971835|IP_MYLEARNING|975283|ORA_ASSN_REC_ACTIVE||This record was added as part of the Renewal test|||IPDEV2|IP_RENEWAL_975283_2026_1HDL_ID

METADATA|LearningRecordActivityAttemptV3|LearningRecordNumber|ActivityNumber|ActivityAttemptActualEffort|ActivityAttemptActualScore|ActivityAttemptDate|ActivityAttemptNote|ActivityAttemptReasonCode|ActivityAttemptStatus|SourceSystemOwner|SourceSystemId
MERGE|LearningRecordActivityAttemptV3|IP_RENEWAL_105224_2026|OLC479965|3||2026/10/09|Test For Event|ORA_ADMIN_MARK_COMPL|ORA_ASSN_TASK_COMPLETED|IPDEV2|IP_RENEWAL_105224_2026_A_HDL
MERGE|LearningRecordActivityAttemptV3|IP_RENEWAL_309105_2026|OLC479965|3||2026/10/09|Test For Event|ORA_ADMIN_MARK_COMPL|ORA_ASSN_TASK_COMPLETED|IPDEV2|IP_RENEWAL_309105_2026_A_HDL
MERGE|LearningRecordActivityAttemptV3|IP_RENEWAL_975283_2026|OLC479965|3||2026/10/09|Test For Event|ORA_ADMIN_MARK_COMPL|ORA_ASSN_TASK_COMPLETED|IPDEV2|IP_RENEWAL_975283_2026_A_HDL

Add criteria to the user group (learning assignment filtered list, worker assignment filtered list, analysis) and reconcile user group

4. Check the ““Withdraw active assignment for persons no longer in the audience list” in the learning assignment profile and save.