OTBI
Discussion List
-
OTBI Analysis rearranging Column Order different in CVS and EXCELSummary OTBI Analysis Column Order different in CVS and EXCELContent Hello, When I create a report, the column order that shows in the 'Results' tab and also in Excel - …User_2025-02-04-15-06-22-759 339 views 5 comments 0 points Most recent by Elisa Ortiz Rincon Reporting and Analytics for HCM -
Recruiting Module - OTBI/BI ReportSummary Recruiting Module - OTBI/BI ReportContent Hi Team, I'm new to Recruiting Module I would like to fetch following attributes from either OTBI/ BI Report. Please he…Mahendra 90 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Manager Flag - all employees returning no valuesSummary Manager Flag - all employees returning no valuesContent Workforce Manager - Worker Assignment Real Time > Worker Assignment Details > Manager Flag I was expectin…
-
Recruiting - Hires Listing no pulling offer detail for allSummary Recruiting - Hires Listing no pulling offer detail for allContent Trying to use seeded report of Hires Listing to create our own version and for some candidates …Emily Robinson 53 views 2 comments 0 points Most recent by Emily Robinson Reporting and Analytics for HCM
-
Scheduled Absences FieldSummary How do I get scheduled absences for this plan year only?Content Hi I need to run an accrual report for Finance and they need the absences booked but not taken in… -
OTBI Report with Employee names in the 9 Box instead of countContent We are trying to build a OTBI report that can show employee names in the 9Box instead of counts/ performance tiles. Attaching picture for reference. Is this poss…User_2025-02-10-08-27-16-805 39 views 4 comments 0 points Most recent by User_2025-02-10-08-27-16-805 Reporting and Analytics for HCM
-
OTBI- Filter is based on results of another analysisContent I am writing a report 1 that take all of our companies invoices and shrink them down to a population of only specific invoices. Then in report 2 I want to be bas…User_2025-02-10-15-06-52-222 43 views 10 comments 1 point Most recent by Vijaybabu Reporting and Analytics for HCM
-
Function FILTER requires at least one measure column in its first argument.Summary Function FILTER requires at least one measure column in its first argument.Content I would like to use the filter function on a non numeric column but I run into…User_2025-02-10-08-27-16-805 316 views 4 comments 1 point Most recent by User_2025-02-10-08-27-16-805 Reporting and Analytics for HCM
-
Report using Contract DFFSummary How to build a report to include Contract DFFContent Hi, I have built a report joining the following subject areas Workforce Management - Employment Contract Rea…User_2025-02-08-08-11-51-624 32 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Subject area for Positions which has missing segments in Costing of PositionContent Hi Experts, I am new to OTBI analysis, I have a requirement to List all Positions which has missing segments in Costing of Position. Can anyone tell me which sub…Raghavendra M 52 views 6 comments 1 point Most recent by Raghavendra M Reporting and Analytics for HCM -
Single output row for Course and Offering dataSummary Reduce duplicate rows in Learn Reporting of Course and Offering dataContent We have legacy course completion data that was loaded via HDL. Unfortunately we did n…Dean Soto 37 views 5 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Head count by department for every month reportContent Hi, I'm looking for headcount report for each month by department. Can someone help me please. Thanks, VijayUser_2025-02-07-19-03-14-525 32 views 3 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Performance Rating With Compensation Data causing duplicate rowsContent Using Performance Rating from Compensation - Workforce Compensation Real Time subject area causes rows to duplicate for individual employee. I have tried to use …User_2025-02-10-08-27-16-805 28 views 5 comments 0 points Most recent by User_2025-02-10-08-27-16-805 Reporting and Analytics for HCM
-
OTBI - get language which user is connected withContent Hello, we need to detect the language which the user is connect with. How it is possible? (OTBI) Thanks NicolaNicola Petri 38 views 1 comment 0 points Most recent by Nicola Petri Reporting and Analytics for HCM
-
OTBI filter cross subject areas problemContent Hi Guys, I created a report with elements from 4 subject areas, It work well, but when I add some filters it give me no results even if before the filter the val…Giuseppe Iacono 54 views 8 comments 0 points Most recent by nitin Sharma Reporting and Analytics for HCM -
Display Parent Manager First Name and Last Name in 2 separate columnsContent Hello, I have an analysis I am creating that the end user has requested manager first name and last name to be in 2 separate columns. I have referenced this post…User_2025-02-07-16-42-37-187 167 views 3 comments 0 points Most recent by HROps17 Reporting and Analytics for HCM
-
Report for MFA Multi factor authenticationSummary Report to identify which employees have activated Multi factor authenticationContent Hi Do you know if there is any subject area or database table where I can se…Rogelio H 29 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Oracle Learning Planning Prices -> Any alternates to get previous history from 'wlf_plan_records_f'Summary wlf_plan_records_f - does not keep date-tracked rowsContent Hello, Can anyone please help? At the moment, the OLC table 'wlf_plan_records_f' does not keep date-t…SantoshKumarBhairi 8 views 2 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
In need of an AAP Promotion report (FROM and TO details on job)Summary In need of an AAP Promotion report (FROM and TO details on job)Content We have AAP promotion report due in which they are asking FROM and TO of a job in a promot…Adil_R 70 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OBTI Formula for January 1st of Current YearContent I need to get the age of the worker for the start of the year in an OBTI analysis. I have Oracle's formula to calculate age: TimeStampDiff(SQL_TSI_YEAR, "Worker"…Greg Bennett 98 views 8 comments 0 points Most recent by Greg Bennett Reporting and Analytics for HCM -
Expenses Employee Number to Worker - Person NumberSummary Cannot connect 2 subject areas to merge data in OTBIContent Using OTBI I am attempting to merge subject areas Workforce Management -accruals real time with Expen…User_2025-02-10-15-06-52-222 29 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Transaction Approvals and Person NumberContent Hi, I have created logical SQL to return 'Rejected' Document Records from the following subject areas: * Human Capital Management - Approval Notification Archive…Karen Waddell 58 views 14 comments 2 points Most recent by Karen Waddell Reporting and Analytics for HCM -
Duplicate rows returned for some Employees in Production OnlySummary Duplicate rows returned for some Employees in Production OnlyContent Hi, When I run the attached analysis which is developed using logical SQL it returns duplica…Karen Waddell 40 views 10 comments 0 points Most recent by Karen Waddell Reporting and Analytics for HCM
-
modify list of recipients on scheduled reportSummary modify list of recipients on scheduled reportContent We have a scheduled report to which I need to add two recipients. I have not had any luck in the schedule or… -
How to export approval rules configured for HCM transactions such as Absence, Employment etc.Summary How to export approval rules configured for HCM transactions such as Absence, Employment etc.Content Looking for a report to fetch the custom approval rules conf… -
Termination Report with Last SalaryContent I am trying to create a report that has both the reason the employee has left the company (i.e. Voluntary, Involuntary) as well as the salary the employee was re…User_2025-02-06-13-59-03-061 93 views 8 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
ORC - Candidate diversity dataSummary Pull the diversity data for any candidate who has gone through interview process, irrespective of current statusContent Is it possible to pull the candidate dive…User_2025-02-10-17-54-52-878 59 views 1 comment 0 points Most recent by Ellen Manthei Reporting and Analytics for HCM
-
Issues on Termination report with datesSummary Termination report not showing correct amountsContent Hi, I have created Termination report using "Workforce Management - Worker Assignment Event Real Time" subj…Niko Hölttä 27 views 4 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Need inputs to link between calculation cards and Payroll resultsContent Hi All, Can we have a link between Payroll results and Calculation cards tables/subject areas? If anybody is having any links share to us. Thanks, VisuVisu 29 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Pivot tableContent I have created a pivot table for recognition against the business unit. I am trying to get a percentage of the number of employees who received a recognition aga…User_2025-02-06-11-18-47-896 37 views 4 comments 0 points Most recent by User_2025-02-06-11-18-47-896 Reporting and Analytics for HCM