SQL
Discussion List
-
Master Detail LinkingSummary I'm attempting to create a new hire report that will show a graph of new hires by month. However i would like to link the graph to the employee detail table.Cont…User_2025-01-25-00-37-41-739 77 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to fetch the forecast based on trending for Average terminationSummary Need to fetch Average Termination count for 2015FY,2016FYTD and 2016 Forecast Based on TrendingContent Hi All, I am having problem in the creation of analysis re…Rahul Mishra-19235 58 views 4 comments 0 points Most recent by Rahul Mishra-19235 Reporting and Analytics for HCM
-
How to create analysis report to pick employees who has not set the objective in performance documenSummary Need to pick employees with no objective details in the performance documentContent Hi All, As per the requirement of one of the report, We are having Annual Rev…Rahul Mishra-19235 104 views 1 comment 0 points Most recent by User720640-Oracle Reporting and Analytics for HCM
-
Email ID for Document Manager is Performance DocumentSummary This isn't available as a field within Performance OTBI. So wanted to see if anyone has the logical SQL to get this data.Content My company has release 11. We ar…User_2025-01-22-19-31-47-129 21 views 6 comments 0 points Most recent by User_2025-01-22-19-31-47-129 Reporting and Analytics for HCM
-
How to convert data type of attributes for further manipulation in OTBISummary Executing mathematical functions on a numeric value in a character fieldContent This may have been answered before but I was not able to find it. I am trying to …User_2025-01-25-06-19-21-012 79 views 2 comments 0 points Most recent by User_2025-01-22-18-30-18-571 Reporting and Analytics for HCM
-
How to make rows to show as column in reprt OBIEE?Content Hello, Is there a way to make rows to show as column in report OBIEE? For example phone type- to display as 2 column and not 2 rows - see screenshots. Thank youUser_2025-01-22-19-54-45-915 111 views 10 comments 0 points Most recent by User_2025-01-22-19-54-45-915 Reporting and Analytics for HCM
-
Report of Users and Roles in OIM ?Summary HCM / Fusion Oracle Identity Manager (OIM) reportsContent Does anyone know of a report showing Users active in Fusion OIM and the roles assigned to those users? …User_2025-01-23-23-30-32-519 158 views 4 comments 0 points Most recent by Constantin Tudor Urseiu Reporting and Analytics for HCM
-
How can we get "Starting Date in current Job" and "Starting Date in current Grade" in BI analysisContent I have a requirement to get the details in BI analysis that what is the start date in current grade and job.May be this date can be assignment start date when em…Rahul Mishra-19235 142 views 8 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
List of Tables in HCM FusionSummary List of tables storing the dataContent HI Gurus, Do we have a precise/accurate list of tables, along with Schema Name for Oracle HCM Cloud? I guess this will be …User_2025-01-24-00-53-11-970 219 views 1 comment 0 points Most recent by Todd.Wall-Oracle Reporting and Analytics for HCM