OTBI
Discussion List
-
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 -
Max Scheduled Reports RowsContent I've found this post from a long time ago that discussed 25k as a max for scheduled reports. I'm still encountering this even with csv. Is this the limit on sche…User_2025-01-31-00-25-12-234 27 views 4 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM -
Latest Start DateSummary Is there a latest start date field in OTBI? Need length of service in current assignmentContent Hi, I have a report that calculates the Time in Service of employ…User_2025-02-05-22-44-35-842 44 views 20 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Report on Absence approved dateSummary Report on Absence approved date in OTBIContent Please share the steps to capture Absence approved date when reporting on other absence details in OTBI. I have se… -
Customer wants to cancel the sales order line 1.1 and 1.2 and these were already shipped in other orSummary Customer wants to cancel the sales order line 1.1 and 1.2 and these were already shipped in other order linesContent Customer wants to cancel the sales order lin… -
NRA Year to date EarningsSummary Trying to find the NRA YTD 8233 Earnings for an employeeContent Can you please suggest how to get this balance in Subject area. Please see the below Navigation: … -
Calculated cloumn is not having value with decimals (Expected value --> 383/12 = 31.9 but current vaSummary Using TIMESTAMPDIFF function getting total months between two dates(Ex: 383 Months) when dividing 383 with 12 (383/12) current value coming as 31.0(383/12 =31.0)…User_2025-01-30-17-37-30-647 35 views 5 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Custom Excel Spreadsheet ADFSummary Custom Excel Spreadsheet ADFContent Is it possible to develop custom ADF as Currently asset descriptive ADF spreadsheet is not available but we want to develop c… -
20D release - SUBMITTED PROJECT BUDGET AND FORECAST VERSIONS IN OTBI.Summary 20D release for SUBMITTED PROJECT BUDGET AND FORECAST VERSIONS IN OTBI ReportContent HI Team, There is a new feature in 20D release for SUBMITTED PROJECT BUDGET …User_2025-02-05-00-13-31-186 38 views 5 comments 1 point Most recent by Andy May-Coates-Oracle Project Management -
Latest Hire Date in OTBI without using Seniority DatesContent Hi All, We have a requirement at our project where we need to get the “Latest Hire Date” for any Person in OTBI. The challenge is Seniority dates are not exposed…User_F89L9 150 views 2 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Reviewing Comments added by self-service usersSummary Where can we read a summary of comments?Content As Admin in Oracle Learning Cloud, we receive notifications from people who have added a comment via the Action t…
-
Tuning a rolling 12 Months turnover reportSummary How to performance tune a trend based report when using Ago and Rolling PeriodContent Hello Experts! In my ongoing saga of working with the trends subject area t…Rob F 154 views 4 comments 0 points Most recent by Abhishek Dixit-Oracle Reporting and Analytics for HCM -
How can I get assignment manager list details when subject area doesn't have themSummary Subject area doesn't contain assignment manager listContent Hi I am trying to adapt a report for direct reports to a line manager only. However I've noticed some…LynneLBL 19 views 3 comments 0 points Most recent by Virginia M. Calvi Reporting and Analytics for HCM -
Absence Booked in future date with complete detailsSummary Absence Booked in future date with complete detailsContent Hi Team, We wanted to fetch all the employees who booked their absences in future-date (for example be…Mahendra 40 views 9 comments 0 points Most recent by User_2025-02-04-23-40-44-792 Reporting and Analytics for HCM -
Absence balance reportContent I am trying to create an absence balance report for each accrual plan by employee. The report would look like the attached using the "Employee Plan Participation…Annette M 132 views 3 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM