Delete and Reconcile Sections and Activities Changes Using HCM Data Loader

You can also delete a section or an activity in an offering or specialization using HCM Data Loader. You can also use it to reconcile learning assignments with changes done to sections and activities of a course or specialization. You can also use the Reconcile action available on the Learning Assignments page.

Deleting a Section or an Activity in an Offering or Specialization

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

NOTE: If the offering type is self paced, you don't need the PrimaryLocationId and CoordinatorNumber attributes to delete either a section or an activity.

Sample data for deleting an offering section

Step 1: Load the offering.

MERGE|OfferingV3|2023/12/06|AV_23897731-1_ILT_OFF_01|ORA_BLENDED|AV_23897731-1|300100010473113|-1|300100010473113

Step 2: Specify to delete the offering section by setting the DeleteSection attribute value to Y. The effective start date can be your current device date.

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

Sample data for deleting an offering activity

Step 1: Load the offering.

MERGE|OfferingV3|2023/12/06|AV_23897731-1_ILT_OFF_01|ORA_BLENDED|AV_23897731-1|300100010473113|-1|300100010473113

Step 2: Load the section.

Step 3: Specify to delete the activity by setting the DeleteActivity attribute value to Y. The effective start date can be your current device date.

To delete a specialization section, you need to include in the data loader file an SpecializationV3 row for the specialization the section is in. Then you specify to delete the relevant section.

Sample data for deleting a specialization section

Step 1: Load the specialization.

MERGE|SpecializationV3|2023/11/24|SPZLN-569231-HDL|2012/03/15|300100010473113

Step 2: Specify to delete the specialization section by setting the DeleteSection attribute value to Y. The effective start date can be your current device date.

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

Sample data for deleting a specialization activity

Step 1: Load the specialization.

MERGE|SpecializationV3|2023/11/24|SPZLN-569231-HDL|2012/03/15|300100010473113

Step 2: Load the specialization section.

Step 3: Specifying to delete the activity by setting the DeleteActivity attribute value to Y. The effective start date can be your current device date.

Reconciliation Process

To reconcile changes made to a section or an activity, we added new background processes. In the Setup and Maintenance work area, search for and click the Configure HCM Data Loader task. Use the provided attributes and values to run the Course V3 and Specialization V3 processes.

For the reconciliation process to run for all the DAT files, set Override to Yes for the CourseV3 or SpecializationV3 business object. To prevent the reconciliation process from running for a specific CourseV3 or SpecializationV3 object, in the first line of the DAT file, you need to specify the instruction "SET INVOKE_POST_PROCESS N" (include the double quotes). If you don't set Override to Yes, you can't prevent the reconciliation process from running for a specific CourseV3 or SpecializationV3 object.

To prevent the reconciliation process from running for all the DAT files, set Override to No for the Course or Specialization business object.

Attribute and Values to Use to Reconcile a Course:

Business Object: Course V3
Process Name: Reconcile Learning Records for Updated Course
Description: Reconciles the learning assignments for a course with updated sections or activities.
Task Name: ReconcileLearningRecordsForUpdatedLearningItems
Default: Yes
Override: Yes or No

Attributes and Values to Use to Reconcile a Specialization:

Business Object: Specialization V3
Process Name: Reconcile Learning Records for Updated Specialization
Description: Reconciles the learning assignments for a specialization with updated sections or activities.
Task Name: ReconcileLearningRecordsForUpdatedLearningItems
Default: Yes
Override: Yes or No

By default, the background processes reconcile all the affected learning assignments in these scenarios:

An activity or a section is deleted
A section or an activity is updated or added
Sections or activities are reordered

Configure HCM Data Loader Page, Business Object Post Process Tab Showing the Course V3 Object

This enhancement reduces the manual maintenance involved in deleting sections and activities.

Steps to Enable

You don't need to do anything to enable this feature.