OTBI
Discussion List
-
Does a CLOB column supported by Advanced SQL Tab in OTBI when combining two subject areas?Summary: I always get an error when I tried combining two subject areas in OTBI under Advanced tab which consist of a CLOB column such as comments. Does anyone know how …Hazel De Castro 43 views 3 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
OTBI Subject Area or Query to retrieve Job Profile informationSummary: Content (required): Hello experts, is there an OTBI subject area to retrieve Job Profile information such as: ProfileItemId, ProfileId, ProfileCode, ContentType… -
Reporting issue - How to show sickness days vs actual worked daysSummary: Reporting issue - How to show sickness days vs actual worked days Content (required): I am trying to write a report to show the number of days a person is contr…User_2025-03-07-06-11-23-192 21 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Adding Department to existing report - Employee Absence CalendarSummary: We are using the report - Employee Absence Calendar - from here - https://community.oracle.com/customerconnect/discussion/70219/employee-absence-calendar/p1 it …Ian.Gooderham 61 views 6 comments 0 points Most recent by Helen Thomas Reporting and Analytics for HCM
-
Why do I keep getting an error when trying save an agentSummary: I am creating a new agent, when I save I get the below error? Any ideas why. Thanks! Content (required): Version (include the version you are using, if applicab…Lisa_R 34 views 3 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Performance Document RatingsSummary: Performance Ratings from 2 different performance documents on the same row. Content (required): I'm reporting on End of Year Review ratings but need to pull in …David McLellan 52 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Rescheduled agents are running twiceSummary: We've run into an issue with rescheduled agents running twice - once at the origninally scheduled time and again at the new time. Content (required): When viewi…Kelly Basnett 43 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM -
Compensation Amount (Filtered by Team) field OTBI Subject Area in CompensationSummary Compensation Amount (Filtered by Team) field OTBI Subject Area in CompensationContent Hi All, Could you please suggest in which Subject Area/Attribute or BIP tab…
-
Need inputs to use all secure views in the reportSummary: Need inputs to use all secure views in the report Content (required): If we want to display Core HR data like Person, Assignment, Position, Job, Department..etc…
-
Calculation Card Reporting - CitySummary: We need a way to report on employees that have a split percentage city tax (part work city & part home city to represent working partially in office vs. remote)…Chelsea Holden 22 views 1 comment 0 points Most recent by Andrew_Schmitz Reporting and Analytics for HCM -
How to get the two rows of data in single row in OTBISummary How to get the two rows of data in single row in OTBIContent Hello Team, I am using organization hierarchy in one report, we have two tree codes here, i want to …Harish Kumar Kovi 370 views 3 comments 0 points Most recent by Vinay Soni Reporting and Analytics for HCM
-
Reports - Page options available to the user environment?Hello, I have been asked to find a way to make available the page options of the analytics to the Reports tab. To be more specific, we need the gear icon from the analyt…Ioannis Adamou 53 views 6 comments 1 point Most recent by Ioannis Adamou Reporting and Analytics for HCM
-
OTBI Termination Dates for multiple periods of serviceSummary: Termination report in OTBI is giving the same termination date for two different periods of service. Content (required): My termination report is bringing back …Max W 32 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to get list of roles from systemSummary: Content (required): Hi Expert, We have a requirement to get all the roles we have in the system. So we just wanted to know how to get all the roles. Please sugg…Faizan Rashid 41 views 9 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Average Time of Two PhasesSummary: I'm looking for a way to report on the average time an application is in the Screen and Interview phases (combined and separately), but am having zero luck. Any…Jessica D 62 views 4 comments 0 points Most recent by Poorani Gibson Reporting and Analytics for HCM
-
Newer of two datesSummary: I'm looking for logic that will allow me to pull in two different types of hire dates (new hire date, re-hire date) and return the most recent date. Would I do …Scott Conaway 31 views 2 comments 0 points Most recent by Scott Conaway Reporting and Analytics for HCM
-
Absence calendar in line manager dashboard shows more workers for next monthSummary: the absence calendar in line manager dashboard shows absence for current and next month. I found the next next month does not only present direct reports, but a…Wouter.Schaap 42 views 3 comments 0 points Most recent by Wouter.Schaap Reporting and Analytics for HCM
-
Termination submission/creation dateSummary: I am looking for the date a manager enters a termination. Content (required): After receiving a resignation the manager enters a termination in Oracle. This is …Scott Conaway 184 views 2 comments 0 points Most recent by Scott Conaway Reporting and Analytics for HCM
-
Headcount for last day of previous monthSummary: Headcount for the last day of the previous month. Content (required): I would like to create a report that lists the Headcount for the last day of the previous …
-
OTBI report agent is not sending emails to multiple employeesSummary: Created an OTBI report to pull Work Email of the employees and send a pre-set communication. It works when tested for one/two employees, but it does not send th…
-
Active Employees signed up for Job AlertsSummary: How can we report on internal employees enrolled in Job Alerts? Content (required): We're trying to get a gauge on how many active, internal employees have enro… -
How to add multiple filters in HCM Extract Filter CriteriaSummary: We want to add another filter under HCM Extract Data Group Filter Criteria to filter out terminated employees who has been rehired later from our result set. Co…GauravGupta39 580 views 4 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
how to add a manager email as cc in a bursting report sqlSummary: I have a report which i'm trying to schedule, but i'm stuck at the cc part. i need to add the manager in the cc field. below is my sql, how do get the manager v…
-
Payroll Run Error ReportsSummary: Payroll Run Error Reports Content (required): Hi All, Greetings! What is the best option available to get the payroll run error list - apart from the flow 'Run …Parag Hiremath 12 views 0 comments 0 points Started by Parag Hiremath Reporting and Analytics for HCM -
Subject Area Access for Compensation - Salary Details Real TimeSummary: I have given an employee the two roles below ORA_CMP_COMPENSATION_ANALYST_JOB ORA_CMP_COMPENSATION_MANAGER_JOB This gives the employee access to Compensation - …Mark Stoker 74 views 5 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Wage Basis Rules Configuration ReportSummary: I have been tasked with creating a report for the Wage Basis Rules so that we can confirm the setup when an element is added to the system Is there a subject ar…User_2025-02-04-08-51-08-912 51 views 3 comments 1 point Most recent by Eric Geddes Reporting and Analytics for HCM -
ODBC Error - ADFService11g on OTBI AnalysisSummary: After 22B went into our Test environment, a report built on a few subject areas no longer works. It is giving us the following error: State: HY000. Code: 77031.…
-
OTBI Agent - Italic in narrative textSummary: Content (required): Hi, I'm creating an agent to send automatic emails: is it possible to insert some italic text? In case, could you please tell me how? Thank …Alberto Americi 12 views 4 comments 0 points Most recent by Alberto Americi Reporting and Analytics for HCM
-
Language translation for OTBI ReportSummary Can we change the language of custom OTBI report Report Header, Report Title and Report Name?pooja yelsangikar-Oracle 55 views 3 comments 0 points Most recent by User_IBL58 Reporting and Analytics for HCM