OTBI
Discussion List
-
Report Worker Details at Payroll Period End DateSummary: Is there a way that I can return the worker assignment details at the pay date of payroll period end date Content (required): I am building an OTBI report using…Sharon Harper 41 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Analyzing Skills and Competencies asked on Job DescriptionsSummary: We are looking for a Reporting or a Tool to expedite the following request from our VP Talent. Content (required): Is there some way we can pull a bunch of job …Alvaro Couto 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
BI Publisher versionSummary: Need inputs to find the BI Publisher version in Fusion. Content (required): Need steps/sql query to find the BI Publisher version in Fusion. Version (include th…
-
Incorrectly formatted phone number in OTBI tableSummary: Content (required): Hello! I have noticed a situation in our Fusion tables that I'm curious about resolving. We are currently seeing two phone numbers for two d… -
I can still see some of the factory folders even after removing the associated rolesHello, after applying Oracle method of hiding shipped folders in the catalog we still have some remaining that refuse to be hidden hehe. as seen below I logged in as a u…
-
Job Agent Sending to Removed RecipientSummary: Job Agent Sending to Removed Recipient Content (required): I had an OTBI report job agent and needed to change the recipient list, however, after saving the new…
-
Narrow Chart Down to Top 10Summary: We are trying to create a bar graph of the top 10 jobs that termed for the year. Is there a way to only show the top 10 rather than all the jobs?Rebekah Gilday 11 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Add New Column Based on Days Between Two Dates ResultI'm using the Subject Area Workforce Management - Work Relationship Real Time. Below is a formula that calculates the number of days between Termination Notification Dat…
-
Performance Rating- Self review Rating not populatingI am trying to pull a report with Employee calculated rating after worker self evaluation task is completed. The report was running last year with rating populated , how…
-
Termination Bar Chart by MonthSummary: We are trying to make a Bar Chart to show # of term by Calendar Month but the format of the month looks strange. Is there a way to list Calendar month with name…Rebekah Gilday 1 view 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Last Day of the Previous Month Active HeadcountSummary: SQL for Period Start Active Headcount minus 24 hours Content: We are looking for a SQL formula that takes the delivered measure Period Start Active Headcount mi…Rebekah Gilday 21 views 2 comments 0 points Most recent by Rebekah Gilday Reporting and Analytics for HCM
-
Multiple keywords in single OTBI column filterSummary: Hello everyone, The client is building some OTBI reports and would like to include multiple keywords in one column filter by typing the text in and not selectin…PriyaPenugonda-SC 41 views 4 comments 0 points Most recent by PriyaPenugonda-SC Reporting and Analytics for HCM -
How to connect a course with specialization in OTBIHi Team, Can you please tell me How can we connect a course with specialization and how can we get the learning outcome of a person from the respective course. Thanks
-
HeadCount OTBI reportSummary: Hi all I added these subject areas in my otbi reports:- Workforce Management – Worker Assignment Real-Time Compensation – Salary Details Real Time Workforce Man…Deepak Bhatt 31 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
DFFs no longer available in applicable Subject AreasSummary: Production Report Errors - DFFs no longer available in applicable Subject Areas Content (required): Has anyone had issues with DFFs in Analyses? Beginning the a… -
Combine 2 Analysis Outputs in on AnalysisSummary: Content (required): I have requirement to report on the number of starters by user person type and leavers by user person type in the previous month and email t… -
Performance Rating- Self review Rating not populatingI am trying to pull a report with Employee calculated rating after worker self evaluation task is completed. The report was running last year with rating populated , how…Anita 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Need help of running Element Entries - Real Time report for Workers Element entriesSummary: Hi Experts, We need to report on payroll elements for Employees. We have tried to use the subject area Payroll - Element Entries Real time. Whenever we are addi…Silpi 42 views 4 comments 0 points Most recent by Dannielle Dellucci Reporting and Analytics for HCM -
How do I set an OTBI agent to only Email if there is data returned in analysis?Summary: How do I set an OTBI agent to only Email if there is data returned in analysis? Content (required): Hello I am trying to set up an agent but I only want to it t…Helen Thomas 21 views 2 comments 0 points Most recent by Helen Thomas Reporting and Analytics for HCM
-
Ethnicity- Multi resulting in errorSummary: I am trying to decode the multiple option selected in the race condition used: COUNT(DISTINCT "Worker"."Employee Ethnicity Code" by "Worker"."Person Number") > …Anita 51 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Reporting on real trends in headcount by hierarchy excluding impacts of reorganisationsSummary: We need to provide headcount trend data to our business leaders and managers for their respective organisation without the impact of reorganisations being visib…User_2025-03-07-20-15-16-297 31 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI Turnover Dashboard for Line ManagersSummary: I would like to provide a Turnover Dashboard for Line Managers in OTBI but the seeded / sample dashboards provided by Oracle are not returning data when logging…User_2025-03-07-20-15-16-297 152 views 13 comments 0 points Most recent by User_2025-03-07-20-15-16-297 Reporting and Analytics for HCM
-
Query to extract ExternalWorkerDataId by Start/End Date and Person NumberSummary: Hello experts, I should update external worker data. However, ExternalWorkerDataId information is not available in OTBI analysis. Is there a query available to …Valerio Curzi 21 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Error running OTBI AnalysisSummary: Getting error ' Incorrectly defined logical table source (for fact table Z - VO OBIA ETL) does not contain mapping for....' Content (required): I've had this sa…Susan Anderson 11 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Leavers not showing now on manager dashboardsSummary: Leavers show very small numbers or nothing Content (required): My dashboard reports have been working fine but now I'm getting reports from managers that they c… -
Report showing latest Talent ScoreSummary Report showing latest Talent ScoreContent I'm trying to create a report which shows the latest Talent Score for each employee, where some of these will have been…Emily Robinson 36 views 9 comments 0 points Most recent by Andrew_Schmitz Reporting and Analytics for HCM
-
How to remove empty sub rows from a particular column in the OTBI report?Summary: I am getting the sub rows for employee self-rating and manager rating. I want to fetch the ratings for sections goals, competencies and overall summary. I have …
-
Job Qualification and Description for a profile from OTBISummary: How to get Job Qualification and Description for a profile from OTBI? I tried to find on Workforce Profiles - Model Profile Real Time but could not get it. Job …User_2025-02-12-02-30-59-547 33 views 4 comments 0 points Most recent by Sumathi Muthu Reporting and Analytics for HCM -
HCM Field VS Subject AreaSummary Trying to find a document that tells me which field on the front end maps to which subject area and fieldContent Hi, I am trying to figure out the best way to fi…
-
Added a report into OTBI Dashboard - Download is happening as two different PDFSummary: We have added a report as a section into Job Profile OTBI Dashboard, when i try to download the result into PDF, the report we have added is downloading as diff…Sumathi Muthu 31 views 6 comments 0 points Most recent by Sumathi Muthu Reporting and Analytics for HCM