Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Rating Mismatch in BI Report
Summary:
Hi Team,
Created a BI report to fetch the goal section rating.
We have 5 point rating scale for Performance Evaluation. But when we query, it gives 7.5 for the summary section. Please advise. This issue happens for one employee only.
Query Used:
SELECT
EvalSectionEO.WEIGHT_SECTION_FLAG SC_GL_WRK_WEIGHT_SECTION_FLAG ,
EvalSectionEO.SECTION_WEIGHT SC_GL_WRK_SECTION_WEIGHT,
EvalSectionEO.SECTION_MIN_WEIGHT SC_GL_WRK_SECTION_MIN_WEIGHT,
MgrRatingLevelPEO.NUMERIC_RATING SC_GL_WRK_NUMERIC_RATING,
EvalSectionEO.RATE_SECTION_FLAG SC_GL_WRK_RATE_SECTION_FLAG,
MgrRatingLevelPEO.RATING_DESCRIPTION SC_GL_WRK_RATING_DESCRIPTION,
'<![CDATA'
|| '['
Tagged:
0