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 Report failing when applying Date Time filters

edited Aug 23, 2021 8:39PM in Workforce Management 4 comments

Summary

Combining 2 diffent subject Areas

Content

We have an issue only when we use a Date/Time to field to filter the results.

If we remove that filter the report just run fine.

We're combining 2 Subject Areas: 

Workforce Management - Processed Time Cards Real Time

AND

Compensation - Salary Details Real Time

When we use PID as a filter it returns results in a couple of minutes.

When we add the filter Processed Time Card Details - Calculated Time Card Start Date and Time (or any similar date/time field) the report spins for 10-15 minutes and ends in a ODBC error.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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