OTBI
Discussion List
-
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 27 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…Anirudh Udupa 791 views 9 comments 0 points Most recent by Sudha Gopal Reporting and Analytics for HCM -
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 5 views 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 213 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 41 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 63 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 294 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 53 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…Maddipati Ajay Kumar 35 views 9 comments 0 points Most recent by Maddipati Ajay Kumar Reporting and Analytics for HCM -
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 406 views 7 comments 0 points Most recent by Andrew Gillibrand-Oracle Reporting and Analytics for HCM -
Report on Role MappingsSummary: I'm looking for a way to pull all Role Mappings currently set up. Is there a delivered one I'm missing? Or, does someone have a sample to share, please? Content…
-
OLC: is LIKE (pattern match) operator usageSummary How does is LIKE (pattern match) work?Content Hi, Has any one worked on the operator is LIKE (pattern match) in OTBI Analysis? If yes, can someone explain how th… -
How to Filter for Calculation Component Details in OTBISummary: Business requires a report to pull all current information on the Reporting Information Calculation Card where the Calculation Component Detail = Third-Party In… -
For impact analysis on BIP data models which meta data table is used in Fusion HCMSummary: As a part of impact analysis how can we find particular field is getting used in which BIP data models. Content (please ensure you mask any confidential informa…Siddhesh Nisal 36 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
BIP Report Tagged to OTBI Dashboard is taking long time and error outSummary: BIP Report is developed and tagged to OTBI Dashboard. Taking longtime more than 10 minutesand then error out Content (please ensure you mask any confidential in…Anjan Polimera 44 views 3 comments 0 points Most recent by LakshmiCharitha Cherukuri-Support-Oracle Reporting and Analytics for HCM
-
COUNT in a CASE statement for a calculated field in OTBISummary: Need to create a calculated field using COUNT and CASE statement Content (please ensure you mask any confidential information): I am using this Subject Area: Wo…Pradnya_Pampatwar 191 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM