SQL
Discussion List
-
How to get readiness level in reportContent Hi Everyone. I am trying to get the data of the succession plan in a report however I got all data except Readiness level. In HRM_PLAN_CANDIDATES table, the Read…Misbahul Khair 45 views 1 comment 0 points Most recent by Nancy Lang-Oracle Reporting and Analytics for HCM -
Potential assessment report on a specific talent reviewSummary Potential assessment report on a specific talent reviewContent Hello, we have a OTBI report for potential assessment, this report is accessible through > select …Helene V 51 views 1 comment 0 points Most recent by Nancy Lang-Oracle Reporting and Analytics for HCM -
BI Publisher data model filter manager typeSummary Recently implemented second manager type which is causing multiple lines on BIP reportContent We have a daily BIP report that sends employee data based on action…Rob Stahly 25 views 4 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Leave adjustment detials for employeesSummary Leave adjustements for employees is available in any subject areas in OTBIContent HI, In the Absences sometime HC team are doing adjustment in the annual leave, …Farooq Syed, CPA, PMP, CISA 29 views 4 comments 1 point Most recent by User_2025-02-06-09-29-18-902 Reporting and Analytics for HCM -
Location informationSummary I need to run a report showing our locations, addresses etcContent Hi, Is there a subject area that holds the following information: Location Name, Office, City,…User_2025-02-05-22-44-35-842 45 views 5 comments 0 points Most recent by Susan Anderson Reporting and Analytics for HCM -
Converting Simple SQL into Direct Database SQLSummary Converting Simple SQL into Direct Database SQLContent I have a current report written in Simple SQL as I need to do some left joins on Subject Areas in OTBI. How…User_2025-01-31-17-49-32-187 59 views 3 comments 4 points Most recent by Karen Waddell Reporting and Analytics for HCM
-
Previous and current values flip in the OTBI ReportSummary Previous and current values for different action codes for an employeeContent Hi All, I have a requirement to fetch a report consisting of changes to Jobs, EEO1 …User_2025-01-30-21-52-52-008 465 views 21 comments 1 point Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM
-
Work Schedules in OTBIContent Afternoon all, Has anyone managed to report on all of the details that sit within Fusion Work Schedules from OTBI? I've built a fairly simple report, that pulls …User_2025-01-28-05-39-23-766 348 views 6 comments 3 points Most recent by Emily Robinson Reporting and Analytics for HCM
-
Dashboards which Include a Date PromptSummary Dashboards which Include a Date Prompt and No Data ReturnedContent Hi, I have created a Dashboard with a Date Prompt and a BI Publisher Report. The BI Publisher …Karen Waddell 47 views 5 comments 0 points Most recent by Karen Waddell Reporting and Analytics for HCM -
Oracle BIP Report - Does not return results with 'French' as Application Interface LanguageSummary Oracle BIP Report - Does not return results with 'French' as Application Interface LanguageContent Hello, I have a BI-Publisher report which uses database tables…SantoshKumarBhairi 56 views 1 comment 1 point Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Manager NameSummary need manager name in report, but need it like First Name Last Name. Not Last Name, First NameContent Manager Name by default pulls Last Name, First Name. We need…Mike Borghoff 41 views 3 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM
-
HCM BI report data model tables to check SQLquerySummary HCM BI report data model tables to check SQLqueryContent Hi, I wonder if there are tables that I can check SQL query for custom BI reports. We have multiple BI r…Suyoung 62 views 2 comments 0 points Most recent by Sricharan Monigari Reporting and Analytics for HCM
-
need a table name to get the "Payroll Transfer Status" field in time and laborSummary need a table name to get the "Payroll Transfer Status" field in time and laborContent Hi Team, i am looking for a table to get the "Payroll Transfer Status" fiel…User_2025-02-04-07-00-18-658 167 views 1 comment 0 points Most recent by User_2025-02-04-10-25-07-624 Reporting and Analytics for HCM
-
Report on Job Seniority Date by AssignmentSummary Report on Job Seniority Date by Assignment (v3)Content We are in the process of implementing seniority dates, specifically for job by assignment. We believe this…Sarah Tobio 55 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Payroll Table and Column that Holds Element Entry Override CostingSummary I need to locate this using SQL not the Subject Areas in OTBIContent I've written an SQL query to pull off the element entries and their values from the various …Helen Bennallack 154 views 4 comments 0 points Most recent by Helen Bennallack Reporting and Analytics for HCM
-
Find who a Requisition is sitting withSummary Want a Report that shows who a recruitment requisition is sitting withContent Hello all, In Oracle Recruitment Cloud, we have recruitment requisitions. I've been…User_2025-02-06-00-01-08-606 55 views 1 comment 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM
-
SQL to find jobs with Approval rules tiedSummary SQL to run in BI to find the jobs that are tied with approval rulesContent I would like to find the list of jobs that are tied or used in the Approval workflows.…Jagdish Varadraj 26 views 2 comments 0 points Most recent by Jagdish Varadraj Reporting and Analytics for HCM -
Monitor an approval process:Content Hello, We need to build a report to help monitor approval processes within the system. Currently it seems there is no way to monitor the approvals … Is there any…User_2025-01-22-19-54-47-882 226 views 17 comments 3 points Most recent by Safdar Hassan Reporting and Analytics for HCM
-
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 567 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 7 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 95 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 132 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 167 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 282 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 695 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 83 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 56 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 71 views 4 comments 3 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM