OTBI
Discussion List
-
Requested feedback reportContent We are trying to build a report to get the requested feedback details using ‘Workforce Performance - Requested Feedback Real Time’ subject area. However, no data…User_2025-02-05-23-59-37-171 105 views 13 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Filter Person Number Using Copy PasteSummary: In an OTBI Analysis, is there a way to filter a column based on a copied list of values? For example a column from an excel file or a comma separated list. For … -
Payroll Arrears Audit ReportSummary Allows you to audit for any arrears deductions prior to finalizing payrollContent This audit report is run after the first payroll calculation to check for arrea…Becky Stalsby 255 views 4 comments 4 points Most recent by Stephanie Turner Reporting and Analytics for HCM -
Tenure in Job FamilySummary: Content (required): I am looking for time in job family. I have reports already for overall tenure and time in current assignment/job but need something for job…Riti Malhotra 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Report to fetch the timecard approver detailsSummary: Content (required): We have a client requirement to build a report to fetch the timecard approver details. Does anyone know whether it is possible to fetch the …Prajna Hegde 127 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Secure OTBI so user can see only 1 folderSummary: We are implementing EHS and want the safety managers to only see the EHS folder under the custom folder. Content (required): Do we need to apply permissions to … -
OTBI does not show accrual/absence balance dataSummary: I'm trying to create a report which shows an employee's accrual. However it does not show any data in OTBI. Content (required): I want to create a report in OTB…Nicolas Vahman 333 views 8 comments 0 points Most recent by Sandeep001rp Reporting and Analytics for HCM
-
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 41 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 31 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 44 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 21 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 372 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 51 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 61 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 32 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 41 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 183 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 600 views 4 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM