OTBI
Discussion List
-
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 33 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 26 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 52 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 80 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 38 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 32 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 86 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 44 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 25 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 -
Payroll-Calculation Cards Real Time OTBI SA issueSummary Payroll-Calculation Cards Real Time OTBI SA issueContent HI, We have a issue with "Payroll-Calculation Cards Real Time" SA. I am picking the Calculation Card :'S… -
SQL Expression on column filter in OTBI reportContent Created a headcount report and looking for a SQL Expression for a column filter so I can generate the report based on current or system date employee start dates…User_2025-02-11-16-17-40-645 2.5K views 4 comments 1 point Most recent by MandeepGupta Reporting and Analytics for HCM
-
How to Add Sorting to Bar Graph ResultsContent When I create a bar graph using "Facts - Requisition Counts"."Number of Job Requisitions Currently Open" by "Job Requisition - Hiring Team"."Recruiter Full Name"… -
HCM Quarterly Changes Impact on Reporting and AnalyticsSummary HCM Quarterly Changes Impact on Reporting and AnalyticsContent Hi all, Is there any other references for Quarterly changes on HCM that affects reporting? I have …Raymund Jerome 23 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
Manager name from Assignment Manager (Unsecured) does not work with event countsContent When I add Manager name from Assignment Manager (Unsecured), the hire/ termination count reduces significantly. How does the Assignment Manager (Unsecured) work?…User_2025-02-10-08-27-16-805 47 views 9 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Drill down and action link opening an email to the user - OLCContent Hi there, I have a table with users' names or email addresses. Can I add an action link with a drill down that will open an email to the user? Thanks BobbyBobby Jourdan 25 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
How to sort Age BinsSummary Sorting Age Bins in a ChartContent Hello, I am trying to get my Age Bands to sort in numeric order but the Bin Labels with text keep defaulting to the end of the…Rebekah Gilday 49 views 5 comments 0 points Most recent by Caroline Gladwin-Oracle Reporting and Analytics for HCM -
Current status is "Interim"Summary Trying to report on all employees who are an interim assignmentContent I'm trying to report on all employees who are currently on an "Interim". Using the HR Acti…
-
Tracking new line managersSummary Identify line managers who have managed employees less than a yearContent Is there a way to identify line managers who have managed employees less than a year? W… -
Query to exctract Person Email addressesContent Hello experts, do you know the query to simultaneously exctract the following information? EmailAddressId|PersonNumber|EmailType|EmailAddress|DateFrom|DateTo|Pri…Valerio Curzi 26 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
New Absence within 3 days of old AbsenceSummary We require a report that would show any colleague who had an absence closed, and a new absence opened within 3 days.Content Hi, I am currently working on an abse…Mitch_123456 22 views 1 comment 0 points Most recent by Venkata Sumanam Reporting and Analytics for HCM
-
How to mask data values?Summary In OTBI, how to display an * instead of a number or percentage where the results might identify peopleContent In OTBI I would like to mask identifiable data such…Mnrussel-Oracle 74 views 3 comments 1 point Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Report Job History Page in OTBI IssueSummary Report Job History Page in OTBI Issue is BlankContent Is anyone else experiencing an issue accessing the Report Job History Page? I assume a browser issue, but h… -
OTBI Dashboard Layout for SectionsContent I have created a dashboard with two sections, one of the sections I need the two analysis to render side by side (horizontal) rather than vertical. However when …N. Adams-Oracle 104 views 3 comments 0 points Most recent by SimonTomey Reporting and Analytics for HCM
-
Need SQL query to fetch Balance Initialization/Balance AdjustmentContent Hi All, We are looking SQL query to fetch the Balance Initialization/Balance adjustment data. Please share SQL query if anyone is having in handy. Thanks, Visu
-
OTBI > Ability to Capture Name of Employee Performing Adjust Balance on Employee BalanceContent Hello All, I will appreciate your support on the following issue: Our customer wants to capture the name of the employee who performs Adjust Balance on Employee …Bernard T 17 views 6 comments 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Report on employee careers of interestContent Hi, Has anyone built a report that indicates people and their careers of interest under career development in Oracle HCM Cloud? I am specifically looking to buil…Dishti Malhotra-Oracle 29 views 2 comments 0 points Most recent by Krista Kay Reporting and Analytics for HCM