OTBI
Discussion List
-
Details of run of the analysisSummary Report to know the details of the run of the analysisContent Hi, Is there an out of the box report that will show us how many times an analysis has been run? By …SM-Oracle 25 views 5 comments 0 points Most recent by User_2025-01-25-04-02-13-126 Reporting and Analytics for HCM -
Tracking non-financial information related to a chart of account segment for reporting with GL BalanSummary Does anyone have recommendations for storing non-financial information related to a chart of account segment and related GL Balance?Content We have some non-fina…User_2025-02-04-18-03-15-131 31 views 1 comment 0 points Most recent by ndryden Reporting and Analytics for ERP -
Is Seniority Date subject area available in 19D release?Summary Is Seniority Date subject area available in 19D release?Content Hello Team, We have a requirement to get the Seniority date using OTBI report. We found that ther…Harish Kumar Kovi 66 views 11 comments 0 points Most recent by Whitney Van Way Reporting and Analytics for HCM -
Line Manager Dashboard DocumentationSummary Line Manager Dashboard DocumentationContent Hello, Is there documentation available for details of the dashboards available in HCM like Line Manager Dashboards. …Murthy Kodavati 502 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Need to fetch records with valid primary phone in OTBI analysisSummary In OTBI, How to check if all characters in phone number field is numericContent Hi, In OTBI analysis, I have a requirement to fetch employees whose primary phone…RekhaPK 38 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Tips for improving performance of an AnalysesSummary Tips for improving performance of an AnalysesContent Hi, We have parameters - Person number and Learning Type, but the report takes forever to give the output. I…Manoj.Gupta 51 views 1 comment 4 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
BI Content MetricsSummary Is Usage Tracking Available for Cloud-Hosted Installs?Content We are looking to track and report on the usage of various BI content we have developed, including … -
Using a graph as filter to another graph in Analysis?Content In Tableau I can easily use a graph (lets say, a vertical column of income per month) to filter another graph when clicked on the first one (ie, a second one wou…User_2025-02-07-06-48-26-537 49 views 5 comments 0 points Most recent by User_2025-02-07-06-48-26-537 Reporting and Analytics for ERP -
Drill Down in OTBI for code combination balance to journal linesSummary Drill Down in OTBI for code combination balance to journal linesContent Use case: We need to build a report listing all the account code combination balances and…Sumanth Kunimakki-21932 73 views 3 comments 1 point Most recent by Arun Raj Reporting and Analytics for ERP -
HCM DeeplinkSummary Deeplink to view absence recordContent Has anyone created a deep link in a report to view an absence record?User_2025-02-05-23-02-10-916 66 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Looking for the ESS JO History Report Or Avilable ESS Job tablesSummary Looking for the ESS JO History Report Or Avilable ESS Job tablesContent Looking for the ESS JO History Report Or Avilable ESS Job tables Version 19 B -
Payroll run Costing Results informationSummary We are trying to display Costing results information after Payroll ran.Content Hi All, We are able to get the Payroll run costing results through "Payroll – Payr… -
How to report on 20A approval data comparison featureContent I am trying to report on the new data comparison feature that was released with 20A. I want to be able to capture all of the approvals that are open along with t…Brandon Roberts 52 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Turnover Reporting - Do you use Actual Termination Date or Termination Start Date (+1 day)?Summary Went live a few months back and have always used actual termination date for turnover metrics. Trying to gauge if companies are using that date and how they are …Ryan_Sullivan 48 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Difference between Workforce Management - Worker Assignment Event Real-Time and Workforce ManagementSummary Difference between Workforce Management - Worker Assignment Event Real-Time and Workforce Management - Worker Assignment Real-Time subject areas in Fusion HCMCon…Mahendra 166 views 1 comment 4 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Fiscal CalendarSummary Has anyone built a fiscal calendar in OTBI? A 5-4-4 fiscal calendar.Content Has anyone built a fiscal calendar in OTBI? A 5-4-4 fiscal calendar. Our fiscal year …Chris Campbell 38 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Calculated item for % assigned to courseSummary Learning DashboardContent I`m using a new calculated measure to work out the 'Capacity % Filled' for each of the courses but it won't calculate correctly. Any id…User_2025-02-06-11-18-47-896 39 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Subject area for last log-in by user reportSummary Is there a subject area where I can pull the last time a user logged in?Content There's been a request by a department in my organization to see what employees h…E McDonald 102 views 1 comment 1 point Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Sourcing data for BI Publisher Reports from External Data sources including Oracle DBCS/DBAASSummary Building a BI Publisher report in Oracle Fusion Cloud ERP that shall source data from Fusion cloud database and some external data.Content We need to build a BI …Senthilrajan V 186 views 12 comments 0 points Most recent by Manjunathan S-Oracle Reporting and Analytics for ERP -
Can you find what fields are used in reportsSummary With upgrade to talent, how can i find the reports that the using the old fields?Lynn B 34 views 1 comment 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM -
Error when Editing Reports: Panel Div 'idView' not found in document oracleContent I've started receiving the error below when I'm editing reports. Has anyone seen this before? Panel Div 'idView' not found in document oracle Version 20AUser_2025-01-31-00-25-12-234 34 views 1 comment 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM -
Risk Management dashboards for COVID-19 recovery, business continuity and surveysSummary Risk Management dashboards for COVID-19 recovery, business continuity and surveysContent * Download the catalog file attached to this post * Within the BI Catalo…Stephanie Golly-Oracle 152 views 3 comments 3 points Most recent by Stephanie Golly-Oracle Reporting and Analytics for ERP
-
How to use FILTER USING function in edit formula in oracle otbiContent Hi All, Can anyone explain how this function FILTER(Column name USING() works in oracle OTBI. Regards, ShreyUser_2025-02-07-13-49-29-960 97 views 2 comments 0 points Most recent by Prudence K Reporting and Analytics for HCM -
Checklist Configurable Form ReportingSummary Pulling data from configurable form in checklistContent What is the best way to pull dff's that make up the configurable form within a checklist? After the 19B r…Shelly Feyerherm 369 views 7 comments 3 points Most recent by Shelly Feyerherm Reporting and Analytics for HCM -
Extract Month name in Oracle OTBIContent Hi All, Can we extract month name from any date by using any function in oracle OTBI. Except function monthname because it gives the month number not name. I wan…User_2025-02-07-13-49-29-960 752 views 6 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM