OTBI
Discussion List
-
Educational Major meaning in OTBISummary Only code is available in Person ProfileContent Hello Everyone!I need your help again. We are building and Educational report and the Major information a code ("…Alvaro Couto 37 views 5 comments 1 point Most recent by User_2025-03-07-05-33-11-638 Reporting and Analytics for HCM -
HR Action Original creation dateSummary Report on HR Action original creation dateContent Hello, Has anyone written a report of HR Actions history that includes original action entry (creation) date? I…User_2025-02-04-15-06-22-759 84 views 5 comments 0 points Most recent by Scott Conaway Reporting and Analytics for HCM -
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 119 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 257 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 15 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 144 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 355 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 44 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 24 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 64 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 38 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 57 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 46 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 31 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 382 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 57 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 38 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 47 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 64 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 35 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 43 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 187 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…