Goal Weightage can be updated using GoalMeasurement metadata in Goal business object. First, we need to extract the uploaded measurements. Use the below query to extract the details:
SELECT HDL_DATA
FROM (
SELECT 'METADATA|GoalMeasurement|MeasurementId|MeasurementName|StartDate|EndDate|TargetValue|TargetPercentage|UomCode|MeasureTypeCode|TargetType|GoalId|SourceSystemId|SourceSystemOwner' HDL_DATA, 1 SEQ
FROM DUAL
UNION ALL
SELECT 'MERGE'
|| CHR (124)
|| 'GoalMeasurement'
|| CHR (124)
|| hgm.measurement_id
|| CHR (124)
|| hgm.measurement_name
|| CHR (124)
|| TO_CHAR(hgm.start_date,'RRRR/MM/DD')
|| CHR (124)
|| TO_CHAR(hgm.end_date,'RRRR/MM/DD')
|| CHR (124)
|| hgm.target_value
|| CHR (124)
|| hgm.target_percentage
|| CHR (124)
|| hgm.uom_code
|| CHR (124)
|| hgm.measure_type_code
|| CHR (124)
|| hgm.target_type
|| CHR (124)
|| hg.goal_id
|| CHR (124)
|| hikm.source_system_id
|| CHR (124)
|| hikm.source_system_owner HDL_DATA, 2 SEQ
FROM hrg_goals hg
,hrg_goal_measurements hgm
,hrc_integration_key_map hikm
WHERE hg.goal_id = hgm.goal_id
AND hgm.measurement_id = hikm.surrogate_id
AND hgm.uom_code = 'PERCENT'
--AND hg.goal_id = 300000215856607
)
ORDER BY SEQ
Save the data in Goal.dat HDL file. Update the target value as required. Save the .dat file and upload.
Sample HDL:
METADATA|GoalMeasurement|MeasurementId|MeasurementName|StartDate|EndDate|TargetValue|TargetPercentage|UomCode|MeasureTypeCode|TargetType|GoalId|SourceSystemId|SourceSystemOwner
MERGE|GoalMeasurement|300000215856608|Customer Survey Results|2019/01/01|2019/12/31|80||PERCENT|QUANTITATIVE|MIN|300000215856607|300000215856608|FUSION