OTBI
Discussion List
-
Latest Hire Date in OTBI without using Seniority DatesContent Hi All, We have a requirement at our project where we need to get the “Latest Hire Date” for any Person in OTBI. The challenge is Seniority dates are not exposed…User_F89L9 149 views 2 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Tuning a rolling 12 Months turnover reportSummary How to performance tune a trend based report when using Ago and Rolling PeriodContent Hello Experts! In my ongoing saga of working with the trends subject area t…Rob F 154 views 4 comments 0 points Most recent by Abhishek Dixit-Oracle Reporting and Analytics for HCM -
How can I get assignment manager list details when subject area doesn't have themSummary Subject area doesn't contain assignment manager listContent Hi I am trying to adapt a report for direct reports to a line manager only. However I've noticed some…LynneLBL 19 views 3 comments 0 points Most recent by Virginia M. Calvi Reporting and Analytics for HCM -
Absence Booked in future date with complete detailsSummary Absence Booked in future date with complete detailsContent Hi Team, We wanted to fetch all the employees who booked their absences in future-date (for example be…Mahendra 40 views 9 comments 0 points Most recent by User_2025-02-04-23-40-44-792 Reporting and Analytics for HCM
-
Absence balance reportContent I am trying to create an absence balance report for each accrual plan by employee. The report would look like the attached using the "Employee Plan Participation…Annette M 128 views 3 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM -
Month/Year prompt on 2 columns in HR Help Desk reportSummary Need prompts showing month/year combination for 2 prompts in OTBI report for Help DeskContent I am trying to create a report showing analysis of service requests…DennisOliver 48 views 6 comments 0 points Most recent by DennisOliver Reporting and Analytics for HCM -
Filter Column Data with other Columns?Summary Issue at the moment of filter column X with data of column YContent Hi everyone! I'm working on an analysis and I have the following information: 1. Column A wit…User_2025-02-11-02-54-34-044 31 views 1 comment 0 points Most recent by Amrit Reporting and Analytics for HCM -
Controlling BIP icons options(Home,Catalog etc.) while adding BIP link on infolet ViewSummary Controlling BIP icons options(Home,Catalog etc.) while adding BIP link on infolet view.Content Hi All, I am working on one requirement of infolet there is a requ…User_2025-02-06-23-45-30-095 29 views 3 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
How to populate to date field based on from date in BI reportSummary How to populate to date field based on from date in BI reportContent Hi All, We have a custom BI report and there are two parameters "Date from" and "Date To". h…Pradvin Prabhakar 20 views 6 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM
-
Infolet for line managers visible to all employeesSummary Issue with none manager workers viewing Line manager's InfoletContent Hi, I am new to creating Infolet's and I have been able to create an Infolet for our manage…User_2025-01-30-03-54-32-528 147 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Agents for scheduling reportsSummary Can I move a live agent to a different folder?Content Hi, I want to tidy up some folders and would like to move several agents that are currently active (in use)…User_2025-02-05-22-44-35-842 22 views 2 comments 1 point Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM
-
How to pull only active and suspended recruiters full name from Recruiting - Recruiting Real Time SuSummary How to pull only active and suspended recruiters full name from Recruiting - Recruiting Real Time Subject areaContent Hi Team, Please find attached analysis whic…
-
Dashboard with auto refreshSummary Need to know if there is a possibility to auto refresh dashboard to show 'live' view when it's openContent Hello, I was wondering if it is possible to auto refre…User_2025-01-28-05-11-13-165 94 views 5 comments 7 points Most recent by Max Prestes Reporting and Analytics for HCM
-
How to Fetch the Direct reports of Line Manager as of specific dateSummary How to Fetch the Direct reports of Line Manager as of specific dateContent Hi Team, PFA catalog of analysis. We have created an analysis which we use to pull the…
-
Query help needed to determine duration in job code, title, pay gradeSummary Query generates a list of the job code, title and paygrade combinations for an employee with start and end datesContent Hi All, I have seen several queries regar…User_2025-02-04-08-51-08-912 24 views 5 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Can't unarchive catalog from Prod to DevSummary Get error message Compression - inflate Error -3 OK when trying to unarchive from Prod to DevContent Hi Apologies if this has been covered before but I couldn't …
-
Too much SQL!Summary Prompt not limiting by another field - Support have advised too much SQLContent Hi I'm getting an "unexpected token" error message when trying to limit one field…
-
Regd tracking name change in OTBISummary Regd tracking name change in OTBIContent Hi , We have name change report where we track any changes to person name in past 7 days and display the person's detail… -
OTBI Analysis performance is very slow on Dashboard PageSummary OTBI Analysis performance is very slow on Dashboard PageContent Hi Team, We have created a sample analysis using Worker assignment real-time subject area and it'…Mahendra 198 views 8 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI:"Workforce Management - Worker Assignment Real Time"-->Worker"."Previous Last Name"Summary OTBI:"Workforce Management - Worker Assignment Real Time"-->Worker"."Previous Last Name"Content Hi All, When we will see data in the Worker"."Previous Last Name"…User_MC37Q 28 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Exported analysis output is not formatting correctly in ExcelSummary Exported analysis output is not formatting correctly in ExcelContent Hi Team, PFA catalog file of analysis. We have created an analysis which we use to pull dire…
-
Pull in results from another analysisSummary combine the results from two analysis into one analysisContent Is there a way to combine the results from two analysis into one analysis? I have two separate ana…Shelly Feyerherm 37 views 12 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Salary changes after a particular dateSummary I need a report which will identify employees that have saalry changes after a given dateContent When we apply a pay award (i.e. uplift grade rates) it does not …Esther Hess 96 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
How to report on Unsubmitted Timecards?Content Has anyone been able to produce a report showing which employees haven't yet submitted a time card in a given period? Any help would be much appreciatedUser_2025-01-28-05-35-00-925 131 views 5 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Need query to get Termination or Resignation Requests pending for approvalContent Need query to get Termination or Resignation Requests pending for approvalMohamed Salah 1K views 5 comments 0 points Most recent by Mohamed Salah Reporting and Analytics for HCM
-
Assignment Changes on Employment HistoryContent Our organization is working to transition to utilizing the Quick Actions verse Person Management. One feature we use is the “view history” and then "export" on t…Kayla Malecki 300 views 12 comments 3 points Most recent by Andrew_Schmitz Reporting and Analytics for HCM
-
Audit and Performance Monitoring for OTBISummary We want to track how many people are using OTBI analyses - looking for audit information similar to that available for BI PublisherContent We have recently set u…Sian S 100 views 6 comments 6 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
Delivering OTBI report results to webcenter content serverSummary Is there any way we schedule OTBI reports to deliver results to webserver content server?Content Is there any way we schedule OTBI reports to deliver results to …Mahshid Madani 25 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM -
Inaccessible column: "Organization Hierarchy"."Level 01 Organization Name"Summary Error trying to access Org Hierarchy column with Employee roleContent Hi, We need to access "Organization Hierarchy"."Level 01 Organization Name" column through …Suresh Pallapothu 33 views 2 comments 0 points Most recent by Suresh Pallapothu Reporting and Analytics for HCM -
Starters as at Start DateSummary Data must be returned as at the Start DateContent Hi all I have a starters report that provides me with all the starters between two points in time however the d…Dawn Cawston - CPS 27 views 26 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM