1. HCM Data Loading Business Objects
  2. Guidelines for loading course and learning path prerequisites using TalentProfile

Guidelines for loading course and learning path prerequisites using TalentProfile

Use the TalentProfile object and HCM Data Loader to load prerequisites for courses and learning paths in Oracle Learning.

Set ProfileUsageCode to PR for the prerequisite profile, and use a child ProfileItem object for each individual prerequisite. For example, if a course requires English language proficiency, create a TalentProfile object with ProfileUsageCode set to PR. Then create a child ProfileItem object for the Language content type and specify English. Use the TalentProfile SourceSystemId value as the ProfileId(SourceSystemId) value for the child ProfileItem object.

The ProfileItem attributes you need depend on the content type. For details, see Enhanced Profiles Section Templates Descriptions.

Example of loading a course prerequisite

This example creates a prerequisite profile and adds English as a Language prerequisite.

COMMENT Create profile for learning prerequisite
METADATA|TalentProfile|Description|OwnerPersonId|PartyId|PersonId|ProfileCode|ProfileId|ProfileStatusCode|ProfileTypeId|ProfileUsageCode|Summary|SourceSystemOwner|SourceSystemID
MERGE|TalentProfile|Learning Prerequisite profile||||LEARN_PREREQ_HDL_3103||A|2|PR|This is a Prerequisite profile|HCMQA-001|TPPR050420211

COMMENT Create profile item for prerequisite profile with Language = English
METADATA|ProfileItem|ContentItemId|ContentTypeId|CountryId|DateFrom|DateTo|Importance|InterestLevel|ItemDate1|ItemDate10|ItemDate2|ItemDate3|ItemDate4|ItemDate5|ItemDate6|ItemDate7|ItemDate8|ItemDate9|ItemDecimal1|ItemDecimal2|ItemDecimal3|ItemDecimal4|ItemDecimal5|ItemNumber1|ItemNumber10|ItemNumber2|ItemNumber3|ItemNumber4|ItemNumber5|ItemNumber6|ItemNumber7|ItemNumber8|ItemNumber9|ItemText20001|ItemText20002|ItemText20003|ItemText20004|ItemText20005|ItemText2401|ItemText24010|ItemText24011|ItemText24012|ItemText24013|ItemText24014|ItemText24015|ItemText2402|ItemText2403|ItemText2404|ItemText2405|ItemText2406|ItemText2407|ItemText2408|ItemText2409|ItemText301|ItemText3010|ItemText3011|ItemText3012|ItemText3013|ItemText3014|ItemText3015|ItemText302|ItemText303|ItemText304|ItemText305|ItemText306|ItemText307|ItemText308|ItemText309|Mandatory|ParentProfileItemId|ProfileId(SourceSystemId)|ProfileItemId|QualifierId1|QualifierId2|RatingLevelId1|RatingLevelId2|RatingLevelId3|RatingModelId1|RatingModelId2|RatingModelId3|SourceId|SourceKey1|SourceKey2|SourceKey3|SourceType|StateProvinceId|SectionId|SourceSystemOwner|SourceSystemId
MERGE|ProfileItem|109000016|109||2000/01/01||2|||||||||||||||||||||||||||||||||||||||||||||||||||||||Y|Y||||||Y||TPPR050420211||||8002|8001|8003|8|8|8|||||||9903|HCMQA-001|PIPR050420211

Related Topics