Category 81-2
Discussion List
-
I want SQL query to fetch data from 9 Box Matrix dashboard in Talent Review MeetingsHi team I hope you are doing well. I want SQL query to fetch data from 9 Box Matrix dashboard in Talent Review Meetings (Box label, Rating, and manager name) Kind regard,Mohamed_Shafay 32 views 4 comments 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM -
How to connect Person Table with Audit table - HWM_TM_AUDITSSummary: Hi, I am trying to create a Timecard Audit BI report. Need to connect Person table Per_all_people_f with HWM_TM_AUDITS table. Not finding a common ground betwee…Abhishek Bhaskar 65 views 2 comments 0 points Most recent by Abhishek Bhaskar Reporting and Analytics for HCM -
Need help with SQL query for Time and LaborI have a query which times out with a single view, even after creating a report with it and scheduling it. When I raised this with Oracle support, I got to know that its…
-
Is there any audit report or query to identify who enter/modify time card.Summary: Is there any audit report or query to identify who enter/modify time card. Content (please ensure you mask any confidential information): We tried to use Create…Abhishek Jois 12 views 1 comment 0 points Most recent by Vali-Oracle Reporting and Analytics for HCM
-
Need to pull working days from Published SchedulesSummary: Hi.. we have a report were we need to pull the working days of an employee from published schedules. We need to know which days are working days and which ones …Alejandrina Vidal 34 views 0 comments 0 points Started by Alejandrina Vidal Reporting and Analytics for HCM
-
Talent Pools - Succession Plan KPI reportSummary: Need to build report using below fields - either OTBI or BIP. Kindly help please. Content (please ensure you mask any confidential information): Column Name Des…Pradnya_Pampatwar 11 views 1 comment 0 points Most recent by Pradnya_Pampatwar Reporting and Analytics for HCM
-
The OTL compliance table hwm_tm_comp_msgs_v purging the missing time card dataHi, I have created a Time Card Status BIP Report to display for the Entered (With Time Card status value) & Non-Entered(Missing Time Cards) data. I have used the hwm_tm_…
-
How can I access the standard OTBI dashboard: Time Card Details DashboardSummary: I want to access the standard OTBI dashboard Time Card Details Dashboard to view the current and existing timecards. However, although I have the required roles…Nicolas Vahman 141 views 3 comments 0 points Most recent by Karthik Chockalingam-Oracle Reporting and Analytics for HCM
-
Data access workforce management - worker assignment real timeSummary: I have reviewed Roles Requirement to access all employees data using Subject Area "Workforce Management - Worker **** and seem to have a similar issue at hand. …Sigrid B. 1 view 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Workforce Management. Changes to view without informing customers: HWM_TM_RPT_ENTRY_VSummary: Workforce Management. Changes to view without informing customers: HWM_TM_RPT_ENTRY_V Content (please ensure you mask any confidential information): Hi Oracle C…
-
Where to find OTBI subject area for Job responsibilityWe're creating a report in OTBI for Model Job Profiles, however we couldn't find "job responsibility" section in the subject areas of OTBI. 24AAnita Andrádi 21 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
In what table can I find Box_Assignment Column from Talent Review?Summary: In the Oracle Fusion Cloud HCM Talent Review module, wherein the Tables and Views for HCM can I find the value for the Box Assignment? Content (please ensure yo…
-
Table for Additional Statuses (Timecard)We have a requirement to get Earned Date, Value, Unit of Measure, Payroll Time Type , Absence Type , Payroll Transfer Status & Payroll Processing Status. We are trying t…Manoharan 41 views 2 comments 0 points Most recent by Nagaraju Godasi Reporting and Analytics for HCM
-
Cannot see Schedule name in OTBISummary: We have an OTBI report that shows the work schedule assignment using Person Real Time"."Person Schedule Assignment"."Schedule Name". Users with HR admin roles c…Crystal Pace 42 views 4 comments 0 points Most recent by Crystal Pace Reporting and Analytics for HCM
-
Profile id not available for some employeesSummary: Profile id not available for some employees Content (please ensure you mask any confidential information): Hi experts, we want to create a report that retrieve … -
can we use fetch multiple columns using single case statementHi Team, i am using the case statements as below to retrive the data for a single person but it is giving me the 4 rows for same person is there any way to group them al…Chetana Pawar 21 views 1 comment 0 points Most recent by Swathi Shetty Reporting and Analytics for HCM
-
Report to get cost center and account from time management (OTL)Hi Experts, I have an requirement to fetch Cost center and account from time management page. Please check below navigation and Image to identify requirement. My Client …Rajdeep Chavda 11 views 1 comment 0 points Most recent by Vali-Oracle Reporting and Analytics for HCM
-
OTBI parameter issueSummary: Hi Experts, I need some assistance. I'm working on the Talent Profile Report and wanted to capture all the details in one report. I picked up multiple values by…
-
Table name of language Level in skill and qualification sectionSummary: Does anyone know the table name of the language Level table name in the skill and qualification section? Currently, I'm using attached BI query to fetch the oth…
-
Workforce Profiles - Person Profile Real TimeSummary: Hi Expert, I need your assistance. I picked up multiple values by using the above-mentioned subject area and getting values from different sections of a person'…
-
Want to change the configuration for salaried employees timecard.Summary: we want to change current configuration for salaried employees whose timecards information going to payroll,we want this to modified in such a way that only abs…
-
-
-
Get Time Card Period (Employee Time Card Details)Summary: We have a requirement to get employee's timecard (timeentry details) ... daywise. We have got the measure (days) from the table hwm_tm_rec using the resource_id…
-
OTBI Report not showing pictures when exported as Web ArchiveSummary: We have an OTBI report that stores images + html values. When extracted as Web Archive, first row displays image just fine, but row2 and row3 are only showing I…CAMIL_Q 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI Report Showing Which Cost Center Was Charged For Hours/EarnsSummary: I have a requirement to provide the YTD number of worked hours charged to a specific cost center regardless of the employee's home department cost center. What …JHaden3 41 views 1 comment 0 points Most recent by Srikanth Mandapati Panduranga-Support-Oracle Workforce Management
-
How to calculate number of continuous weeks of Submitted TimecardsSummary: For Casual workers who submit weekly timecards, I need to identify those that have worked 12 continuous weeks. Content (please ensure you mask any confidential …Richard Kemp-Eyre 22 views 1 comment 0 points Most recent by Srikanth Mandapati Panduranga-Support-Oracle Workforce Management -
need build a logic to pull only the approved time cards for that particular month.Hi We need to build a report to get the approved time cards for Payroll processing i can only find hwm_tm_rec which captures the data. How can i consider only approved t…
-
Profile strength report for checking Talent profile completion status reportingProfile strength report for checking Talent profile completion status for the Organisation reporting? I am not able to find the field for profile strength in OTBI or BIRevanth.Rondla 31 views 1 comment 0 points Most recent by Adriana Tudor-Oracle Reporting and Analytics for HCM
-
Time Between Promotion in Oracle Fusion HCMSummary: Time Between Promotion Content (please ensure you mask any confidential information): Hi Team, Please help to create query for Average number of months between …Hitha Harikumar 11 views 2 comments 0 points Most recent by Hitha Harikumar Reporting and Analytics for HCM