Time and Labor
Discussion List
-
Get Scheduled Hours From Assignment Work SchedulesWe have a requirement to get the scheduled hours from Assignment Work Schedules. We are trying with the below code but its not giving hours. SELECT * FROM ( TABLE(PER_AV… -
Extracting data using BIP Publisher Report for REST API Load (Creating Timecard)Team, We have a requirement to create bulk time entries for employees (Copying previous timecard and creating the same timecard for current week - Dates differs) and we …
-
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 - …
-
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 13 views 2 comments 0 points Most recent by Janardhan ACS-Oracle Reporting and Analytics for HCM
-
Query to get time card approver name and approved dateSummary: I need query to get time card approver name. Content (required): I need query to get time card approver name. Version (include the version you are using, if app…Swati U 424 views 4 comments 0 points Most recent by Durgadevi-Oracle Reporting and Analytics for HCM
-
Filter schedule name based on week start date of timecardSummary: Report has only the schedule applicable to the timecard at time of commencement. Content (required): I have a timecard report that includes every schedule for t…Dawn Cawston - CPS 11 views 8 comments 0 points Most recent by Dawn Cawston - CPS Reporting and Analytics for HCM -
Missing TimeCards ReportSummary Missing TimeCards ReportContent Hi Experts, Anybody developed Missing Timecards BI/OTBI Report. Could you please share the report. Thanks ThiruThiru Ch 231 views 16 comments 2 points Most recent by Venkataramana N Reporting and Analytics for HCM -
Adding Worker Payroll Name to Custom Timecard ReportI have multiple custom timecard reports being developed. In these reports, I need to include the Pay Frequency (Payroll Name/Worker Payroll Name). The reports are develo…
-
Absence - Shift start and end time can be 24 hours format ?Summary: In the Create Work Shift page(Set up -> All tasks -> 'Work Shifts' -> Create Time Shift -> Start Time), the current system allow us enter the time in the HH:MM …Faqir 31 views 1 comment 0 points Most recent by Srikanth Mandapati Panduranga-Support-Oracle Workforce Management
-
Add Days to day_start_timeTeam, How to add days to datetimestamp. We have a requirement to add one week to the date timestamp and display. day_start_time in hwm_tm_rpt_entry_v. If the date is 25-…Manoharan 11 views 2 comments 0 points Most recent by Rajdip Chavada Reporting and Analytics for HCM
-
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 204 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 21 views 2 comments 0 points Most recent by Sayali Pawar-Oracle Reporting and Analytics for HCM
-
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 41 views 3 comments 0 points Most recent by MADAN ROOPESH 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 21 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 161 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 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…
-
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 62 views 9 comments 0 points Most recent by John Finnegan-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 31 views 1 comment 0 points Most recent by Riaz.S -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 41 views 2 comments 0 points Most recent by Rajdip Chavada 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 31 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 41 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" -
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 41 views 2 comments 0 points Most recent by Mandeep Gupta Reporting and Analytics for HCM
-
Generate Report with Timecard ApproverSummary: We need to generate a report with the time card approved date and who approved it. Content (required): I've seen this question asked a few times, but it doesn't…Matthew Voss 181 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
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 41 views 4 comments 0 points Most recent by Rajdip Chavada 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 41 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM