Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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 with Redwood for Oracle Cloud HCM   Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.

For more information, please refer to this announcement explaining best practices for getting answers to questions.

How do I pull the exact same timecard data that appears on the Oracle Team Time Cards screen?

in Reporting and Analytics for HCM 1 comment

Summary:

I need to create a data model that pulls the exact same data that appears on the Team Time Cards screen. We have OTBI reports that use the "Workforce Management - Reported Time Cards Real Time" subject area, and they match the data on the "Team Time Cards" screen. However, we need the flexibility of a data model.

Content (please ensure you mask any confidential information):

 I have attempted to use the view titled “HWM_EXT_TIMECARD_DETAIL_V”, and although it works for most employees, it does not work for all employees.  Can someone provide me with a query that will pull the same ABSENCES and TIME_RPTD data that the “Team Time Cards” screen in Oracle pulls? For some reason, I am having issues with absence records pulling twice because they have both TIME_RPTD and ABSENCES layer codes, which is causing them to pull more than once. I am also having issues with old data pulling for some employees who changed their time card, even though I added criteria to only pull

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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