SQL
Discussion List
-
How to pull APR document through SQL?Summary How to pull APR document through SQL?Content We have a business requirement to pull Annual Performance Document of all employee. Oracle says there is an ER with …User_2025-01-27-23-54-00-342 36 views 3 comments 0 points Most recent by Rebecca Emerson Reporting and Analytics for HCM -
Bursting BIP QueryContent Hi All, We build BIP report with Bursting as per our requirement. The query which we build on the Performance Management module. If we run the report with Perfor… -
Filtering Between Two "TimeStampDiff" DatesContent Good Day, I was wondering if anyone has had a similar query and has also found a solution. The query is i want to search between Two Dates and for then for it to…User_2025-01-28-07-12-45-467 89 views 5 comments 0 points Most recent by User_2025-01-28-18-08-05-947 Reporting and Analytics for HCM
-
Report doubling my values.Summary I have a report which should count every employee as 1, but for some reason counts them as 2.Content Hi, I have a traffic light report which counts employees who…User_2025-01-25-04-51-10-553 30 views 3 comments 0 points Most recent by User_2025-01-25-04-48-26-816 Reporting and Analytics for HCM
-
Remove expired dates from an end date report.Summary End dates of before the current date are appearing on my report.Content Hi, I have produced a report on end dates, such as fixed term and probation end dates. Th…User_2025-01-25-04-51-10-553 43 views 4 comments 0 points Most recent by User_2025-01-25-04-51-10-553 Reporting and Analytics for HCM
-
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 91 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 218 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 88 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 548 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 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 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