OTBI
Discussion List
-
Automatically exclude absent employees from auto OTBI enrollmentsSummary: Content (please ensure you mask any confidential information): We are getting a lot of heat to find a solution for removal/suspension of enrollments of people w… -
Signature in the reportSummary We need to store Digital signatures in the Fusion cloud and need to display same signatures in the reports.Content Hi All, Can we store Signatures in the Fusion … -
How to create a historical report with actions reasons in OTBI?Summary: How to create a historical report listing all actions/reasons since the hire date including future dated action reasons/ Content (required): I'm using Worker As…Stefaan Onderbeke 184 views 9 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Issue with OTBI Subject Area "Installed Base - Meter Based Asset Usage Real Time"Summary: Our issue is with the OTBI subject area called “Installed Base – Meter Based Asset Usage Real Time”. We can’t figure out how to exclude the canceled readings fr…Ajeez K-Oracle 21 views 2 comments 1 point Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP -
OTBI Dashboard-when i click the apply button it not changing the dashbord dataSummary: HI All, I have edtionally added completion date but when i click the apply button it not changing the dashbord data but when i apply the hire date of dates its …AjayKumar Maddipati 31 views 7 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
OTBI Report not showing item with Zero On-HandSummary: OTBI Report not showing item with Zero On-Hand Content (please ensure you mask any confidential information): Team, We have developed OTBI report using subject …Akancha Sinha 21 views 3 comments 0 points Most recent by Prasanth Senthivel-Oracle Inventory Management -
How to get the action reason from the Enterprise Hire Date?I'd like to get the Action Reason based on employee's Enterprise Hire Date. However, when I'm about to add the Action Reason column within the analysis, the value didn't… -
OTBI data quality dashboardCan I please ask if users have sample xml for data quality dashboard on key HR metrics? TIA. -
Current User/Logged in User Absence Details in OTBISummary Not able to fetch absence details of current user from otbiContent Hello Experts! I'm trying to build a report to get the logged in user/current user absence det… -
OTBI Subject Area Security IssueSummary: For the subject area Workforce Management - Person Real Time, we have a user "Mark Eliot" who can view employee's personal information (eg: address) even though…suamanch-Oracle 1 view 1 comment 0 points Most recent by suamanch-Oracle Reporting & Analytics for Fusion Service -
Report for all direct and indirect reportsSummary: I need to write a report for all employees that role up to each VP. Content (required): I need to write a report for all employees that role up to each VP. I wi…Donna Valentine 211 views 5 comments 1 point Most recent by Girishbabu800 Reporting and Analytics for HCM -
OTBI REPORT- ERROR WITH COMPENSATION SALARY REAL TIME DETAILS SUBJECT AREASummary: Hi All, when I try to add the Annualized salary and salary currency to an employee with a changed salary we find the following issue: 1. adding only the annuali…GiovanniD 43 views 13 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Compensation Plan Worksheet with notesSummary: I have created a report to pull compensation worksheet with notes. I am facing the following issues: 1) It only picks up employees with Notes. I need to pull th… -
How to fetch only One record for Expected Effort in OTBI Learning Subject AreaSummary: Hi Team, I'm trying to fetch the employee who has having max number of hours in the OTBI report. I can fetch the Sum of hours for each employee individually but… -
Integration between OTBI and FAWSummary: Integration or Linking possible between OTBI and FAW. Content (required): There is currently an ask to integrate OTBI and Fusion Analytics Warehouse (FAW). Is t…Annika Wan Yee 61 views 5 comments 1 point Most recent by Clare Murtagh Reporting and Analytics for SCM -
A report that tracks user access activity historySummary A report for security that tracks user login history what data or module was touchedContent Does anyone know how/where I can get this information together? This …Kimberly Nguyen 295 views 18 comments 0 points Most recent by Mayur_P Reporting and Analytics for ERP -
Is there syntax in OTBI I can use to round down?I have age in years as 22.6 which I need rounded down to 22. Using ROUND rounds up to 23; applying data formats rounds up. e.g: ROUND((CURRENT_DATE - "Workforce Manageme…Clare Murtagh 41 views 2 comments 0 points Most recent by Clare Murtagh Reporting and Analytics for HCM -
Filter not working for case statementSummary: I am creating a HDL formatted report to produce a list of employees that require termination from HCM. I have managed to produce a list of all the employees tha… -
OTBI-Dashboard promt values not showing in Dashboard after added the new oneSummary: HI Team, We have new enhancement requirement in old dashboard that is needed to change the check task name from HR Questionnaire First 2-weeks check into Onboar…AjayKumar Maddipati 33 views 9 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
Inventory transaction number in Inventory Transactions real time Subject areaSummary: Please suggest how to get the Inventory transaction number in Inventory Transactions real time Subject area Content (please ensure you mask any confidential inf… -
Performance Document Changes Audit ReportHello, We have a need to audit our Performance Documents to understand who all made changes on a performance document. Each time a rating is changed we want to generate …Nick Dorfner 334 views 7 comments 0 points Most recent by Andrew Gillibrand-Oracle Reporting and Analytics for HCM