Delete sections and activities in Oracle Learning offerings

Delete sections and activities from offerings using the OfferingV3 object and the appropriate section or activity component.

Delete an offering section

1. Include the parent offering in the data loader file, as shown here. If the offering is self-paced, you don't need the PrimaryLocationId and CoordinatorNumber attributes to delete a section or activity.

   METADATA|OfferingV3|EffectiveStartDate|OfferingNumber|OfferingType|CourseNumber|OwnedByPersonNumber|PrimaryLocationId|CoordinatorNumber
   MERGE|OfferingV3|2023/12/06|AV_23897731-1_ILT_OFF_01|ORA_BLENDED|AV_23897731-1|300100010473113|-1|300100010473113
   

2. Set DeleteSection to Y for the section you want to delete, as shown here. Use the device date for EffectiveStartDate.

   METADATA|OfferingActivitySectionV3|OfferingNumber|OfferingSectionNumber|EffectiveStartDate|DeleteSection
   MERGE|OfferingActivitySectionV3|AV_23897731-1_ILT_OFF_01|AV_23897731-1_ILT_OFF_01_SEC2|2024/02/06|Y
   

Delete an offering activity

1. Include the parent offering in the data loader file, as shown here.

   METADATA|OfferingV3|EffectiveStartDate|OfferingNumber|OfferingType|CourseNumber|OwnedByPersonNumber|PrimaryLocationId|CoordinatorNumber
   MERGE|OfferingV3|2023/12/06|AV_23897731-1_ILT_OFF_01|ORA_BLENDED|AV_23897731-1|300100010473113|-1|300100010473113

2. Include the parent section in the data loader file, as shown here.

   METADATA|OfferingActivitySectionV3|EffectiveStartDate|OfferingNumber|OfferingSectionNumber|SectionPosition
   MERGE|OfferingActivitySectionV3|2023/10/27|AV_23897731-1_ILT_OFF_01|AV_23897731-1_ILT_OFF_01_SEC2|2

3. Set DeleteActivity to Y for the activity you want to delete, as shown here. Use the device date for EffectiveStartDate.

   METADATA|SelfPacedActivityV3|ActivityNumber|OfferingSectionNumber|EffectiveStartDate|DeleteActivity
   MERGE|SelfPacedActivityV3|AV_23897731-1_ILT_OFF_01_SEC2|H_COURSE_1_SP1_SEC1|2024/02/06|Y