SQL
Discussion List
-
Need SQL to get Email Addresses for all Managers in Supervisor HierarchySummary SQL to get Email Addresses for all Managers in Supervisor HierarchyContent Hi Experts I am looking for a query which can get me a list of all supervisor's email …Mansur Khalil 547 views 3 comments 1 point Most recent by Jagdish Varadraj Reporting and Analytics for HCM -
Group's drill errorContent Hi everybody, I created this analysis : It displays all of employees by country who have completed or is going to the Developpment Interview. This one is "Americ…User_2025-02-06-00-11-44-868 8 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
IT: Looking for analytic/report versioning best practices and tipsSummary I'm looking for advice and best practices on versioning reports, analytics, and dashboards in a repository.Content Hi everyone, I'm looking for advice and best p…User_2025-01-22-18-30-18-571 96 views 6 comments 7 points Most recent by User_2025-01-22-18-30-18-571 Reporting and Analytics for HCM
-
Report Analitics: extract list of all the eligible documents for an employeeSummary extract list of all the eligible documents for an employeeContent Hi to all, I need to extract, for a given employee, the content of "Manage performance document…User_A8ZST 53 views 2 comments 0 points Most recent by User_2025-02-05-15-05-03-822 Reporting and Analytics for HCM -
BI Publisher Query - Send Bursted Email (HTML) with separate PDF AttachmentSummary Is it possible to have two outputs in a BI Publisher Report?Content Hello, We have a BI Publisher report which sends an email (HTML) output, split and delivered …RebeccaAult1799 141 views 2 comments 15 points Most recent by RebeccaAult1799 Reporting and Analytics for HCM
-
Headcount Report with data as at a specific dateContent Morning all, I currently have a headcount report that uses standard fields (job, department, business unit, etc.). The filter I use for this report is attached. …User_2025-01-28-05-39-23-766 172 views 5 comments 2 points Most recent by James Hoffmann Reporting and Analytics for HCM
-
Report on Cost Center ManagerContent I'm trying to get a list extracted from the system that just shows the Department Name, Cost Center (number), and Cost Center Manager. Through Workforce Manageme…Jon Kelly 265 views 5 comments 3 points Most recent by Meredith Bickell Reporting and Analytics for HCM -
Dynamic Column Width in BI publisher reportContent Hello, I'm creating a report where I'm sourcing a questionnaire used in a Development plan to show 15 detail columns about the worker that filled out the documen…Rob F 679 views 1 comment 0 points Most recent by Sricharan Monigari Reporting and Analytics for HCM -
OTBI Dashboard Prompt: How to "Display" one meaning to User, but Presentation Variable has another mSummary OTBI Complex Prompt is used to filter the type of data within report, but user needs simple list to pick fromContent Hello All, I have an OTBI requirement to dis…User_2025-02-04-11-20-13-378 84 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI Outer Join giving errorContent Hi I am getting an error when running the following SQl for an outer join. I need to pull all active employees and their rating. I need to show all actives so I …Mike Borghoff 53 views 7 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Participant feedback questionnaire reportContent Hi, I am not able to pull a report for participant feedback questionnaire. Can someone help? Regards, Nivya Version 19CNivya Mathire 83 views 5 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Employee Audit - Eliminated in 20ASummary Could we possibly get some help with creating the new version of the reportContent Hi all As many will know there was some Oracle communication surrounding the e…Tony Roff 72 views 4 comments 3 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Filter out multiple resultsSummary Nationality field - can I rank it?Content Hi, I have a report that I am using for Brexit. I'm now under pressure to try and make it slicker. I'm wondering if any…User_2025-02-05-15-09-04-091 42 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
One report to view them all - person reporting showing department, assignment status etcContent Hi, Is there a SQL based data model that shows everyone in HCM, their assignment status, department, name, suffix, email, location, manager details, role details… -
Error when Filtering Logical SQL Report off OTBI ReportSummary Obdc Driver Error when filtering based off OTBI ReportContent Hello, I'm currently trying to filter a logical SQL changes report based off an OTBI Analysis that …User_2025-01-31-00-25-12-234 34 views 3 comments 1 point Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM
-
Need inputs to display More than 65531 rows in excel output by using Excel templateContent HI All, As per the requirement we developed Data Model and Excel template. While running the report getting below error, Waiting Time: 0.4 seconds Data Fetch Tim…
-
Leave accruals and usage by absence typeContent In our legacy system we had a report that listed, by employee, all leaves that were accrued and all absences taken, by leave type, sorted by date. Is there a rep…Annette M 64 views 1 comment 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Relative Date Filter for AgentSummary How do you put a relative date filter on an agent for an analysis?Content When creating agents for analyses, we would like to have agents that run with prompted …User_2025-02-04-06-02-17-038 47 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Productivity ReportSummary A Report from Oracle to provide site productivityContent Can i ask if a report like this is possible? They are looking to measure productivity in the sites, so t…User_2025-02-04-17-26-38-144 47 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
BI Cross Report from External Source and HCM RecordsSummary Create a Report from external source file as XML or CSV data file in WCCContent Create a cross report with External data source file in Web Content Center and pe…Misael Gutiérrez-Oracle 44 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Active employees with no pay checkContent We have active, benefited employees that must meet a threshold of hours each pay period in order to maintain their benefits. Is there a way for me to report all …Annette M 58 views 1 comment 0 points Most recent by Adam Gates-Oracle Reporting and Analytics for HCM
-
Sql to find Learn content without a course, Offering and Selfpaced ActivitySummary Sql to find Learn content without a course, Offering and Selfpaced ActivityContent It would be a great help if you can give me the sql which can find the Content…Mansur Khalil 77 views 2 comments 1 point Most recent by Akash Kiran Jana Reporting and Analytics for HCM
-
Search Prompts for Direct Database AnalysesSummary How do you add filters to an analysis created from a direct database query?Content When putting search prompts / search parameters on an analysis based on the OT…User_2025-02-04-06-02-17-038 27 views 3 comments 1 point Most recent by User_2025-02-04-06-02-17-038 Reporting and Analytics for HCM
-
Query to find recent payroll actionSummary Query to find recent payroll actionContent For a particular employee, on the same day, they have processed payroll actions such as "Regular Normal" once and "Pro…SuryaMuralidharan 407 views 1 comment 0 points Most recent by Thiru Ch Reporting and Analytics for HCM
-
Fiscal Year ReportingSummary Reporting from 1st date of fiscal year up until today, and from tomorrow up until last date of fiscal yearContent Hi, I am still very new to OTBI and SQL. What I…User_2025-02-05-10-44-58-756 55 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Email Subject line/Body with year and monthSummary Email Subject line/Body with year and monthContent Hi All, We have a requirement in which BI report output(excel attachment) need to be send to user (one email i…nitin Sharma 57 views 4 comments 0 points Most recent by nitin Sharma Reporting and Analytics for HCM
-
Users Record History in fusion HCMSummary Users Record History in fusion HCMContent Hi Everyone, Do we have any diagnostics report where we can get user records history ,complete changes happened on user…nitin Sharma 78 views 2 comments 0 points Most recent by Sugandha Burnwal-156870 Reporting and Analytics for HCM
-
BI Publisher : Edit button on the Search windowSummary How to enable the Edit button on the Search box in BI Publisher reportsContent Hello, Has anyone Know how to enable the edit button on the search dialog in a BI …Eduardo Nava 62 views 2 comments 0 points Most recent by Eduardo Nava Reporting and Analytics for HCM
-
Trying to create a custom role for BI Consumer (Read Only)Content Dear Community, We have a question regarding the OTBI security : we usually give a read-only role to the dashboard to our line managers (role details in attachme…[Deleted User] 1.1K views 11 comments 2 points Most recent by Kalyan Amaravathi Reporting and Analytics for HCM
-
BI Publisher - Prompts that update other promptsSummary Refresh Other Parameters on Change causing parameters to blankContent Hello Experts! I have a data model where we've built 8 parameters and I'm trying to make th…