Guidelines for Effective Start Dates in CourseV3 for Oracle Learning
When loading future-dated course, offering, sections, and activities, use the same effective date. The effective start dates of any sections and activities you're loading for an existing course and offering need to be after those course and offering dates.
Here's an example with the same future effective start date for the course, offering, section, and activity:
METADATA|CourseV3|EffectiveStartDate|EffectiveEndDate|CourseNumber|Title|ShortDescription|Syllabus|PublishStartDate|OwnedByPersonNumber|SourceSystemOwner|SourceSystemId|PublishEndDate|MinimumExpectedEffort|MaximumExpectedEffort|FLEX:WLF_LI_COURSE|compliance(WLF_LI_COURSE=Global Data Elements)|rolerequired(WLF_LI_COURSE=Global Data Elements)|CurrencyCode|MinimumPrice|MaximumPrice
MERGE|CourseV3|2023/01/24||C_KSP_TEVA_PV|Teva PV Training|Teva PV awareness training 2021 for vendors||1951/01/01|554872|KNOWME|Course_C_KSP_TEVA_PV||0.1|0.1|Global Data Elements|Yes|Yes|||
METADATA|OfferingV3|EffectiveStartDate|EffectiveEndDate|OfferingStartDate|OfferingEndDate|OfferingNumber|CoordinatorNumber|Title|OfferingType|PublishStartDate|LanguageCode|CourseNumber|OwnedByPersonNumber|EnableCapacity|Description|DescriptionText|MinimumCapacity|MaximumCapacity|EnableWaitlist|PrimaryLocationNumber|PrimaryInstructorNumber|FacilitatorType|SourceSystemOwner|SourceSystemId
MERGE|OfferingV3|2022/01/18||2023/01/24||O_C_KSP_TEVA_PV|554872|Teva PV Training|ORA_SP|1951/01/01|US|C_KSP_TEVA_PV|554872||DESC_C_KSP_TEVA_PV.txt|Teva PV awareness training 2021 for vendors|||||||KNOWME|COF_O_C_KSP_TEVA_PV_ORA_SP
METADATA|OfferingActivitySectionV3|OfferingSectionId|EffectiveStartDate|EffectiveEndDate|OfferingSectionNumber|SourceSystemOwner|SourceSystemId|GUID|Title|Description|NumberOfActivitiesToComplete|CompletionRuleType|OfferingId|SectionPosition|SequenceRuleType|OfferingNumber|DescriptionText|SequenceRuleSectionNumber
MERGE|OfferingActivitySectionV3||2023/01/24||O_C_KSP_TEVA_PV_SEC||||Default Section|||ORA_COMPLETION_ACTIVITY||1|ORA_SECTION_ANYTIME|O_C_KSP_TEVA_PV||
METADATA|SelfPacedActivityV3|ActivityId|EffectiveStartDate|EffectiveEndDate|ActivityNumber|ExpectedEffort|SourceInfo|SourceType|SourceId|SourceSystemOwner|SourceSystemId|GUID|Title|Description|ContentId|CompletionRuleType|SelfCompleteFlag|OfferingSectionId|ActivityPosition|SequenceRuleType|OfferingSectionNumber|DescriptionText|ContentNumber|SequenceRuleActivityNumber
MERGE|SelfPacedActivityV3||2023/01/24||O_C_KSP_TEVA_PV_SEC_A01||||||||Activity 3|||ORA_REQUIRED|Y||3||O_C_KSP_TEVA_PV_SEC|||Here's an example where the effective start dates of the section and activity are after those of the existing course and offering:
METADATA|CourseV3|EffectiveStartDate|EffectiveEndDate|CourseNumber|Title|ShortDescription|Syllabus|PublishStartDate|OwnedByPersonNumber|SourceSystemOwner|SourceSystemId|PublishEndDate|MinimumExpectedEffort|MaximumExpectedEffort|FLEX:WLF_LI_COURSE|compliance(WLF_LI_COURSE=Global Data Elements)|rolerequired(WLF_LI_COURSE=Global Data Elements)|CurrencyCode|MinimumPrice|MaximumPrice
MERGE|CourseV3|1951/01/01||C_KSP_TEVA_PV|Teva PV Training|Teva PV awareness training 2021 for vendors||1951/01/01|554872|KNOWME|Course_C_KSP_TEVA_PV||0.1|0.1|Global Data Elements|Yes|Yes|||
METADATA|OfferingV3|EffectiveStartDate|EffectiveEndDate|OfferingStartDate|OfferingEndDate|OfferingNumber|CoordinatorNumber|Title|OfferingType|PublishStartDate|LanguageCode|CourseNumber|OwnedByPersonNumber|EnableCapacity|Description|DescriptionText|MinimumCapacity|MaximumCapacity|EnableWaitlist|PrimaryLocationNumber|PrimaryInstructorNumber|FacilitatorType|SourceSystemOwner|SourceSystemId
MERGE|OfferingV3|2022/01/18||2022/11/21||O_C_KSP_TEVA_PV|554872|Teva PV Training|ORA_SP|1951/01/01|US|C_KSP_TEVA_PV|554872||DESC_C_KSP_TEVA_PV.txt|Teva PV awareness training 2021 for vendors|||||||KNOWME|COF_O_C_KSP_TEVA_PV_ORA_SP
METADATA|OfferingActivitySectionV3|OfferingSectionId|EffectiveStartDate|EffectiveEndDate|OfferingSectionNumber|SourceSystemOwner|SourceSystemId|GUID|Title|Description|NumberOfActivitiesToComplete|CompletionRuleType|OfferingId|SectionPosition|SequenceRuleType|OfferingNumber|DescriptionText|SequenceRuleSectionNumber
MERGE|OfferingActivitySectionV3||2023/01/24||O_C_KSP_TEVA_PV_SEC||||Default Section|||ORA_COMPLETION_ACTIVITY||1|ORA_SECTION_ANYTIME|O_C_KSP_TEVA_PV||
METADATA|SelfPacedActivityV3|ActivityId|EffectiveStartDate|EffectiveEndDate|ActivityNumber|ExpectedEffort|SourceInfo|SourceType|SourceId|SourceSystemOwner|SourceSystemId|GUID|Title|Description|ContentId|CompletionRuleType|SelfCompleteFlag|OfferingSectionId|ActivityPosition|SequenceRuleType|OfferingSectionNumber|DescriptionText|ContentNumber|SequenceRuleActivityNumber
MERGE|SelfPacedActivityV3||2023/01/24||O_C_KSP_TEVA_PV_SEC_A01||||||||Activity 3|||ORA_REQUIRED|Y||3||O_C_KSP_TEVA_PV_SEC|||