OTBI
Discussion List
-
Hierarchical relationship between courses - BI analysis based on course completionSummary create a BI analysis with criteria based on course completionContent Hi guys, for your information is it possible through BI analysis have a criteria based on le… -
Need A Report To Find Out The PR Is Pending With Whom And Its HistoryContent We are looking for some SQL query to find out the requisition is currently pending with whom and what is the history of the approval To achieve this requirement …Koteswararao Yenikepalli 51 views 1 comment 4 points Most recent by User_2025-01-30-02-57-36-931 Reporting and Analytics for SCM -
OTBI - To Display Sum of a column based on other column in New ColumnSummary OTBI - To Display Sum of a column based on other column in New ColumnContent Hi, I want to Display Sum of a column based on other column in New Column in OTBI An…User_2025-02-03-21-08-45-135 1K views 8 comments 1 point Most recent by User_2025-02-03-21-08-45-135 Reporting and Analytics for ERP -
Subject Area for Compensation Market DataSummary Subject Area for Compensation Market DataContent Hi, Does anyone know which Subject Area is used for reporting the Compensation Market Data? I've checked the HCM…Karen Waddell 54 views 5 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Create OTBI report to fetch the 2 recent most records for a person's legal employer changeSummary Create OTBI report to fetch the 2 recent most records for a person's legal employer changeContent Hi Experts, I need to create an OTBI report that shows the curr…Aloka Bhattacharya 101 views 4 comments 1 point Most recent by Aloka Bhattacharya Reporting and Analytics for HCM -
How to Identify Physical table name for EGO_ITEM_EFF_B tableSummary How to Identify Physical table name for EGO_ITEM_EFF_B tableContent Hi all, I am using Oracle BICS Data Sync to get data from Oracle Fusion SaaS (Product Hub mod…Mohammed Kaja Nawaz L J 873 views 4 comments 0 points Most recent by Manjunath Rg-Oracle Reporting and Analytics for SCM -
Reporting on employee's contacts' phone numbersSummary User unable to report on employee's contacts' phone numbers, even though they have access to the fieldContent Hello Experts! One of our HR reps is unable to repo…User_2025-01-29-23-59-58-976 156 views 17 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Folder in Subject Area WIll Not OpenSummary The folder " Calculation Component Details" in the subject area "Calculation Cards Real Time" will not openContent The folder " Calculation Component Details" in…Thomas Drzaic 36 views 1 comment 0 points Most recent by Mansur Khalil Reporting and Analytics for HCM -
Sample report for Budget Utilization in Fusion CompensationSummary Sample report for Budget Utilization in Fusion CompensationContent Is there any sample report/dashboard available to display detailed budget utilization summary …Priyanka_Kumari 30 views 1 comment 0 points Most recent by User_2025-01-22-18-30-18-571 Reporting and Analytics for HCM -
R13.19A OTBI Direct Database Query Privilege ChangeSummary In R13.19A OTBI direct database query has been disabled by default. To prevent reports generating system errors, BI Administrator can modify BI privileges to rev…User720640-Oracle 144 views 6 comments 3 points Most recent by Amarnath Govindu Reporting and Analytics for ERP -
Flexfield BI AnalysisSummary Was not able to find the flexfield createdContent I ticked the BI Analysis in a flexfield that I created in WLF_LI_COURSE. The flexfield is working correctly. Th… -
In person HCM Cloud OTBI Workshop at Oracle Reston VAContent In the last few years we have been running a popular HCM Cloud OTBI Workshop in EMEA to help customers get the most from their investment in HCM Cloud. We plan t…Julian Challenger-Oracle 43 views 0 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Oracle Report Jam at Collaborate 2019: Here to Build Your Reporting ConfidenceSummary April 8-10 2019, San Antonio TXContent Come and meet reporting experts from across Oracle HCM product development who can build a report with you, answer your re…Julian Challenger-Oracle 28 views 0 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Email a new starters managerSummary Trying to email a new starters managerContent Hi experts, I am trying to schedule a report to email the manager of a new starter. I have created an analysis and …Ian Rumble 40 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
OTBI Calculated Measure sum is incorrectSummary Trying to sum two columns by rowDebbie Herbert 65 views 2 comments 0 points Most recent by Purnachandra Rao Reporting and Analytics for ERP -
Password protection for OTBI Agent Analysis outputsSummary Excel output sent by emailContent Hi Team, We have some OTBI Agents that run analysis and send Excel output as attachments via email to users. We have a complian…Alvaro Couto 64 views 2 comments 0 points Most recent by Alvaro Couto Reporting and Analytics for HCM -
Scheduling or Sharing a DashboardSummary Would like to schedule a dashboard and/or shareContent I have a dashboard with many tabs, would LOVE to schedule so I don't have to teach navigation, however, th…Deb Luisi 177 views 7 comments 0 points Most recent by User_2025-01-30-00-14-06-021 Reporting and Analytics for HCM -
Changes to Payroll Run Results Real Time?Summary No longer pulling in payments on terminated employeesContent Hi all, We have used the Payroll Run Results Real Time subject area to pull element-level transactio…User_2025-01-31-00-36-50-198 60 views 1 comment 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM -
Parameterised Dates in OTBISummary Need to get Tax year start and end dates relative to current dateContent I need to get the UK tax year start date (April 6th) applicable to current date, the rep…User_2025-02-04-16-50-19-277 79 views 5 comments 0 points Most recent by JanardhanaKondaveeti Reporting and Analytics for HCM -
Is it possible to insert SQL into OTBI reports to pull correct version of Enterprise Seniority Date?Summary Is there a way to pull in a small piece of custom SQL to pull the right version of Enterprise Seniority Date into our custom OTBI reports?Content We know we want…User_KNIL2 67 views 2 comments 2 points Most recent by AshishERPCloud Reporting and Analytics for HCM -
Line Mgrs Unable to View Term DataSummary Has anyone created a report or dashabord with term data and the line mgr can see this data?Content I've created a dashboard that will allow managers to view Head…User_2025-01-25-00-37-41-739 117 views 26 comments 0 points Most recent by Orange Reporting and Analytics for HCM -
Workforce Trend Real Time Subject area not WorkingSummary Incorrect numbers in data and don't know how to correctContent Hi, I am using the subject area Workforce Management - Workforce Real Time as I want to produce a …User_2025-01-29-21-02-12-466 122 views 11 comments 0 points Most recent by Orange Reporting and Analytics for HCM