Time and Labor
Discussion List
-
hcm group evaluation process displaying in running status from long timeSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t… -
Need Table name to pull Time Entry Layout Component in Time and LaborSummary: Need Table name to pull Time Entry Layout Component in Time and Labor Content (please ensure you mask any confidential information): Hi, Need Table name to pull…Sujeeth Chinta 35 views 7 comments 1 point 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 22 views 3 comments 0 points Most recent by Claudia Linares Reporting and Analytics for HCM -
Which SQL Table store the Activity Information of Time Entry in OTL.Summary: If you have BIP SQL handy. Please share Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable…Ketan-Oracle 11 views 2 comments 0 points Most recent by Ketan-Oracle Reporting and Analytics for HCM -
Report for Missing TimecardsSummary Employees without time card associationContent Hi All, We have a requirement to identify and report those employees that are missing time card association. I am …Sowdha Murugan 219 views 3 comments 0 points Most recent by Pennie Spies Reporting and Analytics for HCM -
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…vpandian16 11 views 1 comment 0 points Most recent by Srikanth Mandapati Panduranga-Support-Oracle Workforce Management
-
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…Irina Erhan 82 views 6 comments 0 points Most recent by Ashok Kumar Pothula-Oracle Reporting and Analytics for HCM
-
Page header is showing NULL trying to Change Title Name using Page ComposerHi Team, We are trying to change the page header from NULL to title using page composer, it is effecting all the pages. Can you please guide us how we can change it for …Bhuvaneswari Konduri-Oracle 1 view 1 comment 0 points Most recent by ganesh_b-Oracle Workforce Management
-
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 1 view 2 comments 0 points Most recent by ManikandanRajagopalan 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…
-
Sql query that retrieves the total number of processed hours claimed by an employee in OTLI need sql query that retrieves the total number of processed hours claimed by an employee in Oracle Fusion Time and Labor.
-
Table name or query to get timecard transferred to payroll detailsSummary: We need Table name/ Query/ Report to fetch details of the timecard transferred to payroll status. We have observed that when we run the Load timecard batches fl…
-
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…
-
How to change or migrate the nonunified Time layout sets to unified layout sets?Summary: How to change or migrate the non unified layout sets to unified layout sets? We have configured the nonunified Time layout sets and we need to change it to unif…Jinusha Glory 72 views 1 comment 1 point Most recent by Srikanth Mandapati Panduranga-Support-Oracle Workforce Management
-
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…
-
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 242 views 5 comments 0 points Most recent by kanchana venkatasubramanian Reporting and Analytics for HCM
-
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…
-
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…Abhishek Jois 144 views 2 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
Table for timecard approval informationSummary: Reaching out for approval information of timecard which we need to fetch from BIP Report. Please advise which table currently holds this information. We underst…Nitish Maheshwari 23 views 1 comment 0 points Most recent by Srikanth Mandapati Panduranga-Support-Oracle Workforce Management
-
TABLE/SQL FOR TIMECARD CUSTOM ATTRIBUTESSummary: There are 2 custom attributes created in Time and Labor under Time Layout Sets and it shows in the UI. Time Layout Sets. When entering timecard What specific Or…Mark Jayson Tamaray 21 views 1 comment 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM -
Incomplete Time Card ReportSummary: The Business is running into issues with employees submitting time off through the Absence module that automatically transfers to the Time Card, but the employe…
-
Need table names or SQL for Approved OTL timecard details in BIPSummary: Hi Team, I Need table names or SQL for Approved OTL timecard details in BIP. We need particular person entries and along with approver comments. Navigator->my c…Janardhan ACS-Oracle 205 views 5 comments 0 points Most recent by Satyam Roy Reporting and Analytics for HCM
-
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 21 views 3 comments 1 point Most recent by Peeyush Chandel Reporting and Analytics for HCM -
Need a report to pull time change request details for time and laborSummary Need a report to pull time change request details along with manager comments for time and laborUser_2025-02-04-07-00-18-658 44 views 3 comments 0 points Most recent by Peeyush Chandel 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 407 views 6 comments 0 points Most recent by Melek Cinar Reporting and Analytics for HCM -
How to join a Timesheet Row to an Absence Row (HWM_TM_RPT_ENTRY_V to ANC_PER_ABS_ENTRIES)Summary: If we have a person with 2 timesheet rows on the same day, each representing half day of absence, and we have 2 absence rows each of a different absence type - …
-
BI Report Time card details - Calculated details by earned dateSummary: Team we have a requirement to fetch all the details available in the timecard. (Calculated details by earned date) - Screenshot attached. I am using the below q…
-
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 289 views 7 comments 0 points Most recent by Melek Cinar 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 41 views 5 comments 0 points Most recent by Indushree Reporting and Analytics for HCM
-
Need to report on Employees work schedules and patternsContent Hello, We need to be able to report on employees work schedules and patterns so we can create a report that looks like a calendar and show the days that employee…