OTBI
Discussion List
-
Export Geography HierarchySummary How can I export the geography hierarchy?Content Hi, I couldn't find any option to export the full geography hierarchy as we defined in the "manage geography hie… -
Retrieve top 2 records per employeeSummary Need to figure out a way to determine the top 2 records for an employeeContent Hi All, I am read through some posts but still haven't found a solution for what I…User_2025-02-04-08-51-08-912 39 views 7 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Absence Accrual Plan attributes report neededSummary Is it possible to create a report that dumps all of the attributes related to an Accrual Plan?Content In OTBI, using the Subject Area: "Workforce Management - Ac…
-
Absence Report (back in time)Summary Is it possible to report absences as they were back in time?Content Hi, I provided a report to one of our customers yesterday that showed all absence between Jan…User_2025-02-05-22-44-35-842 38 views 6 comments 0 points Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM
-
Performance issue in absence line manager in OTBI reportsSummary Performance issue in absence line manager in OTBI reportsContent Hi Experts, I'm facing performance issue in a simple otbi report, my report has below fields Emp…Pradvin Prabhakar 27 views 5 comments 0 points Most recent by Pradvin Prabhakar Reporting and Analytics for HCM
-
Worker Category changes not reflected in Workforce Management - Worker Assignment Event Real TimeSummary Worker Category changes not reflected in Workforce Management - Worker Assignment Event Real TimeContent Hello guys, Here is our business problem: Some of our co…User_2025-02-05-11-42-08-011 25 views 2 comments 0 points Most recent by User_2025-02-05-11-42-08-011 Reporting and Analytics for HCM
-
Security Matrix - Custom AnalyticsSummary Sharing the Security Matrix Analytics which reports the mappings between rolesContent Hello All, I have seen lot of posts asking for a solution to generate the S…Sricharan Monigari 369 views 16 comments 11 points Most recent by Sricharan Monigari Reporting and Analytics for HCM -
job name changeSummary OTBI analysis to show job name historyContent Hi, I've searched the forum and sharing centre for this but can't see anything, so apologies if answered elsewhere.…User_2025-02-08-05-56-00-229 40 views 3 comments 0 points Most recent by User_2025-02-08-05-56-00-229 Reporting and Analytics for HCM
-
Workforce Trend Real Time PerformanceSummary Is there anything I can do to tune the performance of this subject area?Content Hello Experts! I'm starting to use Workforce Trends where we are trying to count …Rob F 35 views 7 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Customer Data DumpSummary Seeded Customer dump reportContent All - Is there a seeded out of the box report that can create a dump of all customer related attributes?Hari Thyagaraj 22 views 2 comments 0 points Most recent by Hari Thyagaraj Reporting and Analytics for SCM
-
In a back to back sales order when sales order line is changed/cancelled, don't cancel WO if it hasSummary In a back to back sales order when sales order line is changed/cancelled, don't cancel WO if it has started/releasedContent In a back to back sales order when sa…
-
Unable to report from subject area 'Workforce Talent Review - Talent Review Tasks Real Time'Summary No results from OTBI sa 'Workforce Talent Review - Talent Review Tasks Real Time'Content Hello, Can anyone please help? I am unable to get any data from the subj…SantoshKumarBhairi 53 views 17 comments 1 point Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Conditional formatting on Pivot table - heat mapContent I have created a report to look at the amount of annual leave taken so far in the year by different teams. I am having trouble putting the conditional formatting…User_2025-02-06-11-18-47-896 41 views 1 comment 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Location Transfers during the current yearSummary How to get the location for the first of the year and any changes throughout the yearContent Hi All, I have a requirement to pull in changes to an Employees Work…User_2025-02-04-08-51-08-912 39 views 2 comments 0 points Most recent by User_2025-02-04-08-51-08-912 Reporting and Analytics for HCM
-
Active Job Titles & Salary RangesSummary pulling in all active job titles with salary rangesContent I have created an analysis using the 'Compensation - Salary Details Real Time'. The purpose of this an…Shelly Feyerherm 73 views 9 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
How to find a report in analytics (Balance Exception Report)Summary How to find an base report in the analytics tool to see if it can be customized.Content Hi All, My users have asked if it is possible to add the Assignment Statu…User_2025-02-04-08-51-08-912 20 views 4 comments 0 points Most recent by Lucky Sharma Reporting and Analytics for HCM
-
Workstructure and Employee Incumbent Report using Subject AreaSummary Workstructure and Employee Incumbent Report using Subject AreaContent Hi Friends, I am aware it is possible to get Workstruture and Incumbent Details using a cus…AshishERPCloud 31 views 12 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM -
Duplicate LinesSummary What function or formula is best to useContent Hi, I have numerous OTBI Analysis reports that will have 2 or 3 lines per employee because certain columns will co…User_2025-02-05-22-44-35-842 51 views 4 comments 0 points Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM
-
Reporting on benefit plan elections and plan ratesSummary Reporting on benefit plan elections and plan ratesContent Does anyone have a report to share on plan / option elections along with the employee and employer cost…
-
How to limit Nationality in report?Summary Multiple nationalities for some employees - I only want the the main or primary nationalityContent Hi, I've attached the XML - can anyone modify the report so th…User_2025-02-05-22-44-35-842 26 views 9 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Mapping the instructors in the Oracle HCM Core HR and LMSContent Dear Community, We are now configuring the LMS and we found out that when we want to link an external instructor to a course, this person needs to have an employ…
-
Help with creating a formula on analysis for OLC Learning - by learning item by learnerSummary I have created a formula on Initial Due Date to return the number of days a course is In Progress - Overdue but its calculating on the Completed courses as well.…
-
Address Mapping DocumentContent Hi all - I am working on an address report and have noticed that there are different layouts based on the location. For example, the US has States but the UK doe… -
Need Logic/sql query to create below KPI's for Purchase Requisitions/OrderSummary Need Logic/sql query to create below KPI's for Purchase Requisitions/OrderContent We have been trying to create few KPI's for Purchase Requisition work area and …User_2025-02-10-05-51-05-868 55 views 1 comment 0 points Most recent by Ashok Sriniva-Oracle Self Service Procurement
-
Need Logic to create below KPI's for Purchase RequisitionsSummary Need Logic to create below KPI's for Purchase RequisitionsContent We have been trying to create few KPI's for Purchase Requisition work area and got struck on ho…User_2025-02-10-05-51-05-868 34 views 1 comment 0 points Most recent by Ashok Sriniva-Oracle Self Service Procurement
-
Payroll Overpayment ReportContent Good Day, Has anyone actually built a Payroll Overpayment Report? i have spoken to internal developers and they haven't and searching on the internet has resulte…Clifford Trett 51 views 1 comment 1 point Most recent by Jim Kirkpatrick-Oracle Reporting and Analytics for HCM -
Reporting on Approval TransactionsSummary Trying to report on pending transactions to pull the data from the notifications onto one report. Struggling to find tables to show Current and Proposed Values a…User_2025-01-23-20-43-34-115 179 views 11 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Position Change Action ReasonSummary Position Change Action ReasonContent What is the record.field that holds the action reason on the position? (See screen shot.) I cannot find it in any of the pos…User_2025-02-04-16-58-40-850 54 views 8 comments 0 points Most recent by User_2025-02-04-16-58-40-850 Reporting and Analytics for HCM