Issue in ‘Workforce Goals - Goal Status Overview Real Time’ subject area

Summary:

Hi Team,

‘Workforce Goals - Goal Status Overview Real Time’ Subject area doesn’t show all goal plans for the person in the report.

For the Person, we are able to view below goal plans in application under the review period.

1.‘Transaction’ (In progress Status)

2.‘Test’ (Approved Status)

But in the report, we get only the goal plan ‘Test’ however we are unable to get other goal plan ‘Transaction’.

Below is the SQL query used for the report:

SET VARIABLE PREFERRED_CURRENCY='User Preferred Currency 1';SELECT

0 s_0,

"Workforce Goals - Goal Status Overview Real Time"."Performance Goal Plan"."Goal Plan Name" s_1,