OTBI
Discussion List
-
Add the Not Passed to the Overdue count - Learning OTBISummary: Content (required): Hi there, we have a Top Overdue Count report for Learning. It uses the metric Overdue count. We use a simple filter based on that metric (se…Bobby Jourdan 11 views 5 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Prior Job in Promotion ReportSummary: Add prior job to OTBI report. Content (required): I have a promotion OBIT report that works great. I have a request to add in the employee's prior job. How can …Greg Rank 43 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Sample OTBI Dashboards/Reports - RecruitingSummary: Content (required): Are there any recent shared sample packs of dashboards or reports related to ORC Recruiting? Version (include the version you are using, if …Toni Olivier 145 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Active Profile QuerySummary: Looking for help on how to build a query that checks for active profiles within different environments Content (required): Hi all, I'm looking to see if anyone …
-
Where is the rate field for hours worked?Summary: Content (required): I have a report that uses the subject area Payroll - Payroll Balances Real Time, but it does not have a pay rate field. Below is an example …
-
Font size is different for different fields after removing HTML tags in OTBI reportSummary Font size is different for different fields after removing HTML tags in OTBI reportContent Hello Everyone, Can you please help me regarding this issue? Created a…User_1OXJZ 43 views 3 comments 1 point Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM
-
Is there a way for an Analysis to retrieve the results of a data model?Content Hi, I currently have a data model but I need its results to get displayed via OTBI. Any way to achieve that? Thanks, IsaacICO 28 views 10 comments 2 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM
-
BI Dashboard filter causing score tiles to not showSummary: We have a dashboard built to summarize the scores of a questionnaire. When we filter, even though there is data, some of the tiles will randomly not show up. If…
-
Population Counts - Year over YearSummary: I am looking to create an analysis, which will be connected to a dashboard, to report population counts year over year. I have included an example below: August…User_2025-03-07-05-50-05-831 14 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Need to get the latest Salary fromSummary: I need to get the latest salary for all employees who have left. Content (required): I am using the Compensation - Salary History Details Real Time subject area…GJ79 33 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Age calculation on As-Of-DateSummary We need to build a report which shows the age of Worker on As-Of-DateContent We need to build a report with As-Of-Date variable so that it would also calculate t…Niko Hölttä 145 views 7 comments 5 points Most recent by Rahamathulla Rawther-274263 Reporting and Analytics for HCM
-
Table Prompts Repeating ValuesSummary: Pivot table and data table are linked with a channel so the table will update depending on where in the pivot table the user clicks. However the table prompts a…
-
How to fetch the contract end date of a future contract extension using OTBI?Summary: Hi All, We have a requirement to fetch the Contract End Dates of contract extensions that have a start date in the future. OTBI only seems to fetch the Contract…User_2025-02-11-06-38-03-841 282 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How do I create an analysis that pulls most of the fields on the Element summary screen?Summary: When creating an analysis, the analysis either drops records or stops returning any records after adding certain fields that may not contain any data. I am curr…BeachDreamer 31 views 11 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
How to create a report for worker and theirs Individual CompensationSummary: Im trying to create a report to follow individual compensations for workers, but using the subject area i couldnt create any report, when combine the worker fou…Lucas B Maciel 12 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Saved/Draft Rating Manager evaluationIs it possible to report on manager evaluation(saved) without employee submitting the rating? I am trying to create a report to pull manager evaluation with any status. …
-
Need to remove one measure column's grand total value in OTBISummary Need to remove one measure column's grand total value in OTBIContent We have Grand total value for two measure columns in OTBI Report. We need grand total value …User_2025-02-04-17-42-01-535 169 views 5 comments 1 point Most recent by Jodi Johnson Reporting and Analytics for HCM
-
Adding additional information from add absence pageWe added a few input boxes on the add absence page, how can we see them in OTBI? Do we really need to develop custom BIP models for things this simple?Praveen Kadiyala 31 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Request for a report on employee utilization of Oracle HCMSummary: I am looking to understand how the system is being used by the employees in my company. Content (required): I would like to be able to report on who is using th…HROps17 34 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
how to find the dff in headcount otbi reportSummary: I am unable to find the DFF called 'Worker's Comp Code' under the subject area Workforce Management:- Worker Assignment Real-time So , Can anyone help me how to…Deepak Bhatt 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Table/Views required which contains all the created data model ,report/analysis in the instanceSummary: Hi, I need table/view name which contains all the data model, report, analysis information created in the system and all the fields which are being used by that…
-
Unable to get DFF and EFF fields in OTBI in Worker AssignmentSummary: Content (required): We are unable to get the following fields highlighted below in OTBI Subject Area "Workforce Management - Worker Assignment Event Real Time":…Vinay Gharge 80 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Unable to get inactive or future dated employees in OTBISummary: Content (required): We are using the subject area "Workforce Management - Worker Assignment Event Real Time" and we are unable to get inactive or future dated e…Vinay Gharge 32 views 2 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
we have requirement of how extract person history detailsSummary: Hi Team, we need to create the report on history details of person like surname before marriage and after marriage , etc of person history details Content (requ…AjayKumar Maddipati 13 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to report the completion date for Journey questionnaires and or tasks?Summary: Is there a way to report on the specific completion date for when a journey questionnaire or general task is completed? Right now, I have noticed a completion d…Emily Cox 65 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Employees Performance goal BI report not showing properly in excel outputSummary Employees Performance goal BI report not showing properly in excel outputContent Hi , We have requirement to create bi reports to fetch the below goal columns fo…nitin Sharma 23 views 3 comments 0 points Most recent by User_2025-02-11-22-13-57-078 Reporting and Analytics for HCM
-
Payment Method Bank Account Details is not available in OTBI Payroll Personal Payment details RealSummary: We have a customer requirement that we only need to use the Bank Account in ESS Personal Payment Method but when we try to create an OTBI using the Payroll Pers… -
Custom metric doesn't work inside dashboardSummary: Content (required): Hello, We realize a new custom analysis in order to calculate the #Avg Time To Fill (Days), we use this formula: AVG( CAST( TIMESTAMPDIFF( S…Giuseppe Iacono 21 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
Can hourly rates be reported on?Summary: Our workforce has both salaried and hourly associates and we have a requirement for an analysis to show hourly rates using the SA Compensation Salary Details Re…
-
Report on Structure (Quick Actions, Apps) with default seeded Expression Languages from Vanilla versSummary OTBI Report on Structure (Quick Actions, Apps) with default seeded Expression Languages from Vanilla version as old value and new value as custom expression lang…