Time and Labor
Discussion List
-
per_availability_details.get_availability_detailsTeam, We have a requirement to get scheduled hours from work schedules for all the assignments which falls in the period passed in parameter time period start date (:TC_… -
OTBI > Transpose Rows to Columns in OTBI > Ability to Perform Sum Only on One RowSummary: OTBI > Transpose Rows to Columns in OTBI > Ability to Perform Sum Only on One Row Content (please ensure you mask any confidential information): Hello, We want …
-
Possibility to Create Dynamically Different Tabs of The Same Report by Passing Diff. Param’s ValueSummary: OTBI Dashboard > Possibility to Create Dynamically Different Tabs of The Same Report by Passing Different Parameter’s Value Content (please ensure you mask any …Bernard T 23 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Time and Labor -- Calculated time card entries for a date range or pay periodSummary Calculated time card entries for a date range or pay periodContent Hi Friends I have been working on a report for Calculated Time Card Entries and so far i have … -
Table Name for Availability CalendarTeam, Need table name which holds the availability calendar details. Person Management -> Work Schedule Assignments-> View Calendar. Please Guide.
-
How to get purchase order from timecard detailsHi , How to get purchase order number from timecard details. Thanks, Manjunath.Manjunath Paduchuru-Oracle 11 views 1 comment 0 points Most recent by Manjunath Paduchuru-Oracle Reporting and Analytics for HCM
-
Value as columnTeam, The timecard layout has been configured and there is a custom attribute created like below. PROJ_FUNCTION - AttributeVarchar1 We have got the above details from on…
-
Table for Time Type in TimecardWe have a requirement to fetch the time type from timecard. pay_payroll_time_type from hwm_tm_rep_m_ptt_atrbs_v is not returning any value. Could someone guide me on thi…
-
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… -
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 123 views 3 comments 0 points Most recent by Durgadevi-Oracle Reporting and Analytics for HCM
-
How extract employees work schedule assigned at different levelsSummary How extract employees work schedule assigned at different levelsContent Hi, How can we extract work schedule of employee assigned at different levels. i tried us…User_W9SIR 340 views 4 comments 2 points Most recent by Shant_Sarkissian_WJG 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…
-
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 …
-
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 1.2K 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 272 views 16 comments 2 points Most recent by Venkataramana N Reporting and Analytics for HCM -
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 51 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 12 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 470 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 32 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 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 284 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 72 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 123 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 51 views 2 comments 0 points Most recent by Nicolas Vahman Reporting and Analytics for HCM