OTBI
Discussion List
-
Data Security when creating HCM OTBI reports for non-HR usersContent We want to create a few reports that need to be available to either Finance or Office Managers which get the data from the Oracle HCM module. Some examples, but … -
How to Restrict old asset books to the AP user?Summary How to Restrict old asset books to the AP user?Content Hi All, How to Restrict old asset books to the AP user? We have 2 books in 1 Business Unit. Currently user…Devendra Thota-220620 38 views 3 comments 1 point Most recent by Vinutha-Oracle Payables, Payments & Cash Management -
New DFF Segment Not Appearing in OTBIContent Hello, I've added some new segments to the Document Record DFF. I ticked the box labelled "BI Enabled" for each segment, and both verified/deployed the DFF. Its …User_2025-02-07-03-52-39-913 457 views 16 comments 2 points Most recent by Akshay Aiyer Reporting and Analytics for HCM -
Is there a Subject Area to View all Address Attributes?Summary I am migrating international employees into our system and want to report on their addresses however, I cannot find some of the fields within the subject area to…HROps17 182 views 13 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Average Time in JobSummary Creating a graph of average time in JobContent Hi all, I am working on a couple of reports where I am looking for the Average time a person has stayed in a Job, …User_2025-02-05-05-51-12-049 17 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Link between Pending Worker and an Employee in OTBISummary Link between Pending Worker and an Employee in OTBIContent Hi All, I have a requirement where I need to build a performance tile which needs to report the count …User_MC37Q 51 views 1 comment 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Report on Evaluation responsesSummary Report on Evaluation responsesContent I have seen some old posts, but those reports are not working for me. Does anyone have a report that I can use to report on…
-
HCM – Product Office Hour: OTBI November 2020Content Submit your questions for the HCM – Product Office Hour: OTBI November 2020 session to have them answered during the live event. Post your questions by posting a…Heather Hagedorn- Cloud HCM-Oracle 51 views 10 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Subqueries in Logical SQLSummary I've probably failed at some simple syntax..Content Attempting to build some fairly complex queries using Logical SQL Analysis in OTBI. This query: SELECT "Worke…User_2025-01-28-21-32-42-630 51 views 4 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Error in Report - Date not filtering properly with other variables in Oracle ReportSummary dates not filtering correctly with other variableContent I am trying to filter dates with step increases in a custom Oracle Report; the objective is to show how …User_2025-02-06-20-46-18-602 9 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Adding Row # and Row Count to a report?Summary Looking for a way to include a row count in a reportContent We have recently moved to HCM Cloud after using Peoplesoft. Peoplesoft Query provided a row count in …User_2025-02-07-16-42-37-187 344 views 5 comments 1 point Most recent by User_2025-02-07-16-42-37-187 Reporting and Analytics for HCM
-
Action Plan reportingSummary Need to create a report showing actions due in a given period.Content Hi, I was wondering if anyone could help me out with a report I have to create around actio…Mitch_123456 31 views 4 comments 0 points Most recent by Anand DN-Oracle Reporting & Analytics for Fusion Service
-
Delivered Reports/Dashboards - Security ConcernsSummary Delivered Reports/Dashboards - Security ConcernsContent Hello, We are currently implementing and discovered today that delivered reports contain some sensitive i…User_2025-01-23-21-37-42-476 72 views 8 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Cross posting this idea in HCM Reporting and Analytics forum - ability to Audit OTBI report configuSummary Cross posting this idea - ability to Audit OTBI report configurationsContent Here is an Idea posted in Financials - General that I thought would be of interest t…Jeff Hare CPA CISA CIA 31 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to fetch LE Setup in OTBISummary How to fetch LE Setup in OTBIContent Hi Team, Can we fetch LE setup details using OTBI tool in oracle fusion HCM? The fields that need to be fetched are Code, Na…User_2025-02-06-10-22-06-460 18 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Need help on Employee Personal Contribution report buildSummary Need help on Employee Personal Contribution report buildContent Hi Team, We are in the process of developing a report that report will be used to identify employ…Mahendra 26 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Where is "Available to Reserve" fact in BISummary Where can "Available to Reserve" fact be located in BIContent Could you kindly advice where in BI is "Available to Reserve" fact located in? So far none of the f…User_2025-02-06-00-08-33-553 26 views 1 comment 2 points Most recent by User_LDHCN Reporting and Analytics for SCM
-
OTBI Analysis error - ODBC driver returned errorSummary I developed an analysis and it works for one user and error for anotherContent Hi All, I created one analysis and it runs find for one user and error to other on…Peoplesoft 50 views 3 comments 1 point Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
HR Executive Dashboards not available in Fusion HCM Rel 13 patch 20D.Summary HR Executive Dashboards not available in Fusion HCM Rel 13 patch 20D. BI version is Oracle Business Intelligence Product Version 11.1.1.9 (Build 11.1.1.9.0BIFNDN…Mohd Shahnawaz Mohd Merajuddin-Oracle 54 views 12 comments 0 points Most recent by Mohd Shahnawaz Mohd Merajuddin-Oracle Reporting and Analytics for HCM
-
Workforce Management - Accrual Real Time/Worker Assignment Event Real TimeSummary Issue when combining subject areasContent Hi! Really hoping someone can help with my query. I would like to show the annual leave absences taken by month for a p…
-
Learning Hours ReportContent Hi, Has anyone created or come across a report showing the actual or attempted start and stop time of a learning class/course? Thank you!Dishti Malhotra-Oracle 47 views 1 comment 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
HCM – Product Office Hour: OTBI, 30 September 2020, 8 a.m PT - Submit QuestionsContent Submit your questions for the HCM – Product Office Hour: OTBI, September 2020 session to have them answered during the live event. Post your questions by posting…Heather Hagedorn- Cloud HCM-Oracle 40 views 8 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Where to save analysis to be able to use them in Learning AssignmentContent Hello, I created some analysis in OTBI and I should use them to assign Communities to Learners in OLC, but I am not able to find them while performing the add Le…Virginia M. Calvi 23 views 3 comments 1 point Most recent by Caroline Gladwin-Oracle Reporting and Analytics for HCM -
Trying to write a pause rule in the orchestration as "if line EFF value is BOA then line with that vSummary Trying to write a pause rule in the orchestration as "if line EFF value is BOA then line with that value should pause otherwise release"Content Trying to write a…
-
OTBI Analysis not workingSummary Report has stopped workingContent Hi, One of our most popular reports has stopped running all of the sudden - it seems like I'm the only person who can still run…User_2025-02-05-22-44-35-842 46 views 5 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM