Delete a Specialization Activity in Oracle Learning

You need to include in the data loader file a SpecializationV3 row and SectionV3 row for the specialization section the activity to delete is in. Then you specify to delete the relevant activity.

  1. Load the specialization, as shown in this example.
    METADATA|SpecializationV3|EffectiveStartDate|SpecializationNumber|PublishStartDate|OwnedByPersonNumber
    MERGE|SpecializationV3|2023/11/24|SPZLN-569231-HDL|2012/03/15|300100010473113
  2. Load the specialization section, as shown in this example.
    METADATA|SpecializationSectionV3|EffectiveStartDate|SpecializationSectionNumber|SectionPosition|SpecializationNumber
    MERGE|SpecializationSectionV3|2023/11/23|SPZLN-221120236-HDL_SEC1|2|SPZLN-221120236-HDL
  3. Specify to delete the activity by setting the DeleteActivity attribute value to Y, as shown in this example. The effective start date can be your current device date.
    METADATA|SpecializationSectionActivityV3|ActivityNumber|SpecializationSectionNumber|CourseLearningItemNumber|EffectiveStartDate|DeleteActivity
    MERGE|SpecializationSectionActivityV3|A1_H_SPEC_SEC1|H_SPEC_SEC1|H_SPEC_COURSE1|2024/02/06|Y