OTBI
Discussion List
-
Filter Logical SQL based on dashboard prompt with multiple valuesContent Hi Thurrock are developing a customised version of the Line Manager Dashboard to suit their needs. An important aspect is having the ability to drill-down throug…User_2025-02-06-09-29-18-902 172 views 13 comments 0 points Most recent by Raymund Jerome Reporting and Analytics for HCM -
Duration in current job or position in oracle fusion HCMSummary Is there a way of knowing the duration of job/position or the start/end date of job/positionContent I need a way to track employee's duration in their current jo… -
Absence related OTBI analysis returning no resultsContent Hello, I have a couple of absence related analyses which are no longer returning any results. They worked fine last month. We just had our quarterly update this …Susan Anderson 41 views 10 comments 0 points Most recent by Susan Anderson Reporting and Analytics for HCM -
Which table stores active/inactive user details flag?Summary Which table stores active/inactive user details flag?Content Hello, I developed the below SQL to get all the users details with role details. But this query retu…
-
Goal Plan Status ReportContent Hi, I am looking for a report that will tell me the goal plan status and if anything requires approval. Has anyone created something like this? I tried using the…tiffnyc 65 views 13 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Which table/view stores information of Data models / BI Reports / OTBI reports created or updatedSummary I need the table that stores the information of Data models / BI Reports / OTBI reports created or updatedContent I need the table that stores the information of…
-
Talent Review| Succession Plan| Career Development - All in One ReportSummary This report will give employees' Performance, Talent Review, Succession and Career detailsContent If your customer wants a detailed report on Talent management w…Mani Iyer-81826 114 views 6 comments 0 points Most recent by User_2025-02-08-07-12-44-872 Reporting and Analytics for HCM -
Round a summed total?Summary Round a summed total?Content I have an OTBI analysis and on a column it does the aggregate sum - so summing each value based on how I have it grouped in the resu…Cathy 23 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
OTBI - Date prompt from and to dateContent Hi Team, I am using a date prompt between from and to date. Issue is that during negative testing - user is trying to check if the system gives error for From da…Shikha Agarwal 34 views 4 comments 2 points Most recent by Shikha Agarwal Reporting and Analytics for HCM -
Termination analysis does not bring all records when dynamic dates are usedSummary When a hard coded dates are used in the analysis or date is entered through the prompt selection, it works fine. However when the range is determined dynamically…User_2025-02-10-17-54-52-878 47 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI | Learn Module | Need an analysis to get specialization name, it's corresponding module name ,Content I am working on an OTBI report where I need to fetch specialization name, it's corresponding module name , course name, offering name, offering status, learner. …Arti P 20 views 1 comment 0 points Most recent by Nitika Arora-Oracle Reporting and Analytics for HCM -
Is there a way to put a pause/hold on all the BI reports schedule in HCM and resume them after few dSummary We need to pause the schedules in PROD for few days and we don't know how many user schedule the BI/OTBI report jobs. We need to pause all the jobs at one go and…User_F89L9 78 views 7 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Analysis of platform usabilityContent Hello experts Does anyone have any query analysis or report that enables us to see system data like. Users who are accessing most the POD (LOGINS) Which Modules …Pedro Teixeira 21 views 3 comments 1 point Most recent by Caroline Gladwin-Oracle Reporting and Analytics for HCM -
Pull data between 2 dates using Subject AreasSummary Pull data between 2 datesContent Good Evening, Has any one had luck with pulling historical information in between 2 dates? For example, we had someone who was o…User_2025-01-23-21-37-42-476 39 views 1 comment 0 points Most recent by Nivya Mathire Reporting and Analytics for HCM
-
Job DurationSummary Provides the duration of the workers in a specific jobContent This analysis provides the duration(in days) of the workers in all the jobs that they have held so …Raghavendra Raghunath-Oracle 206 views 15 comments 6 points Most recent by Raymund Jerome Reporting and Analytics for HCM -
Learning Assignment Event TypeContent Hello Experts. I need to do an Analysis that gives me if the course assignment is Required or Voluntary. I was Unable to map it into the Workforce Learning - Lea…Pedro Teixeira 58 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
OTBI for enrollment in OLC - Selection of one Department in One locattion and All Departments in AnoContent Hi there, I am using OTBI report for enrollment in OLC. I need to create a report that includes - All the Departments in Location A and - One Department in Locat…Bobby Jourdan 27 views 5 comments 0 points Most recent by Andrew_Schmitz Reporting and Analytics for HCM -
OTBI - Reporting Monthly Net Pay ValueContent Hi all, Does anyone know the correct subject area and field to use in order to report on the net pay value an employee would receive? I've been looking at the fo…
-
Reporting on Termination and Performance Review Data in the same analysisSummary I am trying to pull a report that shows employees performance review rating before their termination as well as their termination reason.Content I am attempting …
-
Is it possible to created Facts/Measure in Logical SQLSummary Is it possible to created Facts/Measure in Logical SQLContent Hi all, I need to pivot and show percentage of a column but seems like it is not possible to create…Raymund Jerome 32 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Oracle BIP DataModel -> Default views 'Table View' and '200' rows - PossibleSummary BIP Default ViewsContent Hello, Just wondering if there are any default settings available to achieve 'Table View' and '200' rows. Attached a picture. I don't an…SantoshKumarBhairi 77 views 10 comments 4 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Report: Avg. Time in Job/Job Family/Grade/Position throughout the years - using current and past yeaContent Hi all, I'm looking to create multiple analyses that will show me the average time that employees have remained in a job/job family/grade and position throughout…User_2025-02-05-05-51-12-049 28 views 5 comments 0 points Most recent by User381997 Reporting and Analytics for HCM
-
OTBI report link creation for End usersContent Hi Team, We have created an OTBI report and given its link in the folder for the end user to click so that it will take them directly to the report. The problem …Shikha Agarwal 53 views 8 comments 2 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
OTBI - Workforce Performance - Performance Rating Real Time > Average Calculated Manager Section RatSummary We have a requirement to report on both the submitted Perfomance Rating as well as the Calculated Perfomance RatingContent We have a simple Report that shows the…Linsay Mair 78 views 2 comments 0 points Most recent by Gary Miller-39965 Reporting and Analytics for HCM -
Performance document analyses with CommentsContent Hello Experts I need to do an Analyses with Performance Rating and Comment given. In Analyses Performance Rating real time, any of the Comments Field there retur…Pedro Teixeira 35 views 2 comments 0 points Most recent by Pedro Teixeira Reporting and Analytics for HCM
-
When bursting a BI report gives error NearSummary I am trying to bursting a BI report with data source as Oracle BI EE by converting OTBI to BI query it is giving error [nQSError: 27002] NearNeha Nahar 31 views 2 comments 0 points Most recent by Srinivas Pendyala-Oracle Reporting and Analytics for HCM
-
Deliver OTBI report to SFTPContent I could see there is limitation in sending OTBI report output to SFTP folder. Is there any workaround that is being followed or is it just via BIP report?Sowdha Murugan 88 views 3 comments 2 points Most recent by Srinivas Pendyala-Oracle Reporting and Analytics for HCM
-
BIP Data Sources accessSummary BIP Data Sources accessContent Hi Experts, Does anybody know if it is possible to restrict access to the Data Sources in the BIP data model UI? I appreciate any …Volodymyr Faranosov 43 views 7 comments 1 point Most recent by Srinivas Pendyala-Oracle Reporting and Analytics for HCM -
Employees with Leave Status within a Specific MonthSummary Employees with Leave Status within a Specific MonthContent We are tracking leaves through Manage Employment using Action and Assignment Status. Our HRBPs would l…Kathleen Nguyen 23 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Edit Grand total in pivot tableContent Hi there, we made a Pivot table in OTBI analysis with pay elements in column. We have been able to add the Grand Total of them but we would like to exclude an el…Chiara Arcidiacono 25 views 7 comments 1 point Most recent by SimonTomey Reporting and Analytics for HCM