OTBI
Discussion List
-
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 797 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 727 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 61 views 2 comments 0 points Most recent by Richard Kemp-Eyre Reporting and Analytics for HCM -
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 93 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Is Manager Display Name available in OTBI? What SA can be used?Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Hazel De Castro 21 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
OTBI challenges rendering null valuesSummary: OTBI challenges rendering null values. Content (required): Hi experts, We experiencing challenges to come up with a solution to correctly show the data in the O…Volodymyr Faranosov 112 views 4 comments 0 points Most recent by Volodymyr Faranosov Reporting and Analytics for HCM -
Need subject area to get the manager name of inactive employeesSummary: Need subject area to get the manager name of inactive employees Content (required): Hi, I need subject area to get the manager name of inactive employees. For e…
-
OTBI Subject Area not displaying Payroll Periods After a certain PeriodSummary: I am facing an issue where in the Subject Area ( Payroll Ruy Result Real Time ) is not fetching the Payroll Period Data of an Employee after a certain Period (s…Rajit Paliwal 12 views 5 comments 0 points Most recent by Sharon Harper Reporting and Analytics for HCM
-
Steps to create OTBI Report / BI Publisher Report for Planned Schedule → Time ManagementSummary: we need steps to configure Planned Schedule report which can be useful for HR Representatives and HR Admin which provides information of employees whose Worksch…
-
Learning ProgressContent we are trying to mimic the reporting for learning on the front end that shows progress (1/5) for the specialization or course but I can't find this field. see sc…Riti Malhotra 49 views 3 comments 1 point Most recent by Lanette Frank-Oracle Reporting and Analytics for HCM
-
Could not able to fetch various seniority dates through OTBISummary Could not able to fetch various seniority dates through OTBIContent Hi Team, We are looking to fetch different seniority dates like VLSR Date, Enterprise Hire Da…Harish Kumar Kovi 227 views 25 comments 0 points Most recent by Dannielle Dellucci Reporting and Analytics for HCM
-
How to put the information into one row and limit the duplications?Hi All, I've been working on building a report to show the employee's personal information (address, contact number etc) and include their emergency contact information …
-
Manage Seniority Dates subject areaSummary Need to know the subject area for reporting the dates in the Manage Seniority Dates action menuContent I'm looking for the subject area that can be used to repor…User_2025-01-29-22-47-27-383 137 views 18 comments 0 points Most recent by Dannielle Dellucci Reporting and Analytics for HCM -
Seniority Dates V3Summary OTBI Subject Areas to Report on Seniority Dates V3Content Does anyone know if the Seniority Dates V3 are available in any OTBI Subject Area? We need to be able t…Lindsay Lamont 264 views 28 comments 0 points Most recent by Dannielle Dellucci Reporting and Analytics for HCM -
Union for 2 reportsSummary: How can I combine the output of 2 reports into one output Content (required): I have two reports, both using the same 2 Subject Areas (Workforce Management - Wo…Joe Dorrian 31 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Usage of BI System RoleSummary: Usage of BI System Role Content (required): Hi Team, We would like to know the usage of BI System Role. Please share your knowledge on the same. Version (includ…Vasanthakumar Ravi 21 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
How to query the organizations in the Organization List of an Organization Security Profile?Summary: How to query the organizations in the Organization List of an Organization Security Profile? Content (required): The Organization List section of the Organizati…User_2025-01-25-06-00-22-809 548 views 5 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
OTBI Reports on agents and delivery recipientsSummary: Hi, any reports that can give you the report agents, including the schedule and the list of the recipients (by username or email address)? Thank you! Jenia Cont… -
Provide access to OTBI report by Area of Responsibility by BUSummary: Content (required): We have a requirement that the user will have only Employee and/or Line Manager Role and they should be able to fetch the employee records i…Vinay Gharge 251 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Sql Query to Fetch the Last Modification Date and Last Modified By Details of SSOSummary: Can any one please help with a sql query to get the last modification date, last modified by, Created by details for SSO configuration. Content (required): Vers…MilanMohanty 279 views 2 comments 0 points Most recent by MilanMohanty Reporting and Analytics for HCM
-
Embed bursting report content in body of email?Summary: Embed bursting report content in body of email? Content (required): Hi all, Hoping someone can advise if it is possible to embed report content within the body …Luke.Findex 51 views 3 comments 0 points Most recent by Aaron Hager Associated Bank Reporting and Analytics for HCM -
Turnover- Last 3 monthsSummary: Content (required): trying to add a filter for the last three months but nothing is pulling - I tried several sql expressions and repository variables xml attac…Riti Malhotra 41 views 8 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
DFF Values Missing from OTBI ReportContent Hi, I had an Analysis report that looked at 2 different DFFs from the Workforce Management - Documents of Record Real Time Area and reported back on the values i…Joe Dorrian 111 views 13 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Career Profile Dashboard: Filtering for Performance Tiles and Analysis Not WorkingSummary: We're creating a Career Profile dashboard and would like tiles/drill down analysis to display for employees whose career profile is In progress (1-8 out of 9 se…
-
Drill downs on DashboardSummary: Why does drill down report different numbers to dashboard when its the same report? Content (required): I've created a dashboard report for absence reasons, but… -
Missing time card OTBI/BIP report or analysisSummary: Content (required): Is it possible to create an OTBI or BIP report to show employees who have not handed in their time cards? Either standard or customized repo…Nicolas Vahman 489 views 4 comments 1 point Most recent by user5969783 Reporting and Analytics for HCM