Time and Labor
Discussion List
-
Delegation InfoletSummary: I want to know if the employee asking for a leave absence has made the required delegation or not before approving the request Content (required): Is there a wa… -
Time Card Approver DetailsSummary Time Card Approver DetailsContent Hi Experts, Which table holds the information of who approved the time card. #1.HWM_TM_REC is having time card details. Whether…VijayaBaskar Ranganathan 654 views 8 comments 0 points Most recent by Neena S Reporting and Analytics for HCM -
OTL Approval workflow data - Current manager for approval, Submitted by, SubmissionSummary: Does anyone have an SQL for OTL Approval workflow data - Current manager for approval, Submitted by, Submission? Content (required): I am looking to develop a B…Neena S 36 views 2 comments 0 points Most recent by Sayali Pawar-Oracle Reporting and Analytics for HCM
-
We need basic details of time card submission details in BI or OTBISummary: HI Team, We need basic details of time card submission details in BI or OTBI. person details. time card submission details, project name, etc. Thanks, Ajay Cont…AjayKumar Maddipati 27 views 1 comment 0 points Most recent by Sayali Pawar-Oracle Reporting and Analytics for HCM -
Is it possible to report on time worked?Summary: Is it possible to create a report that list the hours worked for an employee? Content (required): We are trying to create a report to show if an employee is eli…Brandon Roberts 317 views 13 comments 0 points Most recent by Scott Pisani Reporting and Analytics for HCM -
California Meal Break ReportCalifornia Meal Break Report Could you please help us getting a meal break report for the California Employees? Thanks Mansur -
Time Entry report to get updates and deletion of time entrySummary: Need a report for time entry to pull all new creation, updated and deleted records. Content (required): We have a requirement for integration where we need to g…Raghavendra M 76 views 9 comments 0 points Most recent by John Finnegan-Oracle Reporting and Analytics for HCM -
Team Time Card BIP Query for Team information and approval status and Overtime Information.Summary: Need SQL Query for the Manager can view his team information of time and overtime information. Content (required): Version (include the version you are using, i…Ketan Prajapati 427 views 2 comments 0 points Most recent by Rajdeep Chavda Reporting and Analytics for HCM
-
Any Suggestions of how to improve Web Clock Custom Dashboard data reflection earlier.Summary: We are facing a time-lapse on Custom Dashboard which has reflected the data in delay some time especially in web clock in and out table records. we need a worka…
-
We need Work Schedule Name, Work schedule start date, Work schedule End date on OTBISummary: Hi Team, we looking below columns in OTBI subject areas May i know which subject area available? Thanks, Ajay Content (required): UI: Version (include the versi…AjayKumar Maddipati 37 views 2 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
Need Help with Permissions Required for HCM Subject AreasSummary: I've got a service account that we use to pull extracts into Casabase. We are getting access to all of the ERP and accounting subject areas. However, we are now… -
Monthly scheduled hoursSummary: Content (required): Is there a way in HCM to find the monthly scheduled hours for an employee? Does anyone how if this information is stored in a table? For exa…Nicolas Vahman 57 views 2 comments 0 points Most recent by Nicolas Vahman Reporting and Analytics for HCM
-
What table is the values in "Payroll Transfer Status" and "Payroll Processing Status" stored?The screenshot below is accessible in Team Time Cards: I was looking for how could I get the values for "Payroll Transfer Status" and "Payroll Processing Status" -
Time Entries SQL HelpHi Experts, we need to fetch all the time entries including Absences.SO for Absences we need to have a column for Absence Type.But i am not sure how can we find the abse…minati_behera-Oracle 46 views 4 comments 0 points Most recent by Rajdeep Chavda Reporting and Analytics for HCM
-
I'm looking below columns in otbi or any reference reportSummary: Hi , I'm looking below columns in otbi or any reference report ,any help me on below columns. Thanks, Ajay Content (required): Opening EL leave balance /DOJ (Da…AjayKumar Maddipati 43 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Need SQL for data model list of values for Time Card Time TypeSummary: I need to add a parameter to a BI Publisher Report that has the values from the Time Type field from the Time Card. I have the following SQL written for the lis…
-
SQL or table to get the PAY_PAYROLL_TIME_TYPE ID of time and tasksgood morning experts We are working on a time and tasks report and we did not find the PAY_PAYROLL_TIME_TYPE ID, only the code and the name, could you help us with the S…
-
Display Performance OTBI Analysis to a user Without Giving AccessHello All, Appreciate the help in advance! We have a new office assistant who will be reviewing information like evaluation tracking, performance status, sick leave, etc…Gail Wilmoth 55 views 9 comments 0 points Most recent by Gail Wilmoth Reporting and Analytics for HCM -
BI Publisher RTF Template - Repeating GroupSummary: Team, we have a requirement to print the timecard details For each employee the header should be same and the Last Row Should Be Repeated. It would be really he…
-
Plan Balance query - Carryover, Accrual etc ?Summary:I need to create a report that replicates the data from the Plan Balance screen - which tables? Content (required):I need to create a BI Publisher report that ha…ScottHillier 900 views 8 comments 0 points Most recent by ScottHillier Reporting and Analytics for HCM
-
Timecard status reportSummary Trying to retrieve a report in Fsuion which gives timecard at its different status of its lifecycle.Content Does anyone know of a report that would give the time…Shelly-Ann Mahabir 90 views 4 comments 0 points Most recent by Shelly-Ann Mahabir Reporting and Analytics for HCM
-
Tables relating to NotificationsSummary Question to assist in building a BI Publisher report on Time Card notificationsContent I need to create a BI Publisher report on notifications for time card appr… -
Need to fetching displayvalue of payroll time type from time entry layout component.Summary: Hi, We want to fetch the display value of the payroll time type from the time entry layout component. I am not able to find it in any OTL subject area. Has anyo…Piyush Pokharkar-Oracle 38 views 2 comments 0 points Most recent by Piyush Pokharkar-Oracle Reporting and Analytics for HCM
-
Guys, Do you know the table name that stores the where clause on Manage Value Sets page? Thanks VenSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):VENKATESHWAR GODA 24 views 3 comments 0 points Most recent by VENKATESHWAR GODA Reporting and Analytics for HCM
-
Time and Labor Entries by BatchSummary Looking for a query of Time and Labor Entries by Payroll Transfer BatchContent We’d like to be able to report on the entries that were loaded from Oracle Time an…User_2025-02-04-10-25-07-624 80 views 5 comments 1 point Most recent by Santhosh T Murthy Reporting and Analytics for HCM -
Need HDL to delete time card those re in entered stateSummary: Need HDL to delete time card those are in entered state Content (required): Need HDL to delete time card those re in entered state. If some has .dat file. It is…Swati U 172 views 1 comment 0 points Most recent by Srikanth Mandapati Panduranga-Support-Oracle HCM Data Loader (HDL)
-
need sample query with time card submission statusSummary: need sample query with time card submission status (Saved,Submitted, Approved etc) Content (required): need sample query with time card submission status (Saved…Ishtiaque AHmed 104 views 1 comment 0 points Most recent by Srikanth Mandapati Panduranga-Support-Oracle Reporting and Analytics for HCM
-
Error in Analysis while trying to add schedule name to time and absence reportSummary: We have created an analysis using "Workforce Management - Processed Time Cards Real Time" subject to fetch employee details, department, and time entries with p…Goutham.Manthri 34 views 5 comments 0 points Most recent by Goutham.Manthri Reporting and Analytics for HCM
-
Hours and WagesSummary: FEMA Reporting Needs Content (required): Hello! Is anyone familiar with a subject area that I would be able to get wage and hour information for a given period …Liz McAllister 14 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Steps to create OTBI Report / BI Publisher Report for Planned Schedule → Time ManagementSummary: we need steps to configure Planned Schedule report which can be useful for HR Representatives and HR Admin which provides information of employees whose Worksch…