OTBI
Discussion List
-
Deploy OTBI artifactsSummary How to deploy OTBI artifacts (REST or SOAP available?)Content Hi All, I would like to know if there is a way (apart from manual operation) to deploy OTBI artifac…User_U66J8 28 views 4 comments 0 points Most recent by Anil Kola-Oracle Reporting and Analytics for HCM -
Headcount by Age Band in Workforce Trends Real timeSummary Unable to count headcount by Age Band as compared to other attributesContent Hello Experts! I'm hoping this is an easy one! I'm trying to report Period End Headc…Rob F 88 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Scheduled Report Returning only 25k rowsSummary Scheduled Report Returning only 25k rowsContent I have an OTBI report that i am running that has output greater than 25k rows but less than 65k rows. I thought i…User_EQ8R5 88 views 4 comments 0 points Most recent by Raymund Jerome Reporting and Analytics for HCM
-
Report Job History does not display informationSummary OTBI Report Job HistoryContent OTBI Report Job History displays for a few seconds and then screen mostly vanishes in Production.User_2025-02-10-21-24-50-036 39 views 5 comments 0 points Most recent by Juan Rendon Reporting and Analytics for HCM -
How to add drill down feature on Formula ColumnSummary How to add drill down feature on Formula ColumnContent Hi Experts I created an analysis using "Workforce Management - Worker Assignment Real Time" to see the Age…Dharmendra Shukla 38 views 6 comments 0 points Most recent by Dharmendra Shukla Reporting and Analytics for HCM -
OTBI Multi-Language SupportSummary This white paper explains how OTBI supports multi-language translation, the current limitation and the planned enhancementContent OTBI supports multi-language tr…User720640-Oracle 664 views 3 comments 7 points Most recent by Tamer El-Tonsy - Tatonsy Reporting and Analytics for HCM -
Configuration Fusion HCM OTBI SecuritySummary This white paper is a guide in how to configure security for HCM OTBI.Content This white paper addresses how to: * Grant line managers and employees the ability …Rebecca Emerson 541 views 3 comments 12 points Most recent by Tamer El-Tonsy - Tatonsy Reporting and Analytics for HCM
-
Restricting BI Answers Access for Fusion Application UsersSummary This paper outlines steps that customers can take to restrict user access to BI catalog.Content This paper is published by Oracle OTBI product development. By de…User720640-Oracle 265 views 3 comments 9 points Most recent by Tamer El-Tonsy - Tatonsy Reporting and Analytics for HCM
-
How to Implement Specialized Reporting Security in OTBI for Fusion HCMSummary Creating Custom Roles for Specialized Reporting Access in Oracle Transactional Business Intelligence (OTBI)Content By default OTBI would always enforce Fusion HC…user714053-Oracle 686 views 2 comments 6 points Most recent by Tamer El-Tonsy - Tatonsy Reporting and Analytics for HCM
-
Busting OTBI Myths - NOT INContent Myth: OTBI can't give me a list of workers without goals (or absences or ...) There are a few ways to perform a "NOT IN" query. The easiest and most performant i…Julian Challenger-Oracle 106 views 1 comment 2 points Most recent by Tamer El-Tonsy - Tatonsy Reporting and Analytics for HCM -
Use of Variable prompt in OTBIContent Hi Experts, Greetings of the day!! Can someone please let me know the use of variable prompts in OTBI analysis. Regards, Divya Version 21ADivya Kollipara 47 views 2 comments 0 points Most recent by Divya Kollipara Reporting and Analytics for HCM
-
Compare two fields from two different subject areasSummary I am trying to put a filter where I compare the Requisition country to an Employee's nationality but they are from two different subject areas and the output is …User_2025-02-05-06-55-02-399 167 views 14 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Time card entry report in OTBISummary Time card entries not visible in "Workforce Management - Reported Time Cards Real Time" SAContent Time card entries are not visible in "Workforce Management - Re…Mohit Gupta-45440 330 views 26 comments 1 point Most recent by User_2025-02-11-15-16-39-434 Reporting and Analytics for HCM -
Filter Logical SQL based on dashboard prompt with multiple valuesContent Hi Thurrock are developing a customised version of the Line Manager Dashboard to suit their needs. An important aspect is having the ability to drill-down throug…User_2025-02-06-09-29-18-902 173 views 13 comments 0 points Most recent by Raymund Jerome Reporting and Analytics for HCM
-
Duration in current job or position in oracle fusion HCMSummary Is there a way of knowing the duration of job/position or the start/end date of job/positionContent I need a way to track employee's duration in their current jo…
-
Absence related OTBI analysis returning no resultsContent Hello, I have a couple of absence related analyses which are no longer returning any results. They worked fine last month. We just had our quarterly update this …Susan Anderson 45 views 10 comments 0 points Most recent by Susan Anderson Reporting and Analytics for HCM -
Which table stores active/inactive user details flag?Summary Which table stores active/inactive user details flag?Content Hello, I developed the below SQL to get all the users details with role details. But this query retu…
-
Goal Plan Status ReportContent Hi, I am looking for a report that will tell me the goal plan status and if anything requires approval. Has anyone created something like this? I tried using the…tiffnyc 65 views 13 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Which table/view stores information of Data models / BI Reports / OTBI reports created or updatedSummary I need the table that stores the information of Data models / BI Reports / OTBI reports created or updatedContent I need the table that stores the information of…
-
Talent Review| Succession Plan| Career Development - All in One ReportSummary This report will give employees' Performance, Talent Review, Succession and Career detailsContent If your customer wants a detailed report on Talent management w…Mani Iyer-81826 114 views 6 comments 0 points Most recent by User_2025-02-08-07-12-44-872 Reporting and Analytics for HCM -
Round a summed total?Summary Round a summed total?Content I have an OTBI analysis and on a column it does the aggregate sum - so summing each value based on how I have it grouped in the resu…Cathy 24 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
OTBI - Date prompt from and to dateContent Hi Team, I am using a date prompt between from and to date. Issue is that during negative testing - user is trying to check if the system gives error for From da…Shikha Agarwal 34 views 4 comments 2 points Most recent by Shikha Agarwal Reporting and Analytics for HCM -
Termination analysis does not bring all records when dynamic dates are usedSummary When a hard coded dates are used in the analysis or date is entered through the prompt selection, it works fine. However when the range is determined dynamically…User_2025-02-10-17-54-52-878 48 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI | Learn Module | Need an analysis to get specialization name, it's corresponding module name ,Content I am working on an OTBI report where I need to fetch specialization name, it's corresponding module name , course name, offering name, offering status, learner. …Arti P 23 views 1 comment 0 points Most recent by Nitika Arora-Oracle Reporting and Analytics for HCM -
Is there a way to put a pause/hold on all the BI reports schedule in HCM and resume them after few dSummary We need to pause the schedules in PROD for few days and we don't know how many user schedule the BI/OTBI report jobs. We need to pause all the jobs at one go and…User_F89L9 78 views 7 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Analysis of platform usabilityContent Hello experts Does anyone have any query analysis or report that enables us to see system data like. Users who are accessing most the POD (LOGINS) Which Modules …Pedro Teixeira 22 views 3 comments 1 point Most recent by Caroline Gladwin-Oracle Reporting and Analytics for HCM -
Pull data between 2 dates using Subject AreasSummary Pull data between 2 datesContent Good Evening, Has any one had luck with pulling historical information in between 2 dates? For example, we had someone who was o…User_2025-01-23-21-37-42-476 38 views 1 comment 0 points Most recent by Nivya Mathire Reporting and Analytics for HCM
-
Job DurationSummary Provides the duration of the workers in a specific jobContent This analysis provides the duration(in days) of the workers in all the jobs that they have held so …Raghavendra Raghunath-Oracle 200 views 15 comments 6 points Most recent by Raymund Jerome Reporting and Analytics for HCM -
Learning Assignment Event TypeContent Hello Experts. I need to do an Analysis that gives me if the course assignment is Required or Voluntary. I was Unable to map it into the Workforce Learning - Lea…Pedro Teixeira 56 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
OTBI for enrollment in OLC - Selection of one Department in One locattion and All Departments in AnoContent Hi there, I am using OTBI report for enrollment in OLC. I need to create a report that includes - All the Departments in Location A and - One Department in Locat…Bobby Jourdan 27 views 5 comments 0 points Most recent by Andrew_Schmitz Reporting and Analytics for HCM