OTBI
Discussion List
-
Unable to map missing columnSummary: Our team is redesigning an OTBI report and is facing an issue with mapping the column from the old subject area "Workforce Learning - Learning Management Real T…Suda.V.Ra 15 views 1 comment 0 points Most recent by Abdul Rauf Mohammad-Oracle Reporting and Analytics for HCM -
OTBI and BIP Report Scheduling - Ideal Time WindowHi all, Just a quick question I'm hoping someone can answer. Is there a preferred time for scheduling OTBI and BIP reports during the day? Any times to avoid / best time…
-
Combining multiple max formula criteria in OTBI resulting in no values returningSummary: I'm having trouble pulling in someone's latest record or assignment in a report without it creating multiple line items for their various Job Names. When using …
-
24B Feature Talent Management REPORTING ON PROFILE ATTACHMENTSSummary: When perform the Analysis, report unable to show the link on Profile Attachment attached. Are we supposed to have link to view it? What is the different between…Eyan Shahrin 4 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
subject area to get "in error time card details" in otlSummary: we are creating a report to get in error tome card details. Currently we are using "Workforce management - Reported Time Cards Real Time" subject area, here all…Gali Sujana 19 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Actual Revenue VS. Budgeted RevenueSummary: I want to make a dashboard of Actual Revenue VS. Budgeted Revenue. Which subject area could be used for this query? Comparison is required between 2024 Budget, …Khalood 15 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
OTBI HelpSummary: Need help to get last day of the current month in OTBI. Content (please ensure you mask any confidential information): Version (include the version you are usin…Reddykrishna Chidella-Oracle 17 views 2 comments 0 points Most recent by Reddykrishna Chidella-Oracle Reporting and Analytics for HCM -
Customize/remove action button in infolets for fusion HCMSummary Customize/remove action button in infolets for fusion HCMContent We have a requirement where action button of infolets needs to be hidden for users. Please share…
-
Logical SQL: How to Calculate Response PercentageHi Community, I have BU, ResponseCount and BUTotalCount columns in my Logical SQL based report. Response Count: It is number of responses from employees on a questionnai…Ashok Kumar Sharma 16 views 6 comments 0 points Most recent by Ashok Kumar Sharma Reporting and Analytics for HCM
-
Embed a Link on the Dashboard to take to Submit a Flow page in HCMSummary: Like Deep Links/Action Links, can we have a LINK on the OTBI analysis/dashboard to let the User submit an HCM extract via the Submit a flow page. Content (pleas…Vibha Pandey - Oracle 18 views 2 comments 0 points Most recent by Vibha Pandey - Oracle Reporting and Analytics for HCM
-
Allow Access to Only My FolderSummary: Allow Access to Only My Folder Content (please ensure you mask any confidential information): Hello experts, we wanto to allow only users with specific role to …Oriana L. 22 views 2 comments 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM -
Reporting on future dated positions using OTBI 'Position Real Time' subject AreaSummary: Is it possible to report on future dated positions using the 'Position Real Time' subject Area in OTBI? Content (required): I current report on all active posit…Paul Morrissey 59 views 4 comments 1 point Most recent by Paul Morrissey Reporting and Analytics for HCM
-
Formula for "Begins with"Summary: How to write a Formula that says If Department Begins with 3 THEN "Division1" I know how to write the standard formula using CASE(IF) but not sure what function…THawkins_LGI 15 views 4 comments 0 points Most recent by THawkins_LGI Reporting and Analytics for HCM -
Restrict Diversity fields from Person Real Time Subject AreaSummary: Subject Area - Workforce Management - Person Real Time Folder - Person Legislative Information Fields - Gender Identity, Sexual Orientation User should have acc…Bindu Vasa 19 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Fact Definitions - Candidate Tracking Real TimeSummary: Content (required): Where can I find the definitions of facts in the Candidate Tracking Real Time Subject Area? I'm looking for the difference between 'Number o…Susan Anderson 101 views 11 comments 0 points Most recent by User_MN692 Reporting and Analytics for HCM -
Legends not appearing correctly in graph viewHi, I have to create a graph where I have to show voluntary termination and total termination in one graph(region wise). I have created the graph but in the legend it is…Parul007 21 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Assignment Changes L-SQL Query IssueHi all, I've been using and adapting Julian's L-SQL query posted here: https://community.oracle.com/customerconnect/discussion/32323/assignment-changes-within-date-range…MikeW 15 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Employee / Line Manager / HR Specialist seeded analyticsSummary: Customer want to know any seeded list of Employee / Line Manager / HR Specialist analytics or dashboard Content (please ensure you mask any confidential informa…Suresh Manoj Kumar-Oracle 26 views 5 comments 0 points Most recent by Suresh Manoj Kumar-Oracle Reporting and Analytics for HCM -
Show all employees whether they have been on a course or not.Summary: I am trying to gauge an approach to producing a list of employees with the courses that they have completed/in progress etc. using the subject areas for "Workfo… -
Delivered reports are available only in english?Summary: Hello, I would like to know if the delivered reports are available only in the english language. Thank you. Content (please ensure you mask any confidential inf…
-
EIT Field value is not displaying in OTBI-AnalysisContent Hello Community, We have created an Analysis in OTBI, with simple fields from the "Workforce Management - Worker Assignment Real Time" subject area, which work v…User_2025-02-05-16-57-43-236 44 views 3 comments 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM -
OTBI icon with starSummary: Regards Oriana Content (please ensure you mask any confidential information): Hello experts, does anyone know what this icon refer to? I basically have an otbi …Oriana L. 27 views 3 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Benefit & Pension Calculation Card HistoryIs there an analysis or report that shows the history of a calculation card? I have an employee who was enrolled in main LGPS scheme up to 30 September 2023 but as of 1 … -
enable password to custom OTBI Text FileSummary: Dear, Customer request to enable in custom Report password security, as following User Run the Custom Text File Report User Download the File to Open that file …Mostafa Yassin 5 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
BI Publishing: bursting without attachmentsSummary Bursting to selected people, without attachmentContent Hi all, I am trying to use BI Publishing to burst an email to colleagues who have handed in their notice. …User_2025-01-31-17-49-32-187 1.5K views 10 comments 4 points Most recent by Satyam Roy Reporting and Analytics for HCM
-
Learning Enrollment status blank in OTBISummary: Content (please ensure you mask any confidential information): Hello Experts, we are trying to create an OTBI report with the Subject area: Learning record real…
-
OTBI report for salary basis history exampleSummary: Content (please ensure you mask any confidential information): Hello experts, do you have a sample OTBI report tracking the employee salary basis history with a…Valerio Curzi 124 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Payroll Data to Transaction DetailsHello I am looking to create a report that shows pay element details linked to the transaction data. We issue Special Payment to several of our employees. When it is ent… -
Person id equals to 0 using the Person Profile Real time subject areaSummary: Person id equals to 0 using the Person Profile Real time subject area Content (please ensure you mask any confidential information): Hi experts, we are facing t…Oriana L. 27 views 5 comments 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM
-
Talent Ratings - OTBI ReportContent Hello! Can anyone tell me where the Talent Ratings are stored so that I may report on them? Please see screenshot attached. I'm looking in the "Workforce Talent …