Time and Labor
Discussion List
-
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… -
BIP report, for identifying the missing Time EntriesSummary This will be useful If we are expecting to see missing time entries in report or infolets. This SQL query logic is based on the Working hours of the User.Content…Praveen Chandra-Oracle 611 views 4 comments 5 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
I am trying to get te work schedules of the inactive employees via analysis reportSummary: Work Schedules - if employees are inactive, their work schedules are missing from the analysis Content (please ensure you mask any confidential information): We…Claudia Linares L 38 views 4 comments 0 points Most recent by David Vaughan-Watkins Reporting and Analytics for HCM -
Issue with Error Message and Reported Hours in OTBI Report for Imported Time EntriesSummary: After submitting the process “Process Imported Time Entries”, a few time cards are erroring out. I need to build an error report that shows: Person Number Time …Raghavendra M 30 views 1 comment 0 points Most recent by Raghavendra M Reporting and Analytics for HCM -
How to Link Payroll Details to Time Entry Data?Summary: Hii team, In the time entry details we are able to see the payroll linked data, like from frontend I can see this details I need to fetch this Earned date, valu…Vishal Purohit 5 views 0 comments 0 points Started by Vishal Purohit Reporting and Analytics for HCM -
received error messages when running Missing Time reportsHi Team, As we are trying to run below delivered Missing Time Reports OTBI then we are getting below error. Could you please help to resolve the issue. ERRORChanikya Neelam-Oracle 23 views 8 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
How to Query Cost Code from Oracle Fusion HCM OTL Time Card Tables?Summary: Hi Community, I need help identifying which table/column stores the Cost Code information visible in the OTL Time Card interface in Oracle Fusion HCM. Context: …Vishal Purohit 38 views 2 comments 0 points Most recent by Vishal Purohit Reporting and Analytics for HCM
-
Seniority based shift assignments in workforce schedulingSummary: The requirement is to assign the shifts in accordance with CBA seniority date rules to the employees and then allowing employees to claim shifts accordingly. Re…Chaitanya Mantripragada 6 views 1 comment 0 points Most recent by Srikanth Mandapati Panduranga-Support-Oracle Workforce Management
-
How to get shift name start time, end time for certain date after manually change the workSummary: I need to retrieve the shift name, start time, and end time for a specific date after manually updating the work schedule calendar. How can I get these updated …Sanduni Pathirathne 13 views 1 comment 0 points Most recent by gclampitt Reporting and Analytics for HCM
-
How to Query Reported Time for Specific Payroll Time Types Based on Time CategorySummary: I'm trying to query reported time entries for specific Payroll Time Types that belong to a particular Time Category — in my case, the category is called "**** T…
-
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 308 views 6 comments 0 points Most recent by Aditya Jadhav 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…Rajdeep Chavda 81 views 6 comments 0 points Most recent by Om Shukla-Oracle Reporting and Analytics for HCM
-
Building an OTBI report using OTL data. Can't find Project RoleSummary: We are building an OTBI report to show all timecard entered for the week. We are project based company so our timecards include Project and task information, in…Anjula Mittal 37 views 3 comments 0 points Most recent by John Finnegan-Oracle Reporting and Analytics for HCM
-
Is there a table that store calculated time in time cardHello, I would like to ask whether this information is stored directly in a specific table or if it is derived through a calculation. Kindly advise. I've seen this view …
-
SQL Query for timecard approval to BPM workflowObjective : SQL Query to get Approver Name, Approval Date and Status of Timecards Imported in Project Cost Issue : I am unable to find a link between HWM_TM_REC and Work…Palash Kumar Singh 98 views 2 comments 0 points Most recent by Palash Kumar Singh 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 …MissHeidiJ 67 views 3 comments 1 point Most recent by Stephanie McInnes Reporting and Analytics for HCM
-
Does anyone know what table does the Absence Management Type time attribute belong to?Summary: We currently have Payroll Time Type and Absence Management Type configured for the Time Entry Layout Components in our system. We already found that the HWM_TM_…
-
Database Table name for Approval DelegationsSummary: We have a requirement to build a report for approval delegations, thus need the database table name for Approval Delegations. Navigation: Person Management > Se…JainSamyak 60 views 4 comments 0 points Most recent by Anusha Bhat-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…Manoharan 496 views 6 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
hwm_timecard_report.timecard_totals - Specification (Oracle Fusion)An Oracle Fusion seeded report for displaying bulk timecard approvals is executing the TimecardApprovalNotificationBulkReport which displays a PDF on screen. The data mo…
-
How can I find the system source ID/owner for payroll timecard from BI Report querySummary: We're attempting to update some timecard overtime rate entries using the HCM Data Load using USER KEY method, but system seems to still require SOURCE SYSTEM ID… -
SQL query for Planned Schedules on Time ManagementHello! I need help in developing an SQL query for generating the Planned Schedules for employees on the Time Management navigation: My Client Groups>Time Management> Pla…Hassan Mohsin LC 102 views 8 comments 0 points Most recent by ganesh_b-Oracle 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 467 views 10 comments 0 points Most recent by Thomas Samuel19 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 41 views 2 comments 0 points Most recent by Siddhesh_Nisal Reporting and Analytics for HCM -
Missed Punch report using BIPSummary: Customer wants to create a BIP report which will give Missed punches of web clock. If there is public holiday or leave applied on that day and no punch data the…Siddhesh Nisal 31 views 4 comments 0 points Most recent by Siddhesh Nisal Reporting and Analytics for HCM -
How to fetch the physical address of Geo coordinates that we have in Time records?Summary: On the OTL page, we can view the latitude and longitude of the geo-location from which an employee submits their timesheet. Additionally, there is a button that…ManikandanRajagopalan 33 views 4 comments 0 points Most recent by ManikandanRajagopalan 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…
-
SQL Query to get calendar attached to employee .Summary: Dear Team: We need to get the calendar details for an employee. Navigation is Login as an employee→Time and absences→Calendar Content (please ensure you mask an…
-
Absence Type and Absence Reason not visible on employee's timecardSummary: Hi, has anyone here encountered an issue where, when an employee logs an absence with a reason, the timecard shows nothing? I have set up the absence reason and…
-
Customizing Email notifications for timecard transactionsWe have a requirement where we need to send customized email notifications for the below timecard transactions: If a timecard is submitted by employee, a custom email no…Rini_Varghese-Oracle 11 views 0 comments 0 points Started by Rini_Varghese-Oracle Reporting and Analytics for HCM