Using REST APIs to Create and Manage Learning Assignment Profiles in Oracle Learning Cloud- Part 2
Introduction
Learning Assignment Profiles are used to setup renewal rules. In this article, I have demonstrated different use cases of Renewal rule setup and the corresponding REST API payload that can be used to automate the setup.
Use Case 1
Expires 365 days after completion
Expires 1095 days after completion
Expires 1825 days after completion
Expires 730 days after completion
Expires 1460 days after completion
Expires 350 days after completion
Expires 355 days after completion
Setup Task
My Client Group>Learning and Development>Learning Assignment Profile
REST API
POST https://iazbqy-dev2.fa.ocs.oraclecloud.com/hcmRestApi/resources/11.13.18.05/learningAssignmentProfiles
Header
REST-Framework-Version: 9
Content-Type: application/json
Accept: application/json
Body
{
"dataSecurityPrivilege": "ORA_LEARN_SPECIALIST",
"assignAs": "IP_MYLEARNING",
"assignmentProfileTitle": "Expires 365 days after completion- RestAPILoad",
"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": "Y",
"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",
"learningItemNumber": "OLC479963",
"learningAssignmentProfileCriteria": [
{
"assignmentProfileCriteriaType": "ORA_DEST_INDIVIDUAL",
"assignmentProfileCriteriaTypeId": 300000015801532
}
]
}Post load Job
Run following process
ESS job to create index definition and perform initial ingest to OSCS with parameter as fa-hcm-learningassignmentprofile.
Assignment Profile rows
Use Case 2
Expires ON January 1 every 1 year(s)
Expires ON January 31 every 1 year(s)
Expires December 31 every 1 year.
Get Ritwick Chatterjee’s stories in your inbox
Join Medium for free to get updates from this writer.
Expires ON March 15 every 1 year(s)
Expires ON April 1 every 1 year(s)
Expires ON December 31 every 3 year(s)
Setup Task
My Client Group>Learning and Development>Learning Assignment Profile
REST API
Body
{
"dataSecurityPrivilege": "ORA_LEARN_SPECIALIST",
"assignAs": "IP_MYLEARNING",
"assignmentProfileTitle": "Expires ON January 31 every 1 year(s), No Grace period",
"assignmentProfileStartDate": "2026-09-29",
"assignmentType": "ORA_REQUIRE_ASSIGNMENT",
"assignmentRecordStatus": "ORA_ASSN_REC_ACTIVE",
"assignmentDueDateType": "ORA_RELATIVE_DATE",
"assignmentDueIn": 31,
"assignmentDueInUnits": "ORA_DAYS",
"processingRule": "ORA_WLF_ASSGN_PRULE_AUTOMATIC",
"processingFrequency": "ORA_WLF_ASSGN_PRO_FREQ_DEFAULT",
"ongoingDueDateType": "ORA_RELATIVE_DATE",
"ongoingDueIn": 31,
"ongoingDueInUnits": "ORA_DAYS",
"withdrawOnProcessing": "Y",
"enableRenewals": "Y",
"validityPeriodBeginRule": "ORA_AFT_COMP",
"validityPeriodExpiryRule": "ORA_EXP_DATE",
"validityPeriodExpiryUOM": "ORA_CAL_YEARS",
"renewalPeriod": "ORA_ANNUAL_DUE_DATE",
"renewalOption": "ORA_RENEW_BF",
"dueInNumber": 1,
"dueInUOM": "ORA_YEARS",
"dueMonth": "ORA_JAN",
"dueOnDay": 31,
"reassignNumber": 31,
"reassignUOM": "ORA_DAYS",
"existingCompletionValidityRule": "ORA_FORCE_RETAKE_EXP_COMPL_CD",
"retakeRule": "ORA_RETAKE_LEARNING",
"increaseMaximumCapacity": "N",
"waivePrerequisites": "N",
"learningItemNumber": "OLC465012",
"learningAssignmentProfileCriteria": [
{
"assignmentProfileCriteriaType": "ORA_DEST_INDIVIDUAL",
"assignmentProfileCriteriaTypeId": 300000015801532
}
]
}Post load Job
Run following process
ESS job to create index definition and perform initial ingest to OSCS with parameter as fa-hcm-learningassignmentprofile.
Assignment Profile rows
Use Case 3
Expires 36 months after completion
Setup Task
My Client Group>Learning and Development>Learning Assignment Profile
REST API
{
"dataSecurityPrivilege": "ORA_LEARN_SPECIALIST",
"assignAs": "IP_MYLEARNING",
"assignmentProfileTitle": "Expires 36 Months after Completion on Last day-REST API LOAD",
"assignmentProfileStartDate": "2026-10-04",
"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": "Y",
"enableRenewals": "Y",
"validityPeriodBeginRule": "ORA_AFT_COMP",
"validityPeriodExpiryRule": "ORA_EXP_RELATIVE_DATE",
"validityPeriodExpiryNumber": 36,
"validityPeriodExpiryUOM": "ORA_MONTHS",
"renewalPeriod": "ORA_REL_TO_PRIOR_COMPLETION",
"renewalOption": "ORA_RENEW_BF",
"dueInNumber": 36,
"dueInUOM": "ORA_MONTHS",
"reassignNumber": 30,
"reassignUOM": "ORA_DAYS",
"existingCompletionValidityRule": "ORA_FORCE_RETAKE_EXP_COMPL_CD",
"retakeRule": "ORA_RETAKE_LEARNING",
"increaseMaximumCapacity": "N",
"waivePrerequisites": "N",
"learningItemNumber": "OLC470021",
"learningAssignmentProfileCriteria": [
{
"assignmentProfileCriteriaType": "ORA_DEST_INDIVIDUAL",
"assignmentProfileCriteriaTypeId": 300000015801532
}
]
}Post load Job
Run following process
ESS job to create index definition and perform initial ingest to OSCS with parameter as fa-hcm-learningassignmentprofile.
Assignment Profile rows
In this document, I explained different use cases and how the setup will vary based on the requirements.
