SQL
Discussion List
-
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 327 views 1 comment 0 points Most recent by Karthik K-Oracle Reporting and Analytics for HCM -
Need a query to fetch all the report names and its locationSummary Need a query to fetch all the report names and its locationContent Hello All, We have a requirement like what are the reports are avilable in the system and what…Koteswararao Yenikepalli 73 views 1 comment 0 points Most recent by Siva Kumar-Oracle Reporting and Analytics for SCM -
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 55 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 205 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 91 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 634 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 112 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 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 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 485 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 381 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 -
How to override NULL valuesSummary How to override null value with values from another column in OBIEE AnalysisContent When building an analysis in OBIEE, what would be the code to enter into the …User_2025-02-06-00-08-33-553 43 views 6 comments 0 points Most recent by User_2025-02-06-00-08-33-553 Reporting and Analytics for SCM
-
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 SQL query to get the supplier contact address detailsSummary Need A SQL query to get the supplier contact address detailsContent Need A SQL query to get the supplier contact address details Here I have attached the screens…Koteswararao Yenikepalli 343 views 1 comment 0 points Most recent by Siva Kumar-Oracle Reporting and Analytics for SCM
-
How to display only most recent records in an analysisSummary How to output only the most recent records in "Inventory - Onhand Balance" analysisContent In OBIEE, Is there a way to modify the pre-built analysis "Inventory -…User_2025-02-06-00-08-33-553 55 views 1 comment 3 points Most recent by User_2025-02-06-00-08-33-553 Reporting and Analytics for SCM
-
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 176 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