SQL
Discussion List
-
Headcount in Fusion ProfileSummary Do you know what table does Headcount belong to in Fusion>Person Management>Manage Person.Content Do you know what table does Headcount belong to in Fusion>Perso…Mark kristan De los Reyes 31 views 1 comment 0 points Most recent by Aaron Leggett Reporting and Analytics for HCM -
field that pulls number of direct reportsSummary I am working on a report that requires a field to pull 'Number of Direct Reports'. A non-manager would have 0 or null. Manager will pull active direct reports.Co…User_2025-02-06-07-21-22-662 64 views 4 comments 0 points Most recent by User_2025-01-28-20-36-10-715 Reporting and Analytics for HCM -
Has anyone seen custom reports timing out after 20A upgradeSummary BIP Reports timing outContent We have a custom BIP report built off a SQL data model. It used to run about 15 minutes. After upgrading to 20A in all our developm…TonyWo 39 views 3 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM -
Pull Question Library with SQLSummary Questionnaires:- My Workforce > performance > Setup and maintenance > Manage Questionnaires > Select “HR Checklists” in Subscriber > Select “Questionnaire Librar…User_2025-02-06-07-21-22-662 56 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
BIP Report: Converting multiple row & multiple column values into single row and multiple column valSummary BIP Report: Converting multiple row & multiple column values into single row and multiple column valueContent Dear Experts I am working on a BIP report (SQL quer…Karthik K-Oracle 308 views 1 comment 0 points Most recent by Karthik K-Oracle Reporting and Analytics for HCM -
Concatenate a case statement with fieldsSummary I want to concatenate a case statement with a field in OTBI. How would i do so?Content "Worker"."Person Type", CASE WHEN ( "Assignment Manager List Unsecured"."M…User_2025-02-06-07-21-22-662 58 views 3 comments 0 points Most recent by Susan Anderson Reporting and Analytics for HCM
-
Connect OTBI to SQL DeveloperSummary ReportingContent Is there a way to connect OTBI to SQL developer? I want to run queries and create reports through SQL developer.User_2025-02-06-07-21-22-662 199 views 3 comments 1 point Most recent by Tom Strudley Reporting and Analytics for HCM
-
Can I report on System Entry Date?Summary How can I report on the system entry date of an action? Not the creation date or last update date.Content Hi all, Has anyone found a way to report on the actual …User_2025-01-31-22-36-07-589 92 views 5 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM
-
Using Multi-threading in BI Publisher Data ModelSummary Using Multi-threading in BI Publisher Data ModelContent Hi Experts, In order to improve performance , I see that BI publisher has option in Data Model Properties…Aloka Bhattacharya 586 views 1 comment 0 points Most recent by Mihaela M Reporting and Analytics for HCM -
Using WITH in SQL versus sub-query-which is better?Summary Using WITH in SQL versus sub-query-which is better?Content Hi Experts, Can someone help me understand if using WITH in SQL query really improve performance versu…Aloka Bhattacharya 114 views 1 comment 0 points Most recent by Mihaela M Reporting and Analytics for HCM
-
Attributes of Pay ElementsSummary Taxable, Niable and Pensionable flags associated with each pay elementContent Hello, I am trying to develop a report in Oracle Fusion to obtain every payroll ele…User_2025-02-04-17-55-40-189 43 views 3 comments 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM
-
Making Changes to Standard Notification TemplatesSummary Is there a delay between a customized BIPublisher report and the workforce Notifications?Content Hello Experts! We've recently started venturing into changing so… -
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 26 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 30 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 46 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 60 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 455 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 342 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 49 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 57 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 42 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 64 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 160 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 56 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 156 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 27 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 227 views 17 comments 3 points Most recent by Safdar Hassan Reporting and Analytics for HCM