How to get the employee pending goal weightage to the oracle fusion bi report using the sql query.
The employee has added and saved the performance goal weight. These goals are currently pending submission for approval, but the manager has not yet approved them. I need to capture this pending goal weight in the Oracle BI report. I used the below query to capture the pending goal details, but the goal weight column does not return the weight. Therefore, I need an updated solution to capture the pending goal weight.
WITH pending_goals AS
(SELECT EXTRACTVALUE (VALUE (itemrow),
'/GoalEORow/PersonId/DATA'
) person_id,
EXTRACTVALUE (VALUE (itemrow),
'/GoalEORow/AssignmentId/DATA'
) assignment_id,
th.object_id goal_plan_assignment_id,