OTBI
Discussion List
-
How to display grade from prior salary change on same lineSummary In a comp history analysis, I need to report on employee's grade as of the salary update immediately prior to the current salaryContent Subject Area: Compensatio…James Hoffmann 78 views 7 comments 0 points Most recent by James Hoffmann Reporting and Analytics for HCM -
Manager's Assignment StatusContent Hi all - I have a requirement to report on an employee, their manager, and their manager's assignment. We are finding the following issues and need to know how t… -
Unable to export report from OTBISummary Error Message when exporting reportContent Hi, I recently fixed a problem with a Goals report that contained HTML coding in the success criteria & comments field…User_2025-02-05-22-44-35-842 141 views 6 comments 2 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Adding a field to Subject AreaSummary Trying to add a locate/add a field to an existing subject areaContent Hi, I am trying to figure out how to either locate this field or add it to an existing subj… -
Performance goals - additional attributes version typeSummary Is there any literature available about this field?Content Hi I have an OTBI report that contains the following field from the Workforce Goals - Goals Status Ove…User_2025-02-05-22-44-35-842 33 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
OTBI Reports with Prompts don't work from Reports and Analytics PageSummary I have my OTBI reports set up with prompts but when I try to run them from the Reports and Analytics page they don't work. It just runs straight through to the d…User_2025-02-04-18-03-17-329 69 views 7 comments 1 point Most recent by Sahil_Makhiza Reporting and Analytics for HCM -
Can we create OTBI report for COmpetencies which include audit detailsContent Hi All, We have created competency, in OTBI is only showign the latest update on competency. for example we are changing rating for comp A from medium to Low on …Dev R 41 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Report on Terminated Employees Sickness AbsenceSummary We cannot report on sickness absence data for terminated employeesContent Hello, We have a requirement to report on the average working days lost for all employe…Dawn Cawston - CPS 39 views 2 comments 0 points Most recent by Dawn Cawston - CPS Reporting and Analytics for HCM -
Security QuestionSummary Report needs to be run by many usersContent Hi, I have a simple report that runs using a From and To Date prompt that shows all New Hires within the chosen date …User_2025-02-05-22-44-35-842 43 views 2 comments 0 points Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM -
Payroll - Element Entries History Real Time - Input ValueSummary Payroll - Element Entries History Real Time - Input ValueContent Hi, I am trying to create an analysis for the subject area Payroll - Element Entries History Rea…User_3YB1F 80 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Zip the multiple fileSummary Zip the multiple fileContent Hi Experts, We have a requirement to zip multiple file and email to user using bursting. Can we achieve this? Thanks and Regards, Ra…Rajeev Nayan 47 views 2 comments 1 point Most recent by Rajeev Nayan Reporting and Analytics for HCM -
Analysis is giving an ODBC Driver errorSummary Analysis joining two subject areas not workingContent I have an analysis that has been working up until this morning (the analysis is emailed to our team every w…User_2025-02-04-08-51-08-912 41 views 15 comments 1 point Most recent by User_2025-02-04-08-51-08-912 Reporting and Analytics for HCM -
Fusion Table for BIP informationContent Hello All, Is there any tables available which is holding the information of BIP(Data models, template, etc) details. Thanks GaneshGanesh Kokkula 49 views 2 comments 0 points Most recent by Ganesh Kokkula Reporting and Analytics for HCM -
HR Helpdesk Seeded Dashboards And AnalyticsSummary HR Helpdesk Seeded Dashboards And AnalyticsContent We are looking to explore if there are any seeded HR analytics available for the HR desk. We have referred to …User_2025-02-10-08-27-16-805 75 views 2 comments 0 points Most recent by User_2025-02-10-08-27-16-805 Reporting and Analytics for HCM -
Termination report to be run as termination date added/changedSummary Termination report to be run as termination date added/changedContent We want to build a report in OTBI that is run on an agent anytime a termination date is add…Emily Robinson 97 views 4 comments 2 points Most recent by Emily Robinson Reporting and Analytics for HCM -
Data-model from Analysis not working after 20BSummary Data-model based from Analysis keep saying path not foundContent After receiving 20B update, it seems like our Data-models are having issues (which are tied to A… -
Please Save BI Answers Direct Database Query SQL Definition before 19D UpgradeSummary Please save your BI Answers Direct Database Query SQL definition before 19D UpgradeContent Please Note: This notice does not affect BI Publisher SQL data models …User720640-Oracle 151 views 5 comments 2 points Most recent by User_R6A85 Reporting and Analytics for HCM -
Compensation Salary History Details Subject Area not returning termsSummary Compensation Salary History Details Subject Area not returning termsContent Compensation Salary History Details Subject Area not returning terms. It will only re…TerryM01 30 views 23 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Is there delivered Affirmative Action Report for US in Oracle HCM CloudContent Hi All I was told there should be delivered report for Affirmative Action Report for US as its statutory requirement But I could not find one. Can you please let…Naveen Jayaraman-48236 129 views 1 comment 1 point Most recent by Tony Johnson-Oracle Reporting and Analytics for HCM -
Is it possible to view reports as employee?Content Hello experts, our customer would like to enable a user to see a specific OTBI report. However, at the same time this user cannot have access to My Team and My C…Valerio Curzi 107 views 9 comments 2 points Most recent by AshishERPCloud Reporting and Analytics for HCM -
Odbc driver returned an error (SQLExecDirectW)Summary Error running reports for users in Production: Odbc driver returned an error (SQLExecDirectW).Content Hoping someone has encountered this issue before. We curren…AIT 54 views 4 comments 0 points Most recent by User_2025-01-30-21-52-52-008 Reporting and Analytics for HCM -
Benefits ReportingSummary Dependent that is an employee OTBI or BIPContent how do we determine that a dependent is an active dependent or a certain plan and an active employee at the same…User_2025-01-28-01-44-03-184 131 views 2 comments 0 points Most recent by Adam Gates-Oracle Reporting and Analytics for HCM -
Benefit Pending Action Item informationSummary Need back-end table name for Benefit Pending Action Item informationContent Hello Everyone, Can anyone share the table name/column name to identify benefit "Pend… -
Intermittent Error Preventing Report FilteringSummary When applying filters to our Business Unit Column we are intermittently unable to do so when creating OTBI analyses and when using previously created analyses.Co…Thomas Griffiths 28 views 5 comments 0 points Most recent by User_2025-01-30-21-52-52-008 Reporting and Analytics for HCM -
Joining Workforce Events to Person Real TimeSummary Having trouble getting the data to align between the two subject areasContent Hello Everyone, I've created a simple example of an analysis we're making to see ho…Rob F 40 views 11 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Sample Report: Salary Change Date Prompt (updated)Summary Sample salary change report using a date promptContent Salary Change Report Date Prompt This is part of the series of sample reports to use in your cloud environ…Gail Langendorf-Oracle 519 views 3 comments 4 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
OrganogramSummary Organogram RequiredContent Hi, I have come across many previous posts regarding organogram / organisational charts and none deliver a proper organogram whereby e…User_2025-02-05-22-44-35-842 53 views 37 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Row Limit? Missing RowsContent Hi all - I have a query (Logical SQL) that I use to run for changes. It runs Assignment and Salary changes. When I ran the report in April, it pulled back ~132K … -
Seniority hoursContent We are developing a report using OTBI and one of the columns is to populate employees Seniority hours. Wondering which subject area contains that information? We…User_WHB5J 42 views 6 comments 0 points Most recent by Aliasgar Khambhaty-Oracle Reporting and Analytics for HCM -
Analysis for finding positions with more than one EmployeeSummary Need a report that shows a list of positions that currently have more than one Employee in the positionContent I am trying to build an audit report that shows th…User_2025-02-04-08-51-08-912 41 views 6 comments 0 points Most recent by User_2025-02-04-08-51-08-912 Reporting and Analytics for HCM