Guidelines for Loading Course and Specialization Prerequisites to Oracle Learning

You can load prerequisite profiles using the TalentProfile object and a ProfileUsageCode value of PR. Use the ProfileItem child object to create each individual prerequisite.

For example, a course has a prerequisite of English language. You create a TalentProfile object with a ProfileUsageCode value of PR and a child ProfileItem object with the content type Language, as shown in the sample .dat file.

Note: The TalentProfile object, SourceSystemId attribute acts a parent (ProfileId) for the ProfileItem object. To determine what attributes you need to set for a particular content type, see the Enhanced Profiles Section Templates Descriptions document.

Sample Prerequisite TalentProfile.dat File

COMMENT Create profile for learning prerequisite METADATA|TalentProfile|Description|OwnerPersonId|PartyId|PersonId|ProfileCode|ProfileId|ProfileStatusCode|ProfileTypeId|ProfileUsageCode|Summary|SourceSystemOwner|SourceSystemI
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|It emDate10|ItemDate2|ItemDate3|ItemDate4|ItemDate5|ItemDate6|ItemDate7|ItemDate8|ItemDate9|ItemDecimal1|ItemDeci mal2|ItemDecimal3|ItemDecimal4|ItemDecimal5|ItemNumber1|ItemNumber10|ItemNumber2|ItemNumber3|ItemNumber4| ItemNumber5|ItemNumber6|ItemNumber7|ItemNumber8|ItemNumber9|ItemText20001|ItemText20002|ItemText20003|It emText20004|ItemText20005|ItemText2401|ItemText24010|ItemText24011|ItemText24012|ItemText24013|ItemText24014| ItemText24015|ItemText2402|ItemText2403|ItemText2404|ItemText2405|ItemText2406|ItemText2407|ItemText2408|Ite mText2409|ItemText301|ItemText3010|ItemText3011|ItemText3012|ItemText3013|ItemText3014|ItemText3015|ItemText302
|ItemText303|ItemText304|ItemText305|ItemText306|ItemText307|ItemText308|ItemText309|Mandatory|ParentProfileIte mId|ProfileId(SourceSystemId)|ProfileItemId|QualifierId1|QualifierId2|RatingLevelId1|RatingLevelId2|RatingLevelId3|Ratin gModelId1|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