Category 81-2
Discussion List
-
Succession Plan Report IssueHello there, We are trying to create an OTBI Report on Succession Plan Details .We have attempted to use all related subject areas for succession plan , but we keep enco…prags 21 views 3 comments 0 points Most recent by Melanie Mahon-Oracle Reporting and Analytics for HCM -
Need tables/query to find the distribution value for profiles ratingNavigate to Client Groups—> profile—>select the rating model—>Go to ratings—>.Distributions Need tables/query to find the maximum distribution valueDeepeeka Nath 1 view 1 comment 0 points Most recent by Suman Chenumalla-Support-Oracle Performance Management
-
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 3.3K views 6 comments 0 points Most recent by User_FVSCP Reporting and Analytics for HCM
-
Workforce scheduling: can't get details of patterns and shifts to show on analysisSummary: Looking for direction on how to find and capture the patterns and shifts in my analysis. Under Define Availability: Work Shifts, Work Workday Patterns and Work …
-
FTE seasonal, temp, part-time workers not working year-round or full time (40) hrs per weekSummary: FTE / Headcount “how to” calculate for seasonal, temp and part time employees who don’t work year-round or full time (40) hours / week. FTE for someone working …MissHeidiJ 11 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Human Capital Management
-
Approval Date of the Approved Absence in Workforce Management - Absence Real TimeI'm currently creating a dashboard for Absence Management. Why there are Approved Absence, but the Approval Date is Null?Welsey 11 views 2 comments 0 points Most recent by SatheeshSamy-Oracle Reporting and Analytics for HCM -
Timecard Time Attributes Not Appearing in OTBI Timecard Subject AreasWe have Time Attributes set up that can be viewed in the application by navigating to Setup & Maintenance -> Workforce Deployment -> Time and Labor -> Time Entry Layout …
-
OTBI for Model Profile vs Person Profile Competency Gap AnalysisSummary: Content (please ensure you mask any confidential information): Hello Experts, We have a requirement to pull Person Talent Profile Competencies ratings and Model…
-
Need table name for Legal Employer level work schedulesSummary: Need table name for Legal Employer level work schedules: Example: We can see the default level schedules at Planned Schedules in Time Management. Content (pleas…GajavalliKoteswararao 11 views 1 comment 0 points Most recent by Kanimozhi N-Oracle Reporting and Analytics for HCM
-
which table stores area of Expertise and Area of Interest in Talent ProfilHello, I would like to know which table stores Area of Expertise and Area of Interest in Public Info in Talent Profile page. Attaching the screenshot for reference. Rega…
-
Need dashboard prompt based on field with complex formulaSummary: I have a report on a dashboard that has a field that gives me the highest level of education obtained by first ranking the degrees on the employee's records and…
-
Need info on how to connect Absence Table with Time And LaborSummary: Hi All, I am facing an issue to connect the Absence Table with Time and Labor Tables to Fetch Absence Entry on Timecard. We basically want to Fetch absences ent…Abhishek Bhaskar 93 views 2 comments 1 point Most recent by Dineshkumar Ammasaikutti Reporting and Analytics for HCM -
Talent Review - no results OTBISummary: We have created a custom Talent job/data role which contains the relevant security access to view Talent in My Client Groups. We now want this custom Talent rol…Jo Ord 21 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Data is not retrieving for not started status in OTBI DashboardsSummary: Hi Team, I hope this message finds you well. We are currently facing an issue retrieving data for the 'not started' status regarding employee feedback. Specific…Sujan Kumar Dash 11 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Performance document questionnaire with answers for worker and manager queryI am trying to build a query for Performance document questionnaire with answers for worker and manager query but its not giving correct answers. When I add the tables f…Deepeeka Nath 247 views 0 comments 0 points Started by Deepeeka Nath Reporting and Analytics for HCM
-
Performance Documents Competency Assessment TasksSummary: Looking for the Performance Documents Competency Assessment Tasks assessee and assessor data Content (please ensure you mask any confidential information): Hell…
-
Fetch competency catalog from subject area "Workforce profiles – Library objects Real time”Summary: Hi experts, we're trying to fetch the whole competency catalog using an OTBI analysis in the subject area "Workforce profiles – Library objects Real time". The …Oliviero Riva 21 views 1 comment 0 points Most recent by Sivakumaran Muthusamy-Oracle Reporting and Analytics for HCM
-
What will I be able to do if I activate a user?What will I be able to do if I activate a user? Please let me know. Thanks, MayukoMayuko-Oracle 11 views 1 comment 0 points Most recent by Deaconu Constantin Valentin-Oracle Human Capital Management
-
subject area to get "in error time card details" in otlSummary: we are creating a report to get in error tome card details. Currently we are using "Workforce management - Reported Time Cards Real Time" subject area, here all…Gali Sujana 11 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Where in UI in Talent Management can we see the the below codes?Summary: Code 1 Document Status: SELECT distinct HRA_EVALUATIONS.STATUS_CODE FROM HRA_EVALUATIONS ,HRA_TMPL_PERIODS_VL WHERE HRA_TMPL_PERIODS_VL.TMPL_PERIOD_ID = HRA_EVA… -
Person id equals to 0 using the Person Profile Real time subject areaSummary: Person id equals to 0 using the Person Profile Real time subject area Content (please ensure you mask any confidential information): Hi experts, we are facing t…Oriana L. 21 views 5 comments 0 points Most recent by AnishaPatra-Oracle 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 24 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
extract best-fit results from the HRT_PROFILE_BESTFIT_RESULTSummary: I access the HRT_PROFILE_BESTFIT_RESULT table to extract the values in the following columns (COMPETENCY_SCORE,WEIGHTED_SCORE), I can't find the plain text desc…Emanuele De Marchi 11 views 2 comments 0 points Most recent by Emanuele De Marchi Reporting and Analytics for HCM
-
Skills and Certifcation Report but issue is will get one Extra Empty rowSummary: Hi Team, We have Skills and Certifcation Report but issue is will get one Extra Empty row how can we overcome the thta row. Thanks, Ajay Content (please ensure …AjayKumar Maddipati 21 views 6 comments 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM -
Timecard Layout ReportTeam, We have a requirement to build many timecard reports and would like to understand the table structure to develop the same. We are using hwm_tm_rpt_entry_v view to …
-
Enable to get the output from the "Person Profile Real Time” subject areaSummary: Enable to get the output from the "Person Profile Real Time” subject area Content (please ensure you mask any confidential information): Hi experts, we want to …
-
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 21 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 59 views 2 comments 0 points Most recent by Abhishek Bhaskar Reporting and Analytics for HCM
-
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 …HRJon 21 views 2 comments 0 points Most recent by Raghavendra Raghunath-Oracle 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…