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
Get Started: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

Rating Mismatch in BI Report

edited Dec 30, 2024 7:40AM in Reporting and Analytics for HCM 6 comments

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'
|| '['

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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