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

OTBI Workforce Trends - Time Column Values Are not Accurate or are Blank

edited Jun 30, 2020 1:47PM in Reporting and Analytics for HCM 3 comments

Summary

Calendar Quarter and Calendar Month do not render correctly in the report

Content

We have a requirement to show period active start and end headcount by different org structures (Business Unit, Department, Location, etc.) and by specific time periods (year, quarter, month). We've created a report in OTBI and the Calendar Year field renders correctly but Quarter gives a number and the Calendar Month field is blank. I've tried changing the column properties for Calendar Month to Abbreviated Month data format, but that does not work either. Does anyone know how to get these fields to populate correctly?

I have attached the archived report and attached for reference

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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