OTBI
Discussion List
-
How to compare EE and Manager DetailsSummary OTBI report neededContent We are auditing some of our HCM data. We would like to compare an employee's department against their manager's department. Most of the…Ashley Cossey 18 views 2 comments 0 points Most recent by Ashley Cossey Reporting and Analytics for HCM -
OTBI CASE Statement across Subject AreasSummary Attempting to write CASE IF statement for data across subject areas in OTBI and receive errorContent Business requirement is to write a CASE IF statement to popu…E McDonald 114 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Age BinsSummary Invalid Alias FormatContent Hi, I've copied a formula that calculates the age of an employee from the following Oracle video: https://www.youtube.com/watch?v=QpG…User_2025-02-05-22-44-35-842 25 views 5 comments 0 points Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM -
How to get the classroom for an Activity learning item?Content Hi everybody, I should report the classroom for Activities but I am not able to get it. I don't find the link between the activity id and the classroom id (this … -
OTBI - How to download Archive file via web serviceSummary OTBI - How to download archive file via web serviceContent Hi, I'm considering to automate below archive process through web service. 1. Navigate to report path …
-
Unable to Export HTML Narrative View for OLC Learning CertificateContent Hello, I followed this post to create an Oracle Learning Cloud certificate in OTBI using HTML with the attached report and Narrate View code. It is displaying pr…User_2025-01-31-00-25-12-234 38 views 4 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM
-
Period range in OTBI reportSummary Period range in OTBI reportContent I want to list asset additions and retirements over the current year and the balances at the reporting date. Where do I specif…racheltx 100 views 4 comments 0 points Most recent by Kalyani Koylada Reporting and Analytics for ERP
-
Stop an initiative after 5 times (years)Summary Is there an option to stop the initiative for the Learner after 5 years in a row?Content Hello, We have a requirement from the business to have the initiative st…
-
How to delete duplicated records in OTBI AnalysisContent Hello experts, I have just created a custom OTBI Anaysis by using Compensation - Workforce Compensation Real Time subject area only. However, the analysis return…Valerio Curzi 1.2K views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Understand SQL Query for Talent profile data modelContent Hi Everyone, I have created the data model for talent profile print action with the help of delivered data by oracle. In delivered data model oracle has used a s…Misbahul Khair 106 views 3 comments 1 point Most recent by AshishERPCloud Reporting and Analytics for HCM -
How to Export Item Images from OTBI Analysis to Excel OuputSummary How to Export Item Images from OTBI Analysis to Excel OuputContent Hi, We have Items with images in PIM, We need to export the Item attributes along with Images …
-
"Department Name" Attribute Missing from "Workforce Management - Person Real Time"Summary "Department Name" Attribute Missing from "Workforce Management - Person Real Time"Content Hi Experts, While trying to build a custom OTBI Analysis on "Workforce …AshishERPCloud 39 views 2 comments 1 point Most recent by AshishERPCloud Reporting and Analytics for HCM -
Budget is not appear in my Analytic reportSummary Budget is not appear in my Analytic reportContent Hello i upload budget by using create budget in spreadsheet from Planning and Budgeting in General Ledger i nee…Mahgoub S.Mohamed 36 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Reports (and Dashboard) SharingSummary Request for best Practice for Reports (and Dashboard) SharingContent Hello all! We have newly implemented HCM Fusion and received little guidance concerning Repo…User_2025-02-05-11-42-08-011 146 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to get UI value on SQL outputContent Hello Experts, How we can pull or put some conditions to get the result. Eg. There are few fields with drop value like Yes, No but when I am pulling the data thr…Misbahul Khair 22 views 3 comments 1 point Most recent by Karthik K-Oracle Reporting and Analytics for HCM
-
Unable to view Full-Time Equivalent value from OTBIContent Hi All, We created OTBI report based on "Workforce Management - Worker Assignment Real Time" subject area but unable to view "Full-Time Equivalent" data from OTB…
-
Future Terminations and Project CostingSummary Transactions associated with employees that have future dated terminations are excluded?Content We are having an issue with the subject area, Project Costing - A…
-
Union Analysis Needed for SecuritySummary need assistance with a union analysisContent I am in need of assistance with an analysis. I need to capture all hourly employees who do not have the 'Employee Ho…Shelly Feyerherm 15 views 6 comments 2 points Most recent by Shelly Feyerherm Reporting and Analytics for HCM -
Reporting on Questionnaire ResponsesContent Hi All, We're getting ready to deploy an onboarding questionnaire as a task in our enterprise onboarding checklist. Does anyone know which subject area can be us…Lauren Owen 217 views 15 comments 0 points Most recent by Shweta Ganguly-Oracle Reporting and Analytics for HCM
-
19B Feature - Compare Different Revisions of the Same Item Structure with OTBISummary Latest revision LOV does not contain any values.Content Hi All, We are trying to use the new 19B feature that Oracle has introduced to Compare different revision…
-
OLC: Query for deep linksSummary BIP query for deep links in OLCContent Hi everyone, Has anyone written a query in BIP that could be used to extract deep links for learning items? I am reviewing… -
Performance Rating Real Time- Is there a way to rate overall sections?Summary A client would like to report on overall competencies. There seems to be calculations for section ratings, but not that actual section rating itself. Is there a …
-
Manager Hierarchy of terminated employeesSummary Manager Hierarchy of terminated employeesContent Hello, I need to pull an OTBI Report to grab the Manager Hierarchy (Up to Level 6) for terminated employees. I h…User_2025-02-04-15-06-22-759 240 views 2 comments 0 points Most recent by User_2025-02-04-15-06-22-759 Reporting and Analytics for HCM
-
Return the Line Manager at a Point in TimeSummary Return the line manager at a PITContent Hi all I am trying to build a report that displays the line manager against the person at a specific point in time howeve…Dawn Cawston - CPS 29 views 16 comments 0 points Most recent by Dawn Cawston - CPS Reporting and Analytics for HCM -
Images on InfoletsSummary We want to find suitable images to display on our infoletsContent Hello, For some of our infolets where it isn't relevant to see a count of colleagues e.g. numbe…User_2025-01-28-05-32-59-092 75 views 5 comments 1 point Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
How to query all expensesSummary How to I set up the user of my analysis on a dashboard so that they can see all expenses? By default it seem my user can see only my own expenses and those of th… -
Emergency Contact Report not returning phone resultsSummary The phone results in the Person Contact Relationship folder is not returning any resultsContent Using the Workforce Management - Person Real Time subject area. P…User_2025-01-28-20-43-56-568 108 views 18 comments 0 points Most recent by User_2025-01-31-18-28-58-561 Reporting and Analytics for HCM