OTBI
Discussion List
-
Headcount by week or date returning blanksSummary: Is there a way to report a headcount trend by week or by date using Workforce Trend subject area? Content: I'm trying to build a report that shows headcount by …Callum Jones 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Deep Link for Employee detailsSummary: Content (required): We have a use-case to send workflow notification BIP Report to the HR Team/Head in case of Termination or Re-hire. Oracle provides the stand…Vinay Gharge 21 views 1 comment 0 points Most recent by MilanMohanty Reporting and Analytics for HCM
-
Development Goals Count Scoreboard Employee WiseSummary: Need to display the count of the development goals in various status to the logged in employee in form of a dashboard Content (required): We have a requirement …Ronit Swain 41 views 3 comments 0 points Most recent by Jaydeep More Reporting and Analytics for HCM
-
How can I exctract Work Terms Number field in OTBI?Summary: Content (required): Hello experts, I need to extract in some way the Work Term Number field to update employee managers by HDL. Is it possible to find this fiel…Valerio Curzi 466 views 14 comments 1 point Most recent by Girish Singh-Oracle Reporting and Analytics for HCM -
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 41 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 147 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 41 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 27 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 11 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 34 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ä 149 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 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 32 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 11 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 166 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 32 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 31 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 72 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 31 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 11 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 67 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 22 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…