OTBI
Discussion List
-
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: …Pratyusha Koduri 22 views 2 comments 0 points Most recent by Pratyusha Koduri Reporting and Analytics for HCM
-
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 149 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 155 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 128 views 3 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM -
Retrieving daily course completionsContent I'm creating an analysis report in OTBI. When it comes to the date criteria, what is the best way to define it so that I can get the completions for the current …
-
Month/Year prompt on 2 columns in HR Help Desk reportSummary Need prompts showing month/year combination for 2 prompts in OTBI report for Help DeskContent I am trying to create a report showing analysis of service requests…DennisOliver 48 views 6 comments 0 points Most recent by DennisOliver Reporting and Analytics for HCM -
Filter Column Data with other Columns?Summary Issue at the moment of filter column X with data of column YContent Hi everyone! I'm working on an analysis and I have the following information: 1. Column A wit…User_2025-02-11-02-54-34-044 31 views 1 comment 0 points Most recent by Amrit Reporting and Analytics for HCM
-
OTBI Procurement Subject Area shows Communication Date same for Original and Change Order PO DocumenSummary OTBI Procurement Subject Area shows Communication Date same for Original and Change Order PO DocumentContent Hi, We got to see that PO Communication date to supp…User_2025-02-10-05-51-05-868 51 views 1 comment 0 points Most recent by User753632-Oracle Purchasing
-
Controlling BIP icons options(Home,Catalog etc.) while adding BIP link on infolet ViewSummary Controlling BIP icons options(Home,Catalog etc.) while adding BIP link on infolet view.Content Hi All, I am working on one requirement of infolet there is a requ…User_2025-02-06-23-45-30-095 29 views 3 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
How to populate to date field based on from date in BI reportSummary How to populate to date field based on from date in BI reportContent Hi All, We have a custom BI report and there are two parameters "Date from" and "Date To". h…Pradvin Prabhakar 20 views 6 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM
-
Infolet for line managers visible to all employeesSummary Issue with none manager workers viewing Line manager's InfoletContent Hi, I am new to creating Infolet's and I have been able to create an Infolet for our manage…User_2025-01-30-03-54-32-528 147 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Agents for scheduling reportsSummary Can I move a live agent to a different folder?Content Hi, I want to tidy up some folders and would like to move several agents that are currently active (in use)…User_2025-02-05-22-44-35-842 22 views 2 comments 1 point Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM
-
How to pull only active and suspended recruiters full name from Recruiting - Recruiting Real Time SuSummary How to pull only active and suspended recruiters full name from Recruiting - Recruiting Real Time Subject areaContent Hi Team, Please find attached analysis whic…
-
Learning Item Completion ReportSummary Our custom OTBI report has separate rows of data for the course and offering level, we need a combined row.Content I searched the forum and I can't find anyone w… -
Dashboard with auto refreshSummary Need to know if there is a possibility to auto refresh dashboard to show 'live' view when it's openContent Hello, I was wondering if it is possible to auto refre…User_2025-01-28-05-11-13-165 94 views 5 comments 7 points Most recent by Max Prestes Reporting and Analytics for HCM
-
How to Fetch the Direct reports of Line Manager as of specific dateSummary How to Fetch the Direct reports of Line Manager as of specific dateContent Hi Team, PFA catalog of analysis. We have created an analysis which we use to pull the…
-
Query help needed to determine duration in job code, title, pay gradeSummary Query generates a list of the job code, title and paygrade combinations for an employee with start and end datesContent Hi All, I have seen several queries regar…User_2025-02-04-08-51-08-912 24 views 5 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM