Time and Labor
Discussion List
-
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 42 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 42 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 204 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 555 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 36 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 122 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 43 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 32 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 13 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 2 views 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 372 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
-
Time and Labor OTBI - Time card version numberSummary: Content (required): I'm creating a dashboard with different reports for Line Managers and department secretaries. And the report is working good and I get to se…Nicolas Vahman 43 views 1 comment 0 points Most recent by John Finnegan-Oracle Reporting and Analytics for HCM
-
How to get data in 2 fields for Payroll Relationship -> 'Time Card Required' ?Summary: There are two fields for 'Time Card Required' on the Payroll Relationship responsive page. One is at the Payroll Association level and other at Payroll Assignme…Vinay Hardas 82 views 4 comments 0 points Most recent by Andrew_Schmitz Reporting and Analytics for HCM
-
Line Manager can't see Time cards in OTBISummary: Content (required): Hi The Line Manager role can't access time card reports (standard Oracle Time Cards). The reports are standard and delivered by Oracle. The …Nicolas Vahman 31 views 2 comments 0 points Most recent by Nicolas Vahman Reporting and Analytics for HCM
-
Is it possible to report on HCM Recruitment transaction team system activity?Summary: We want to report on activities undertaken in Oracle Fusion by People (HR/HCM) transaction administration colleagues. This specifically relates to job offer rec…
-
Performance Issue in OTL BI reportSummary: Performance Issue in OTL report Content (required): We have existing report on OTL which is taking 3-4 minutes for generating data. Is there anyway that we can …Priyanka More-Oracle 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI Analysis > Time Displayed IncorrectlySummary: Hello All, I will appreciate your support on the following issue: The Start Time and Stop Time reported from the Time Device Machine are displayed correctly on …Bernard T 21 views 7 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM