OTBI
Discussion List
-
How to create a printable report?Summary: Content (required): Hello everyone, We are trying to understand what are the needed steps to give the opportunity to the users to print the performance report. …Agapi 21 views 3 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM -
How to fetch all the columns from different folders in OTBI Payroll?Summary: Content (required): In Payroll-Payroll Balance Real Time Subject Area, when i am fetching the column from different folder ,it is showing "no results". How to f…Deepika Huron 41 views 5 comments 0 points Most recent by David Bean-259734 Reporting and Analytics for HCM -
Difference between SQL Data Sources?Summary: Content (required): Hello everyone, We are trying to create a new Data Model for Performance Management in HCM by using an SQL Query. However, we are not sure w…Agapi 51 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to find missing privilege to get archive and unarchive options on reportsSummary: How to find missing privilege to get archive and unarchive options on reports Content (required): Hi Team Greetings! The archive and unarchive options are not s…Parag Hiremath 214 views 10 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Double Column PromptSummary Can we do double column prompt in OTBI like we can in data model?Content In data models, we can create double column LOV similar to... select description, id fro…User_2025-01-22-18-30-18-571 39 views 5 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Wrap Heading Text OTBISummary: I know I have to be missing something simple, but trying to find out how to show the entire title of the included screenshot (Full title is Number of Job Applic…Jessica D 31 views 2 comments 0 points Most recent by Amrita Gupta-Oracle Reporting and Analytics for HCM -
Facing Error when exporting to excel using the formatted optionSummary: When I export reports from OTBI into excel using the formatted option I receive errors stating 'We found a problem with some content in 'File Name'. This then o…Dannielle Dellucci 11 views 4 comments 0 points Most recent by Dannielle Dellucci Reporting and Analytics for HCM -
Annual Leave Following Maternity LeaveSummary: Pick up if an absence spell directly follows a different type of absence, Content (required): In OTBI is there anyway to detect if an an absence spell directly …David McLellan 11 views 0 comments 1 point Started by David McLellan Reporting and Analytics for HCM -
How to create Cross subject area analysis - real time (Checklist and Worker Assignment) - ErrorSummary: Error creating cross subject area analysis - Error View Display Error Odbc driver returned an error (SQLExecDirectW). Content (required): Error when joining sub…Luciavw 31 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Work Schedules OTBI - employee missing from analysis if no work scheduleSummary: Work Schedules - if employee does not have a work schedule they are missing from the analysis Content (required): We create OTBI analysis using Worker Assignmen…Michelle Hughes 91 views 11 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Work Relationship Last Update Date vs Current DateSummary: Hello - we are trying to create a Termination report that will be scheduled to run daily with the condition that the termination date equals Current Date OR the…Shanna Oppenheim 31 views 5 comments 0 points Most recent by Shanna Oppenheim Reporting and Analytics for HCM -
Error when using different subject areas in OTBI: Odbc driver returned an error (SQLExecDirectW)When I am trying to use different subject areas (Workforce Management-Checklist real time and Recruiting Real time), I am getting the below error in the Results. Odbc dr…Mohit Sinha-Oracle 61 views 6 comments 0 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for HCM -
OTBI > Ability to get the work schedule assigned to Employee in reportContent Hello All, I will appreciate your support in the following issue: Do you have an idea if possible to get the work schedule assigned to employee in OTBI or via SQ… -
How to display URL or attachment in OTBISummary: After adding attachment url from subject area facing this error Content (required): Health and Safety module Version (include the version you are using, if appl…Surya -Oracle 161 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Table to pull the Highest Education Level in BIPSummary: Need to determine the table that retrieves the Highest Education Level under Person details Content (required): Version (include the version you are using, if a…RenzelkeithCoquia 843 views 2 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Report on Alerts Composer Notification ReportingSummary: I'm looking to see if there are any OTBI subject areas that can be used to report on the various event notifications that are sent out using the Alert Composer …Rohan Fernandes 31 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Audit log or report for configuration changes to the systemSummary: Is there a report or change log that can be obtained from system on application configuration changes ? Does anyone know of an audit log or report for configura…MilanMohanty 763 views 4 comments 2 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Work Schedules for non-primary assignments in Person Real Time Subject AreaSummary: I'm trying to report on the work schedules for employees with multiple assignments. However the OTBI Person Real Time Subject Area / Person Schedule Assignment …Richard Kemp-Eyre 64 views 2 comments 0 points Most recent by Richard Kemp-Eyre Reporting and Analytics for HCM -
OTBI Report for Procurement agents setup and accessSummary: OTBI Report on Procurement agents setup and access Content (required): Hello, Can someone help me to make a report on procurement agents and access levels to ot… -
How to obtain Source System ID for absence entriesSummary: Content (required): I have a requirement to use HDL to delete and then re-submit a large quantity of annual leave absence entries. I have an HDL file that I can… -
Getting error when person extra info flexfield is pulled in OTBI reportSummary: Getting error when person extra info flexfield is pulled in OTBI report Content (required): I am getting following error when I dragged and dropped one of the p…Swati U 21 views 2 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM -
Time to complete self-paced learningSummary: Is there a way to report on the time taken from launching a piece of self paces learning to the point it is finished? We have a lot of compliance offerings whic…Elizabeth Docherty 21 views 2 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Display OTBI without SecurityContent Hi all - we have a dashboard we display some reports on for users that do not have Fusion security (other than a standard employee access). For our BIP reports, …Prudence K 100 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM