Time and Labor
Discussion List
-
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 200 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 53 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…
-
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
-
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…A.J. Wilkins 264 views 2 comments 0 points Most recent by Rajdip Chavada Reporting and Analytics for HCM -
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 51 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 581 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 86 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 33 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 21 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…Mark Erzen 73 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 139 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 42 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 31 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 11 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…
-
Where to check if employee received a pager unit and their on-call premium?Summary: I'm trying to look where in HCM this information can be visible: Employee received a pager unit and their on-call premium. Thanks!notautomni9 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Missing time card OTBI/BIP report or analysisSummary: Content (required): Is it possible to create an OTBI or BIP report to show employees who have not handed in their time cards? Either standard or customized repo…Nicolas Vahman 391 views 4 comments 1 point Most recent by user5969783 Reporting and Analytics for HCM
-
Where is 'Expedite Payroll' flag stored?Hi All, Summary: I'm trying to find what table is the 'Expedite Payroll' flag on timecards stored? Content (required): this is what it looks like in front-end Thanks!notautomni9 31 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Duplicate Data Issue : HcmTopModelAnalyticsGlobalAM.TimeRepositoryAM.ReportedTimeEntryPVOSummary: We have enabled BICC extract for HcmTopModelAnalyticsGlobalAM.TimeRepositoryAM.ReportedTimeEntryPVO for default column list, the extract data file has duplicate…SukantaBarari-Oracle 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Duplicate Data Issue : HcmTopModelAnalyticsGlobalAM.TimeRepositoryAM.RptAbsTimeEntryPVOSummary: We have enabled BICC extract for HcmTopModelAnalyticsGlobalAM.TimeRepositoryAM.RptAbsTimeEntryPVO for default column list, the extract data file has duplicate d…SukantaBarari-Oracle 21 views 0 comments 0 points Started by SukantaBarari-Oracle Reporting and Analytics for HCM