Time and Labor
Discussion List
-
Need SQL Query or OTBI report to display OTL Calculated HoursContent Hi All, Pls share Subject area or SQL query to get the OTL calculated hours. For Ex: In a week employee entered 42 hours under Regular. When we click on NEXT but…Visu 817 views 1 comment 0 points Most recent by John Finnegan-Oracle Reporting and Analytics for HCM -
Aggregate function on ValueSet is not workingSummary Aggregate function on ValueSet is not workingContent I have attached my query containing the where clause which is not working. Even the below value set is not w…Jaeyshree Kumaran 25 views 2 comments 0 points Most recent by Ashish Kumar Pandey Reporting and Analytics for HCM
-
Pay Code / Element Mapping to General LedgerContent Is there a Subject Matter Area which permits you to build an OTBI report of the Pay Codes and the GL Coding or Concatenate Segment associated with the specific P…User_2025-02-11-07-08-23-440 91 views 1 comment 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM -
Ability to find out the Work Schedule based on ShiftSummary Ability to find out the Work Schedule based on ShiftContent Dear Team, Basic Requirement is to develop the custom BI report based on Shift Details to find out th…User_2025-01-31-16-34-04-599 20 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Need to know Tables to retrieve time card details like hours entered, time attribute detailsSummary Need to know Tables to retrieve time card details like hours entered, time attribute detailsContent I am trying to report time entries and other details like cor…User_2025-02-11-15-16-39-434 456 views 1 comment 0 points Most recent by User_UUX20 Reporting and Analytics for HCM
-
Time card entry report in OTBISummary Time card entries not visible in "Workforce Management - Reported Time Cards Real Time" SAContent Time card entries are not visible in "Workforce Management - Re…Mohit Gupta-45440 326 views 26 comments 1 point Most recent by User_2025-02-11-15-16-39-434 Reporting and Analytics for HCM -
Time Card approver details for multiple AssignmentSummary Require Approver details for each assignment hours in Tiime CardContent Hi Team, I have a requirement to get the approver details for each assignment hours in th…User_2025-02-04-13-27-19-123 22 views 2 comments 0 points Most recent by User_2025-02-04-13-27-19-123 Reporting and Analytics for HCM
-
Time Card issues -Actual Period start Date DBI from Time & Labor.Content Hi Expert do you have any idea to fetch Actual Period start Date in Time & labor . I have created a new hire "XXXX" with the hire date of '02/23/2021' ( same dat…User_VR8E0 23 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Nee a delivered report path that triggers approval notification email for time and labor module.Summary Nee a delivered report path that triggers approval notification email for time and labor module.User_2025-02-04-07-00-18-658 23 views 7 comments 1 point Most recent by MandeepGupta Reporting and Analytics for HCM
-
Time Cards - Calculated Time breakdownContent Hello We have a reporting requirement to show the calculated time breakdown by Type. Is it possible to bring this data in a OTBI report? In which folder do we ha…Ridma Karunanathan 43 views 4 comments 0 points Most recent by Ridma Karunanathan Reporting and Analytics for HCM
-
BI report to extract time informationSummary Any pre build BI report to extract time information available?Content Hello anyone has any prebuild report to read Time information? Thanks, Nicola
-
FTE by Actual Hours WorkedContent Hi All, I need a report that shows FTE per cost center by actual hours worked (in time card) instead of FTE based on scheduled hours. Have any ideas on how to be…
-
Report for overtime hours and regular hoursContent We have a requirement to develop a SQL report based on Over Time hours and Regular hours capturing from a third party device. Suppose we are not creating any pay…User_2025-01-28-21-18-43-496 196 views 3 comments 0 points Most recent by Sudakar Babu Sunkesula Reporting and Analytics for HCM
-
Timecard Entries with Payroll PeriodSummary Reporting on the Payroll Period that Timecard Entries are paid inContent We have a requirement to report using OTBI, the Payroll Period that Timecard Entries are…User_2025-02-06-14-40-18-938 56 views 3 comments 0 points Most recent by User_2025-02-06-14-40-18-938 Reporting and Analytics for HCM
-
Expenses Employee Number to Worker - Person NumberSummary Cannot connect 2 subject areas to merge data in OTBIContent Using OTBI I am attempting to merge subject areas Workforce Management -accruals real time with Expen…User_2025-02-10-15-06-52-222 29 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Who hasnt submitted a TimecardContent Hi all We have been live with HCM for a year and i have been tasked with providing a report that shows who has not submitted a time card. The seeded reports dont…Dawn Cawston - CPS 73 views 1 comment 0 points Most recent by SameerJain Reporting and Analytics for HCM -
Fusion HCM OTBI/BI report usage analytics?Summary How to get OTBI/BI report usage analytics?Content Is it possible to get OTBI or BI report usage analytics? VIZ., input - Report Name Output - list of users who r…User_2025-01-25-04-02-13-126 324 views 24 comments 1 point Most recent by AshishERPCloud Reporting and Analytics for HCM
-
Bank Holiday Time Element EntrySummary Bank Holiday Time Element EntryContent Hi, We are trying to report on Employees who are looking to get their Personal Contribution for Bank Holiday Time worked a…Tim Hopkins 30 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Response UI : Workflow Notification Report parameter valueSummary How to get the parameter value of TimeCardApprovalNotificationBulkReportContent Hi All, We are trying to customize TimeCardApprovalNotificationBulkReport workflo…Badresh Pottabathini-248836 26 views 1 comment 0 points Most recent by Karen Costakes Reporting and Analytics for HCM
-
How to report on Unsubmitted Timecards?Content Has anyone been able to produce a report showing which employees haven't yet submitted a time card in a given period? Any help would be much appreciatedUser_2025-01-28-05-35-00-925 121 views 5 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Time Card Status and Hours for AuditSummary Audit Time Card Status and HoursContent Hi, Can you please help me on time and labor audit details. I have a scenario where, 1. Employee First Entered 24 hours f…User_2025-02-04-13-27-19-123 249 views 2 comments 0 points Most recent by Akash Kiran Jana Reporting and Analytics for HCM
-
Report not showing own itemsSummary An report from timecards does not show own itemsContent We use time and labour to claim overtime as well as to record our flexi. With all our reports in OTBI, th…Dawn Cawston - CPS 44 views 4 comments 0 points Most recent by Dawn Cawston - CPS Reporting and Analytics for HCM
-
Time entry hours by various time codes otbi/reportSummary Time entry hours by various time codesContent Hi, We have some time codes which are not payroll time types specifically. Either they are part of 'Regular Hours' …Anuradha T 60 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to fetch the time card exceptions using OTBI/BIP report?Summary How to fetch the time card exceptions using OTBI/BIP report?Content Hello Team, We are trying to build a report where we need to show the details of person and t…Harish Kumar Kovi 67 views 2 comments 1 point Most recent by Sai1654 Reporting and Analytics for HCM
-
![Arun Kumar Krishnan [AK]](https://us.v-cdn.net/6034893/uploads/userpics/L8BUJDYF94E7/nTLGWFBWW678P.jpg)
OTBI Report for OTL - Subject Areas with Dimensions and NavigationsContent Dear Team, Kindly share the documentation / useful link for below details. 1. OTL - OTBI report with Subject Areas and Dimensions with Navigations. Thanks, ArunArun Kumar Krishnan [AK] 65 views 5 comments 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Time Card Cost Center in OTBIContent I'm trying to fetch All Approved Time Cards where the Employee hours are charged to a different cost center than the employee home cost center in OTBI. Which Sub…Nithin Channa 33 views 2 comments 1 point Most recent by Nithin Channa Reporting and Analytics for HCM
-
Need inputs to display data under "Calculated Time" section in OTLContent Hi All, As per the OTL setup we are referring two layouts while displaying OTL data. Initially employee will enter hours , Payroll time type, Hours and related f…Visu 41 views 4 comments 0 points Most recent by User_2025-02-06-14-40-18-938 Reporting and Analytics for HCM
-
Effective Date Issue?Content Hi Experts, I've built an analysis in OTBI to extract Work Schedules doe Employees. Even though my report has the P_DATE effective date SQL prompt, it is bringin…User_2025-01-28-05-39-23-766 124 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Created a Time Card dashboard and want to the Manager prompt to default to the manager pulling the rSummary Is there a way to default a prompt so that it is automatically set to the person that is pulling the reportContent We have a Time Card dashboard with a prompt fo…User_2025-01-28-20-43-56-568 73 views 8 comments 2 points Most recent by User_2025-01-28-16-10-52-033 Reporting and Analytics for HCM
-
Work Schedules in OTBIContent Afternoon all, Has anyone managed to report on all of the details that sit within Fusion Work Schedules from OTBI? I've built a fairly simple report, that pulls …User_2025-01-28-05-39-23-766 328 views 6 comments 3 points Most recent by Emily Robinson Reporting and Analytics for HCM