SQL
Discussion List
-
List of direct reports in dashboard promptSummary Users select "Top" manager from dashboard prompt and another prompt lists all their direct reportsContent We have select performance tiles setup and want users t…User_2025-01-23-21-24-21-434 133 views 7 comments 2 points Most recent by fbarazan-Oracle Reporting and Analytics for HCM -
National Identifier in fusion tablesSummary Finding the description of the national identifier for each employee in the tables fusionContent Hello, Someone know where can I find the descriptif column of th… -
Join attributes(compensation amoun) with Organization HierarchySummary when trying to make the joint between compensation amount and oraganization hierarchy the result of compensation amount for each person_number is wrongContent He…
-
Advanced SQL filterSummary return max value from sql filterContent Hello, I built a Table view to display some data and some of that comes from the Matrix Manager folder in the Workforce P…User_2025-01-23-21-24-21-434 132 views 2 comments 0 points Most recent by User_2025-01-23-21-24-21-434 Reporting and Analytics for HCM
-
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 105 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 78 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 152 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