Category 81-2
Discussion List
-
How to freeze dashboard filter prompt in OTBIHi Experts, We have a requirement to freeze dashboard prompt in OTBI report like we did in Excel header if we are scrolling the dashboard we are unable to see the prompt…Anilkumar12 16 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Select a particular value from concatenated fieldSummary: To obtain a specific value from concatenated field. The business requirement is to obtain information regarding people reporting to C suite (Senior Leadership) …Pranav Waichal 16 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How can I find the system source ID/owner for payroll timecard from BI Report querySummary: We're attempting to update some timecard overtime rate entries using the HCM Data Load using USER KEY method, but system seems to still require SOURCE SYSTEM ID… -
SQL query for Planned Schedules on Time ManagementHello! I need help in developing an SQL query for generating the Planned Schedules for employees on the Time Management navigation: My Client Groups>Time Management> Pla…Hassan Mohsin LC 112 views 8 comments 0 points Most recent by ganesh_b-Oracle Reporting and Analytics for HCM
-
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…Khush Tiwari 472 views 10 comments 0 points Most recent by Thomas Samuel19 Reporting and Analytics for HCM
-
SQL Table where Webclock events information will be storedSummary: Hi All, We are looking for a report to capture details of Webclock Events. Its use is to check which all entries have Clock in And Clock out correctly, and the …Abhishek Bhaskar 42 views 2 comments 0 points Most recent by Siddhesh_Nisal Reporting and Analytics for HCM -
Missed Punch report using BIPSummary: Customer wants to create a BIP report which will give Missed punches of web clock. If there is public holiday or leave applied on that day and no punch data the…Siddhesh Nisal 32 views 4 comments 0 points Most recent by Siddhesh Nisal Reporting and Analytics for HCM -
Facing issues with Users setup for AORSummary: I want to segregate users based on Departments for Time and Labor reports but the same users when associated with Departments are restricted on the Learning sid…
-
How to fetch the physical address of Geo coordinates that we have in Time records?Summary: On the OTL page, we can view the latitude and longitude of the geo-location from which an employee submits their timesheet. Additionally, there is a button that…ManikandanRajagopalan 35 views 4 comments 0 points Most recent by ManikandanRajagopalan Reporting and Analytics for HCM
-
Table in HWM similar to HXT_TM_MTRX to fetch attribute values in a single recordSummary: Table in HWM similar to HXT_TM_MTRX to fetch attribute values in a single record Content (please ensure you mask any confidential information): Hi, We understoo…
-
SQL Query to get calendar attached to employee .Summary: Dear Team: We need to get the calendar details for an employee. Navigation is Login as an employee→Time and absences→Calendar Content (please ensure you mask an…
-
Absence Type and Absence Reason not visible on employee's timecardSummary: Hi, has anyone here encountered an issue where, when an employee logs an absence with a reason, the timecard shows nothing? I have set up the absence reason and…
-
Subject area for report to fetch content section of person profile typeSummary: Content (please ensure you mask any confidential information): Hello, We want to fetch all the details inside 'Content Sections' under Profile > Profile type > …Aishwarya_Saju 10 views 0 comments 0 points Started by Aishwarya_Saju Reporting and Analytics for HCM
-
Analysis report to find all the talent notifications enabled in systemSummary: Content (please ensure you mask any confidential information): Hello, We want to create an analysis report where we get the list of all the enabled and in use n…Aishwarya_Saju 3 views 0 comments 0 points Started by Aishwarya_Saju Reporting and Analytics for HCM
-
Latest Talent Ratings OTBISummary: We are required to create a prompted OTBI analysis that includes each of the worker's latest talent profile ratings. How can this be achieved? Version (include …Luke.Findex 3 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Customizing Email notifications for timecard transactionsWe have a requirement where we need to send customized email notifications for the below timecard transactions: If a timecard is submitted by employee, a custom email no…Rini_Varghese-Oracle 11 views 0 comments 0 points Started by Rini_Varghese-Oracle Reporting and Analytics for HCM
-
In which table do I find the name of school in Skills and Qualification > EducationSummary: In this query hpi.item_number_9 returns the ID of the school field. But I do not know with which table the ID must be linked to display the description of the s…Consultant Ian 33 views 11 comments 0 points Most recent by Carl Bequilla-Oracle Reporting and Analytics for HCM -
Can we set BPM expiration date for Absence Approval Tasks per absence type?Summary: In 24D, there is a new function in Absence Management called "Action on BPM Transaction Expiry," where we can configure each absence type to automatically appro…Shannon Teves 21 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
Which table I can find the value of "Origin of the evaluation"Hello! I would like to know if anyone can tell me which table I can find the value of "Origin of the evaluation" , in the Performance and Talent Review-Results sectionLeonardoNogueira 44 views 4 comments 0 points Most recent by Gunasagar Thimmapuram-Oracle Reporting and Analytics for HCM
-
Time card approval history tables in Oracle HCM CloudWhat are the table names that store approval information for Time and Labor? Looking for timecard approvers names, dates and times as well as the status of the timecard.
-
subject area for learning item in Development PlanSummary: Hi all, I am trying to retrieve the subject area for a specific section of Development Plan. 1. 2. So far I have retrieved all table info related to "Basic info…Silvia Stangarone CAI 14 views 2 comments 0 points Most recent by Abdul Rauf Mohammad-Oracle Reporting and Analytics for HCM
-
Week Number calculation for OTL Overtime report if week starts from saturday and end on fridaySummary: Hi Team, We need to calculate the weeknumber for a overtime card report. Week will start from saturday and end on friday We need to pass "from week" and "to wee…
-
Oracle Fusion BI Publisher - Excel Template - Generate Multisheet Report Excel OutputSummary: Hi Team, We have a requirement where we need to generate an excel output with 3 tabs in the output file. Sheet1 name: Static value as "Parameter" and it has to …
-
How to Default Assigned Project to Web Clock and Time Card Based on Project Execution AssignmentSummary: Hello, In Oracle Time and Labor, we want the Project field in both Web Clock and Time Entry Layout (Time Card) to be automatically defaulted with the project th… -
Analysis showing projected absence accrual at year endSummary: Hi We have a periodic accrual scheme for annual leave which accrues monthly at the month end. However we give our employees their entitlement up front (e.g. Mr … -
enhanced talent profile HDLSummary: Hi everyone, In Redwood,We cant update the existing talent profile item values. To update existing values we need to populate learning or certificate label.Plea…Krishna Manmohan 26 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
While running the talent report the technical competencies are not fetching for one employee.Hi Team, Need assistance on talent report, the report not fetching the technical competencies for one employee. But when we run the data model the data is coming. Thank …xbyz-Oracle 4 views 1 comment 0 points Most recent by Soumya Suravita Reporting and Analytics for HCM
-
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…
-
'Time type' field column mapping from which table to fetch itSummary: Hi All, We are creating one report to get the employee overtime unpaid overtime details. we are looking for 'Time type' field column mapping from which table to…
-
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 4.5K views 7 comments 0 points Most recent by Sri N Reporting and Analytics for HCM