How to get the employee pending goal weightage to the oracle fusion bi report using the sql query. — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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,

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!