How to Remove Goal Plan Assignments Using HDL Delete Template

To remove goal plan assignments from employee records in Oracle HCM, follow this two-step approach:

1. Extract relevant Goal Plan data using SQL

2. Load the HDL delete file using GoalPlanAssignment template

Step 1: Use SQL Query to Extract Goal Plan Assignment Data

SELECT  
    HRG_GOAL_PLN_ASSIGNMENTS.GOAL_PLAN_ASSIGNMENT_ID AS GOAL_PLAN_ASSIGNMENT_ID,
    HRG_GOAL_PLN_ASSIGNMENTS.GOAL_PLAN_ID AS GOAL_PLAN_ID,
    HRG_GOAL_PLN_ASSIGNMENTS.ASSIGNMENT_ID AS ASSIGNMENT_ID,
    HRG_GOAL_PLANS_TL.GOAL_PLAN_NAME AS GOAL_PLAN_NAME,
    PER_ALL_PEOPLE_F.PERSON_NUMBER AS PERSON_NUMBER
FROM 
    FUSION.PER_ALL_PEOPLE_F PER_ALL_PEOPLE_F,
    FUSION.HRG_GOAL_PLANS_TL HRG_GOAL_PLANS_TL,
    FUSION.HRG_GOAL_PLN_ASSIGNMENTS HRG_GOAL_PLN_ASSIGNMENTS
WHERE 
    HRG_GOAL_PLN_ASSIGNMENTS.GOAL_PLAN_ID = HRG_GOAL_PLANS_TL.GOAL_PLAN_ID
    AND HRG_GOAL_PLN_ASSIGNMENTS.PERSON_ID = PER_ALL_PEOPLE_F.PERSON_ID
    AND HRG_GOAL_PLANS_TL.GOAL_PLAN_NAME = 'ADD GOAL NAME'
    AND HRG_GOAL_PLANS_TL.LANGUAGE = 'US'

Step 2: Prepare HDL Delete File

METADATA|GoalPlanAssignment|GoalPlanSetId|GoalPlanSetStartDate|GoalPlanEndDate|GoalPlanAssignmentId|AssignmentId|GoalPlanStartDate|GoalPlanSetEndDate|GoalPlanId|GoalPlanExternalId|GoalPlanSetExternalId
DELETE|GoalPlanAssignment||||300123456789|123456|||'300098765432'||

I hope this blog post was helpful for you. If you have any questions or feedback, please leave a comment below.