Delete an Offering Section in Oracle Learning

You need to include in the data loader file an OfferingV3 row for the offering the section to delete is in. Then you specify to delete the relevant section.

1. Load the offering, as shown in this example. If the offering type is self-paced, you don't need the PrimaryLocationId and CoordinatorNumber attributes to delete either a section or an 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. Specify to delete the offering section by setting the DeleteSection attribute value to Y, as shown in this example. The effective start date can be your current device date.

   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