Time and Labor
Discussion List
-
Report showing working days per person for a period based on work schedule assignedSummary: Trying to report on working days for people based on Work schedule. Content (please ensure you mask any confidential information): I am trying to create an OTBI… -
Time and Labor Value Set Issue after 23C on Web Clock_TCF Initialization FailedSummary: Hello, A few weeks ago, we transitioned to version 23C. After 23C I have created new layout set for new HCM group like before. The layout set is working but lin… -
Need a sample query of Team Time Card page, to fetch Reported hours of Calculation Time.Summary: Query to fetch Reported Hours in Calculated time section of Approved Time cards for an individual. Content (please ensure you mask any confidential information)…Sujeeth Chinta 254 views 2 comments 0 points Most recent by Sujeeth Chinta Reporting and Analytics for HCM -
Time card details query in Fusion OTLSummary: Hi All, We are creating one report to get the Time card details. we are looking for 'Time type' and 'Override dept costing' fields. We couldn't able to find the…Sai Krishna Chelikani 3.1K views 6 comments 0 points Most recent by User_FVSCP Reporting and Analytics for HCM
-
Workforce scheduling: can't get details of patterns and shifts to show on analysisSummary: Looking for direction on how to find and capture the patterns and shifts in my analysis. Under Define Availability: Work Shifts, Work Workday Patterns and Work …
-
FTE seasonal, temp, part-time workers not working year-round or full time (40) hrs per weekSummary: FTE / Headcount “how to” calculate for seasonal, temp and part time employees who don’t work year-round or full time (40) hours / week. FTE for someone working …MissHeidiJ 12 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Human Capital Management
-
Approval Date of the Approved Absence in Workforce Management - Absence Real TimeI'm currently creating a dashboard for Absence Management. Why there are Approved Absence, but the Approval Date is Null?Welsey 12 views 2 comments 0 points Most recent by SatheeshSamy-Oracle Reporting and Analytics for HCM -
Timecard Time Attributes Not Appearing in OTBI Timecard Subject AreasWe have Time Attributes set up that can be viewed in the application by navigating to Setup & Maintenance -> Workforce Deployment -> Time and Labor -> Time Entry Layout …
-
Need table name for Legal Employer level work schedulesSummary: Need table name for Legal Employer level work schedules: Example: We can see the default level schedules at Planned Schedules in Time Management. Content (pleas…GajavalliKoteswararao 12 views 1 comment 0 points Most recent by Kanimozhi N-Oracle Reporting and Analytics for HCM
-
Need info on how to connect Absence Table with Time And LaborSummary: Hi All, I am facing an issue to connect the Absence Table with Time and Labor Tables to Fetch Absence Entry on Timecard. We basically want to Fetch absences ent…Abhishek Bhaskar 82 views 2 comments 1 point Most recent by Dineshkumar Ammasaikutti Reporting and Analytics for HCM -
Resubmission Reason and Resubmission Status values in Manage Time cardsContent Hi All, In which column and table holds "Resubmission Reason" and "Resubmission Status" values. Navigation:Navigator--> My Client Groups-->Time Management--> Man…
-
subject area to get "in error time card details" in otlSummary: we are creating a report to get in error tome card details. Currently we are using "Workforce management - Reported Time Cards Real Time" subject area, here all…Gali Sujana 11 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
SQL Table where Webclock events information will be storedSummary: Hi All, We are looking for a report to capture details of Webclock Events. Its use is to check which all entries have Clock in And Clock out correctly, and the …Abhishek Bhaskar 26 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Timecard Layout ReportTeam, We have a requirement to build many timecard reports and would like to understand the table structure to develop the same. We are using hwm_tm_rpt_entry_v view to …
-
How to connect Person Table with Audit table - HWM_TM_AUDITSSummary: Hi, I am trying to create a Timecard Audit BI report. Need to connect Person table Per_all_people_f with HWM_TM_AUDITS table. Not finding a common ground betwee…Abhishek Bhaskar 45 views 2 comments 0 points Most recent by Abhishek Bhaskar Reporting and Analytics for HCM
-
Analysis showing projected absence accrual at year endSummary: Hi We have a periodic accrual scheme for annual leave which accrues monthly at the month end. However we give our employees their entitlement up front (e.g. Mr …HRJon 25 views 2 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Need help with SQL query for Time and LaborI have a query which times out with a single view, even after creating a report with it and scheduling it. When I raised this with Oracle support, I got to know that its…
-
Is there any audit report or query to identify who enter/modify time card.Summary: Is there any audit report or query to identify who enter/modify time card. Content (please ensure you mask any confidential information): We tried to use Create…Abhishek Jois 11 views 1 comment 0 points Most recent by Vali-Oracle Reporting and Analytics for HCM
-
Need to pull working days from Published SchedulesSummary: Hi.. we have a report were we need to pull the working days of an employee from published schedules. We need to know which days are working days and which ones …Alejandrina Vidal 23 views 0 comments 0 points Started by Alejandrina Vidal Reporting and Analytics for HCM
-
Need table name to pull "payroll processing status" field from time and laborSummary Need table name to pull "payroll processing status" field from time and laborContent Hi Team, Need table name to pull "payroll processing status"(Like Processed …User_2025-02-04-07-00-18-658 78 views 3 comments 0 points Most recent by Abhishek Bhaskar Reporting and Analytics for HCM -
The OTL compliance table hwm_tm_comp_msgs_v purging the missing time card dataHi, I have created a Time Card Status BIP Report to display for the Entered (With Time Card status value) & Non-Entered(Missing Time Cards) data. I have used the hwm_tm_…
-
How can I access the standard OTBI dashboard: Time Card Details DashboardSummary: I want to access the standard OTBI dashboard Time Card Details Dashboard to view the current and existing timecards. However, although I have the required roles…Nicolas Vahman 146 views 3 comments 0 points Most recent by Karthik Chockalingam-Oracle Reporting and Analytics for HCM
-
Data access workforce management - worker assignment real timeSummary: I have reviewed Roles Requirement to access all employees data using Subject Area "Workforce Management - Worker **** and seem to have a similar issue at hand. …Sigrid B. 9 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Workforce Management. Changes to view without informing customers: HWM_TM_RPT_ENTRY_VSummary: Workforce Management. Changes to view without informing customers: HWM_TM_RPT_ENTRY_V Content (please ensure you mask any confidential information): Hi Oracle C…
-
Table for Additional Statuses (Timecard)We have a requirement to get Earned Date, Value, Unit of Measure, Payroll Time Type , Absence Type , Payroll Transfer Status & Payroll Processing Status. We are trying t…Manoharan 31 views 2 comments 0 points Most recent by Nagaraju Godasi Reporting and Analytics for HCM
-
Cannot see Schedule name in OTBISummary: We have an OTBI report that shows the work schedule assignment using Person Real Time"."Person Schedule Assignment"."Schedule Name". Users with HR admin roles c…Crystal Pace 35 views 4 comments 0 points Most recent by Crystal Pace Reporting and Analytics for HCM
-
Report to get cost center and account from time management (OTL)Hi Experts, I have an requirement to fetch Cost center and account from time management page. Please check below navigation and Image to identify requirement. My Client …Rajdeep Chavda 11 views 1 comment 0 points Most recent by Vali-Oracle Reporting and Analytics for HCM
-
Table for Payroll Transfer Status and Payroll Processing StatusWe need to get Payroll Transfer Status and Payroll Processing Status. Where are these information gets stored? Please share if you have any inputs. We have tried using p…
-
Want to change the configuration for salaried employees timecard.Summary: we want to change current configuration for salaried employees whose timecards information going to payroll,we want this to modified in such a way that only abs…
-