Time and Labor
Discussion List
-
Display Value for Time Entry Layout Component fieldSummary: Display Value for Time Entry Layout Component field Content (please ensure you mask any confidential information): Hello, I have a time entry layout component o… -
Table names to get reported time and calculated time on time card for reportingHi, We need a timecard report comparing the reported time vs the calculated time. Can anyone please share table names to get reported time and calculated time on time ca…
-
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 1.2K 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 11 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 11 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 …
-
Sql query required to identify time card approver and assignee detailsSql query required to identify time card approver and assignee details. We tried to join hrc_txn_header, hrc_txn_data and fa_fusion_soainfra.wftask to get the details. B…
-
Link between OTL time Entries with Element Entries or Calculation cardsContent Hi All, We enter data in OTL and transfer batch. Then calculation cards and Element entries will be created. We need SQL Query/OTBI link between OTL time entries…
-
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 11 views 1 comment 0 points Most recent by Kanimozhi N-Oracle Reporting and Analytics for HCM
-
Table in HWM similar to HXT_TM_MTRX to fetch attribute values in a single recordSummary: Table in HWM similar to HXT_TM_MTRX to fetch attribute values in a single record Content (please ensure you mask any confidential information): Hi, We understoo…
-
Time Change Request reportSummary: Hi All, Has anyone Developed a BI/OTBI Report on Capturing Details of Time Change Requests? We have a requirement and working on this. Appreciate if anyone can …Abhishek Bhaskar 1 view 0 comments 0 points Started by Abhishek Bhaskar Reporting and Analytics for HCM -
Submitted Timecard and Web Clock Details ReportSummary: Need to SQL query for view the detail of submitted timecard and web clock's reported hours and schedule deviation with custom attribute. Content (please ensure …Melek Cinar 211 views 7 comments 0 points Most recent by Melek Cinar 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 31 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…
-
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…
-
Can any one please tell what is column name which stores Auto approval by system in OTL ModuleWe have a requirement to find the list of records for those time cards which is automatically approved by system. Please let me know if there is any feasibility to achie…
-
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
-
Time card details based on payroll flow - Load Time Card BatchesHi Expects, Requirement : Need to fetch time card details based on payroll flow - Load Time Card Batches. basically OTL report , based on payroll flow parameter. when we…Rajdip Chavada 21 views 2 comments 0 points Most recent by Abhishek Bhaskar 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 22 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 11 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 21 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
-
Transactions Tables are not storing Data for few TransactionsSummary: Hi Team, I am trying to fetch the transaction details for Time Change Request Approval. But I have encountered that there two tables that were not storing any d…Dasari Dileep 181 views 4 comments 0 points Most recent by Serap Aktaş 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 1 view 0 comments 0 points Started by Alejandrina Vidal Reporting and Analytics for HCM
-
Time Entry Audit Report for Reported timecards.Hi Team, I am trying to build a report, where we will show the Time audit details like Person Number, Time Type before change, Time Type after change , Timecard start ti…Khush Tiwari 211 views 6 comments 0 points Most recent by Abhishek Bhaskar 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 …Chaitanya Jogi 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_…