OTBI
Discussion List
-
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 140 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 31 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 34 views 6 comments 0 points Most recent by Sumathi Muthu Reporting and Analytics for HCM -
How to get data in 2 fields for Payroll Relationship -> 'Time Card Required' ?Summary: There are two fields for 'Time Card Required' on the Payroll Relationship responsive page. One is at the Payroll Association level and other at Payroll Assignme…Vinay Hardas 138 views 4 comments 0 points Most recent by Andrew_Schmitz Reporting and Analytics for HCM
-
Performance Rating History OTBISummary Looking for an OTBI report with Annual Performance Ratings for the last 3 yearsContent Hello I am looking for an OTBI report with Annual Performance Ratings for …User_2025-02-10-08-27-16-805 73 views 18 comments 0 points Most recent by Natalie A. Reporting and Analytics for HCM
-
Find column in OTBI reportSummary: Hi all, I have added these subject areas in my report:- Workforce Goals - Goal Plan Assignments Real-Time Workforce Goals - Goal Status Overview Real-Time Workf…Deepak Bhatt 23 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
OTBI export to excel and lost data.Summary: Content (required): Hello everyone, I wanted to ask you if you could provide us with more information or if it has also happened to you regarding the loss of da…Gerardo Peluso 53 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Logical SQL Dashboard Not Working After 22BSummary: Hi - we have a report that pulls payroll information and salary information. It is run weekly by our compensation team. It was working fine through last week an…Kyle Norris 11 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Line Manager can't see Time cards in OTBISummary: Content (required): Hi The Line Manager role can't access time card reports (standard Oracle Time Cards). The reports are standard and delivered by Oracle. The …Nicolas Vahman 41 views 2 comments 0 points Most recent by Nicolas Vahman Reporting and Analytics for HCM
-
Difference between data table join.Summary: Difference between data table join. Content (required): Hello All, I have some confusion on table joins. Please refer below example. I have two data tables. PER…
-
Folder Level Security (Idea/Feasibility)At our organization, the staff is used to our discoverer reports where one report will pull from multiple tables/views, after asking around and looking at OTBI security …Praveen Kadiyala 42 views 5 comments 0 points Most recent by Praveen Kadiyala Reporting and Analytics for HCM
-
OTBI Report ColumnsSummary: I am using three Subject Areas: Workforce Performance - Performance Document Status Real Time Workforce Performance - Performance Rating Real Time Workforce man…Anshul Varshney 31 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Bank Statement Analysis Report > Bank Statement TransactionsWe are trying to validate the transactions being reflected on this report. Here's the full path of the seeded report: Shared Folders > Financials > Cash Management >Bank…
-
Turnover Analysis - Line Manager DashboardsSummary Count fields - Termination Headcount, Voluntary Termination Headcount under Subject Area "Workforce Trends" are not reflecting correctContent Hello, We are looki…User_2025-02-05-07-43-29-505 140 views 9 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Error in OTBI reportSummary: Content (required): Workforce Management- Worker Assignment Real Time Workforce Goals - Goal Plan Assignments Real Time Workforce Goals - Goal Status Overview R…Deepak Bhatt 31 views 2 comments 0 points Most recent by Deepak Bhatt Reporting and Analytics for HCM
-
Fiscal Year HR ReportingSummary Needing to have reports such as a Turnover Report that is based on Fiscal Year vs Calendar YearContent Does anyone have any experience or examples on how i could…Rob Stahly 91 views 8 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
FTE and Salary - Compensation Salary Details Real Time Subject areaSummary: The FTE and Annualized Full Time Salary appear to be sourcing the FTE from the Assignment instead of the Salary row Content (required): I'm digging into an erro…Rob F 41 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
No Data in OTBI when Department Name is addedSummary: Content (required): We are using Subject Area "Workforce Goals - Goal Plan Assignments Real Time". When we add Worker.PersonNumber then we are getting all the 1…Vinay Gharge 11 views 11 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Cost Center ReportingSummary How to report on Cost Centre in Cost Accounts section of Manage Costing of DepartmentContent All, I am new to Fusion OBTI reporting and am hoping you can help me…Prudence K 179 views 6 comments 0 points Most recent by User_2025-02-12-21-43-20-416 Reporting and Analytics for HCM -
Logical SQL is not recommended?Summary If Logical SQL isn't the answer what is the recommended approach?Content Hello Everyone, I've been told through a recent Technical SR that Logical SQL is not a r…Rob F 66 views 12 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Where can I find tax registration Number for Reporting UnitSummary: Please can anyone tell me where the tax registration number is in OTBI, I am wanting to add it to a report but cannot find it. Content (required): I am looking …Sharon Harper 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Unable to pull specific employees for a performance reportSummary: Team - My counts vary as I try to pull additional fields from a specific report that pulls from the following areas: Compensation - Workforce Compensation Real …Vijay Rajendran 11 views 1 comment 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How create a Recruiting Report with ReasonSummary: Content (required): Hello Guys, We would create a Report that extract the reason linked to the last event for each worker, how we can create it, in our database…Giuseppe Iacono 11 views 3 comments 0 points Most recent by Madhavi-Oracle Reporting and Analytics for HCM