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

Date Validations Done When Loading Oracle Learning Assignments and Recommendations

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

  • The provided dates for these attributes are before today's date:

    • EffectiveStartDate (and before the LearningRecordStartDate date)
    • LearningRecordStartDate (and before the LearningRecordDueDate, LearningRecordRequestApprovedDate, and LearningRecordWithdrawnDate dates, as applicable)
    • LearningRecordDueDate
    • LearningRecordCompletionDate, when LearningRecordStatus is ORA_ASSN_REC_COMPLETE (required completed) (and before the LearningRecordExpiryDate date)
    • LearningRecordRequestApprovedDate
  • The EffectiveEndDate date is after today's date and the LearningRecordDueDate date
  • The EffectiveStartDate and EffectiveEndDate dates aren't the same
  • The LearningRecord EffectiveStartDate and EffectiveEndDate dates are between the LearningItem EffectiveStartDate and EffectiveEndDate dates
  • The provided LearningRecordCompletionDate and LearningRecordWithdrawnDate values are before the LearningRecordExpiryDate date when AssignmentType is ORA_REQUIRE_ASSIGNMENT (required)

  • The dates for these attributes aren't null or empty:

    • LearningRecordDueDate, when AssignmentType is ORA_REQUIRE_ASSIGNMENT (required)
    • LearningRecordCompletionDate, when LearningRecordStatus is ORA_ASSN_REC_COMPLETE (required completed)
    • LearningRecordWithdrawnDate, when LearningRecordStatus is ORA_ASSN_REC_WITHDRAWN (required withdrawn)
    • LearningRecordDeletedDate, when LearningRecordStatus is ORA_ASSN_REC_DELETED (required deleted)
    • LearningRecordValidFromDate, when LearningRecordStatus is ORA_ASSN_REC_COMPLETE (required completed) and AssignmentType is ORA_REQUIRE_ASSIGNMENT (required)
    • LearningRecordExpiryDate, when LearningRecordStatus is ORA_ASSN_REC_COMPLETE (required completed), AssignmentType is ORA_REQUIRE_ASSIGNMENT (required), and the learning item has a renewal configuration
    • LearningRecordRequestApprovedDate, when LearningRecordStatus is ORA_ASSN_REQ_APPROVED (request approved)
  • The LearningRecordCompletionDate or LearningRecordWithdrawnDate date is before the LearningRecordExpiryDate date when AssignmentType is ORA_REQUIRE_ASSIGNMENT (required)
  • If you include times as part of the LearningRecordCompletionDate or LearningRecordWithdrawnDate date, they need to be in the 24-hour format, such as 2021/05/05 17:20:03. Also, the times need to be for the UTC time zone, regardless of the learner's actual time zone.

  • For noncatalog learning these dates are the same:

    • RequestDetailStartDate and LearningRecordStartDate
    • RequestDetailCompletionDate and LearningRecordCompletionDate