OTBI
Discussion List
-
OTBI Analysis report for auditing changesSummary: Hello - we are looking for a report/audit tool that will help us monitor when changes have been made to OTBI analysis based reports. We are utilizing the functi…Shanna Oppenheim 1K views 16 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM -
Terms (Leavers) with Most Recent Performance Score and Box AssignmentSummary: We need a report and bar chart that shows terms (resignation and term-invol), NO legal employer changes, with their most recent performance score- the Calculate…Rebekah Gilday 31 views 4 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Conditional display of dashboard analysisHi All We have a requirement to hide some area's (protected characteristics in particular, Age, Gender, Ethnicity) of the line manager dashboard based on the team size, …Murthy Kodavati 61 views 2 comments 0 points Most recent by Murthy Kodavati Reporting and Analytics for HCM -
HCM OTBI Workshop Session 2Summary: This following link allows you to download the recording of session 2 of HCM OTBI Workshop for beginners organized by JAPAC CS Org along with DEV and COE. Conte…Raghavendra Raghunath-Oracle 961 views 6 comments 14 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Filter does not remain for Inactive Applications tabSummary: Content (required): Hello all, I'm facing a problem regarding Requisition Recruiter filter in OTBI dashboard. Starting from the first tab of the dashboard, name…Maria Xydopoulou 51 views 1 comment 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM -
How to SUM 1st, 2nd, 3rd and 4th occurrence of values in trailer summary record for ETEXT template?Summary: I have a requirement to build a trailer record that includes 4 separate SUM totals based on the occurrence of these totals in the employees record. I can't chan… -
Colleague Goals Folder in Workforce Goals - Goal Alignments Real Time Subject AreaHello, Does anyone have experience using the Colleague Goals area of OTBI? I am creating Goal Alignment analyses, and I have already created analyses for Manager Goals a…Nick Dorfner 61 views 7 comments 0 points Most recent by Alvaro Couto Reporting and Analytics for HCM -
How to get performance rating of Manager and Employee in a single row based on Review Period?Summary: How to get performance rating of Manager and Employee in a single row based on Review Period? The employee rating and manager rating should be in single row bas…
-
Rating are displaying on Different RowSummary Rating are displaying on Different RowContent We have using Performance rating real time subject area. We have selected 3 field... Person Number, Worker overall …AvaneeshJain 131 views 6 comments 1 point Most recent by Rahul Saini Reporting and Analytics for HCM -
Terms (Leavers) with Most Recent Box AssignmentSummary: We need a report and bar chart that shows terms (resignation and term-invol), NO legal employer changes, with their most recent box assignment from the Talent A…Rebekah Gilday 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Development Goals view of Top 5 for different categories - not overallSummary: HI there, I am reporting on our Development Goals using "Workforce Goals - Goal Status Overview Real Time" As there are so many goals in our system, I want to g…Stephanie McInnes 41 views 7 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
How do we get Date performed ,Percentage of Performance Tasks by Status in performanceSummary: Hi All, I am using the Workforce Performance - Performance Task Status Real Time subject area for an OTBI Analysis. Can you please let me know from where Date p…Asha Jennifer 21 views 1 comment 0 points Most recent by Andrew Gillibrand-Oracle Reporting and Analytics for HCM
-
Period Rolling Turnover by Employment CategorySummary: I am trying to get a rolling turnover by employment category. This analysis doesn't change any value even if I provide the assignment category filter. The resul…Anita 31 views 2 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Identify the list of reports that a custom role can accessWe have 100s of custom reports within our /Shared Folders/Custom BI catalog folder structure. We have quite a few custom HCM security roles and each custom folder & repo…Pradeep T U 81 views 1 comment 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
How to calculate percentage of Employees with more than 5 hours of learning?Summary: I need to get the percentage of Employees with more than 5 hours of learning for a specific time period in OTBI. So far, I have: a counter for employee names to…A Geyne 41 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Custom report permission with Custom RoleSummary: Hi We have requirement where we wants to give a custom report access to all of the employee of the company. Our organization in using all custom role (Custom Em…Manisha Gupta 21 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Add 2 Report Measures: Dept Active FTE and Vacancy Rate %Summary: I have an Analysis that calculates vacancy rate by department. I need expert advice on how to add two measures to the pivot table. I want to add a measure "Dept…
-
Candidate Progress Summary ReportSummary: Content (required): Can anyone share the OTBI sample report to extract the candidate progress summary? Version (include the version you are using, if applicable… -
Payroll costing - position levelSummary: Breaking down the payroll costing report by position. Content (required): For example, if an employee had a position change on the 15th of September, is there a…User_2025-02-11-21-40-21-159 31 views 3 comments 0 points Most recent by PEEYUSHARORA Reporting and Analytics for HCM -
We develop new custom report but we getting some of employes have two recordsSummary: Hi Team, We develop new custom report but we getting some of employes have two records due to terminattion date actuallyin ui no termination date but some have …AjayKumar Maddipati 31 views 4 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
Is there a document for creating a report for Oracle Digital AssistantSummary: We have received a requirement from one of our clients and they want to create a report for ODA Content (required): Basic requirements from the report - What qu…Avik Roy Chowdhury 51 views 3 comments 2 points Most recent by Dr Surlina Yin-Oracle Digital Assistant -
Hi! How can I run a query to pull data within 90 days from the effective date?Summary: I need to create a query to pull data less than 90 days of effective date to use as agent and decrease the number of lines in the reporting. Content (required):…
-
How to get location for position in OTBISummary: How to get location for position in OTBI Content (required): I tried using location name column under Position folder from position real time subject area but i…Swati U 174 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
we have head count nearly 9000 employees and coming to this report only showing 5700 plus employeesSummary: Hi team, we have head count nearly 9000 employees and coming to this report only showing 5700 plus employees may i know how to check the issue. person real time…AjayKumar Maddipati 51 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Not able to find column as Pending changes in Position subject areaSummary: Not able to find column as Pending changes in Position subject area Content (required): In manage position, we have "Pending Changes" column. see attached. Does…Swati U 41 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How can I calculate Absence Sickness for Employees for 4 absences of 3 days or more?Summary: I need to produce a report for employees that have had more than 4 sickness absences of 3 days or more within a rolling 12 month period. I have managed to creat… -
Logical SQL querySummary: Content (required): I am trying to join the candidate person number to their employee person number to get their days of service since I need this data by recru…Riti Malhotra 41 views 1 comment 0 points Most recent by Riti Malhotra Reporting and Analytics for HCM
-
Is there a way to extract the Manage Privileges details?Every oracle maintenance we are manually checking the Manage Privileges (OBIEE > Administration > Security) if still intact. Are there any way to extract all the details…
-
Questionnaire Score - 360 FeedbackSummary: Hello everyone, Does anyone know how to fetch Questionnaire Score in a performance document using OTBI? What is the subject area and column folder for this? You…Hazel De Castro 61 views 15 comments 0 points Most recent by Hazel De Castro Reporting and Analytics for HCM
-
Deep Links in narrative textSummary: Content (required): Hi, I would like to insert a deep link inside an alert with narrative text. For example: https...fscmUI/faces/deeplink?objType=DOCUMENT_RECO…Alberto Americi 71 views 12 comments 0 points Most recent by Alberto Americi Reporting and Analytics for HCM