1. HCM Data Loading Business Objects
  2. Delete an Offering Activity in Oracle Learning

Delete an Offering Activity in Oracle Learning

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

  1. Load the offering, as shown in this example. 
    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. Load the section, as shown in this example. 
    METADATA|OfferingActivitySectionV3|EffectiveStartDate|OfferingNumber|OfferingSectionNumber|SectionPosition
MERGE|OfferingActivitySectionV3|2023/10/27|AV_5990_ILT_OFF_01|AV_5990_ILT_OFF_01_SEC2|2
  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|SelfPacedActivityV3|ActivityNumber|OfferingSectionNumber|EffectiveStartDate|DeleteActivity
MERGE|SelfPacedActivityV3|A1_H_COURSE_1_SP1_SEC1|H_COURSE_1_SP1_SEC1|2024/02/06|Y