OTBI
Discussion List
-
Email Body not bursting correctly (22C)Summary: Content (required): Hi Since we went live with the 22C patch, notifications burst from OTBI are not including anything in the body of the email sent to recipien… -
Scheduling the report(Email Notification) if the data is present in itSummary Scheduling the report(Email Notification) if the data is present in itContent Hi All, Greetings !! Our customer's requirement is to receive the report/Email noti…User_2025-01-29-01-27-20-754 219 views 17 comments 0 points Most recent by Adam_Cantwell Reporting and Analytics for HCM -
How to embed Analytics, as an icon, in My Team page in UISummary: Our client wants to embed Analytics, as an icon, in My Team page in UI, which will redirect to a custom Analysis, as similar to the attached screenshot. The ico…Dona Das-Oracle 2 views 0 comments 1 point Started by Dona Das-Oracle Reporting and Analytics for HCM -
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 924 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 53 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 954 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 52 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 62 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 122 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 33 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 TU 73 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 23 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 33 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 33 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 152 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 52 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 45 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 42 views 1 comment 0 points Most recent by Riti Malhotra Reporting and Analytics for HCM