1. HCM Data Loading Business Objects
  2. General Validations Done When Loading Oracle Learning Assignments and Recommendations

General Validations Done When Loading Oracle Learning Assignments and Recommendations

The HCM Data Loader process for the LearningRecord object does these general validations:

  • The values for these attributes aren't null:

    • AssignmentNumber
    • LearningRecordNumber
    • EffectiveStartDate
    • LearningItemType
    • LearningItemNumber
    • AssignmentType
    • AssignmentSubType
    • AssignedByPersonNumber
    • AssignmentAttributionType
    • AssignmentAttributionNumber
    • AssignmentAttributionCode

    • LearnerNumber

      • LearningRecordStatus
      • LearningRecordStartDate
  • The LearningRecordReasonCode and LearningRecordComments values aren't null when the learning assignment status is Withdrawn or Deleted. They also can't be null when the status is Completed and AssignmentAttributionType is ORA_SPECIALIST
  • The LearningRecordNumber value doesn't start with OLC

  • That various values are valid:

    • AssignmentType: ORA_REQUIRE_ASSIGNMENT (required), ORA_JOIN_ASSIGNMENT (voluntary), or ORA_RECOMMEND_ASSIGNMENT (recommended)
    • AssignmentSubType: ORA_EVT_SUBT_ADMIN (learning administrator) or ORA_EVT_SUBT_SELF (self). To load learning assignments on behalf of a line manager, you can use the learnerLearningRecords REST API.

    • AssignmentAttributionType: ORA_SPECIALIST (specialist) or ORA_PERSON (self)

      For required learning assignments, the process makes sure that the value is ORA_SPECIALIST.

    • LearningRecordTotalActualEffortUOM: ORA_DUR_HOUR (hour)
  • That you provide existing LearningItemNumber, AssignmentType, AssignmentSubType, AssignmentAttributionNumber values when you're updating LearningRecord attributes
  • That you provided a CPEType value when CPEPoints isn't null

The load process prevents you from creating an active course assignment when a child required or voluntary offering assignment exists in an Active or a preactive status. You need to withdraw the existing assignment before creating another assignment. The load process it also prevents you from updating the LearningRecordStatus value from Active to another status when the learning item has a renewal configuration.