SQL
Discussion List
-
Changes in Hours / Grade / Salary / Organisation / Business Units etcContent Hello, We are looking for a way to create an analytical report or maybe even a dashboard that can show when "Historically" an employee has changed one of these f…User_2025-01-28-07-12-45-467 132 views 3 comments 2 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Unable to pick latest salary details for a person using subject area "Compensation - Salary HistoryContent Hello All, I am having a trouble in pulling out the latest salary details for a person using "Compensation - Salary History Details Real Time" Subject area. I ca…User_2025-01-25-06-20-12-259 134 views 18 comments 0 points Most recent by User_2025-01-25-06-20-12-259 Reporting and Analytics for HCM
-
Reporting on Working Pattern/ Work Schedules aswell as current assignment information in a single reSummary Possiblity of generating a report Including Working patterns/Work and Assignment information within an Analysis/ReportContent Hello, We are currently struggling …Brad Hughes 104 views 4 comments 0 points Most recent by Brad Hughes Reporting and Analytics for HCM -
Comments of manager for annual performance interview information in BI publisherSummary Where can I find the comments of the manager for the annual performance interview in PI publisher (fusion tables)Content Hello, Someone know where can I find in …User_I6AXL 77 views 3 comments 0 points Most recent by User_2025-01-28-09-43-13-552 Reporting and Analytics for HCM -
Location of Performance Document Manager for BIP in Release 11Summary I would like to know the location of Performance Document Manager for BIP reportContent I have a BIP report where the user, manager's name, and the last complete…Christina Anglin 90 views 6 comments 0 points Most recent by User_2025-01-28-09-43-13-552 Reporting and Analytics for HCM -
Dialogue message when clicking on prompt in BI publisherSummary Message Dialog box when selecting a parameter as prompt in bi publisherContent Hello, Is it possible to create a message dialog box to inform the user form examp…User_I6AXL 37 views 1 comment 0 points Most recent by John Palethorpe 01 Reporting and Analytics for HCM
-
Citizenship OR Nationality In OTBISummary Which subjects areas contains Citizenship exept in subject area Workforce Person Profile Real TimeContent Hello, Someone knows where can I find the citizenship e…User_I6AXL 178 views 2 comments 1 point Most recent by User_2025-01-25-06-20-12-259 Reporting and Analytics for HCM
-
SIRET AND SIREN In BI publisherSummary I want to make a request with GID, SIRET AND SIRETContent Hello, Someone know where Can I find the information SIRET and SIREN in fusion tables please? What is t…User_I6AXL 89 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Pay Period Dates v Check DateSummary Table(s) needed to link pay period dates to check dateContent How do I link the check date from effective_date in pay_payroll_actions to pay begin and pay end da…Dena Swanson 411 views 2 comments 0 points Most recent by Dena Swanson Reporting and Analytics for HCM -
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 114 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 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 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 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