SQL
Discussion List
-
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 22 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 159 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