SQL
Discussion List
-
Locate setup/configuration tables in reporting/analytics toolSummary Locate setup/configuration tables in reporting/analytics toolContent We are discussing where set up tables can be located in the Reporting tool. For example, we … -
Search a date un value of columns that containts multiple date (DD/MM/YYYY ~DD/MM/YYYY ~DD/MM/YYYY )Summary How to search for date of birth in the actual year from value which contains many datesContent Hello, I want to find persons which their date of birth is in the …User_I6AXL 29 views 3 comments 0 points Most recent by Aaron Leggett Reporting and Analytics for HCM -
Possiblity of creating a Report which has a combination of data column from two different source oneSummary Possiblity of creating a Report which has a combination of data column from two different source one SQL and other static data (say excel Spreadhseet, XML, CSV..…AshishERPCloud 67 views 3 comments 0 points Most recent by Atish Chandra Supakar Reporting and Analytics for HCM -
Grouping monthly figures to create YTDSummary Grouping monthly figures to create YTDContent Hello, I am trying to create an OTBI report within the Subject Area called 'Payroll - Payroll Run Results Real Time…User_2025-01-30-03-54-32-528 65 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Static Data ColumnsSummary Is there a way to 'repurpose' a column from an OTBI subject area with a static data value, conditionally?Content Hello Customer Connect Community! Is there a way…User_2025-01-22-19-43-38-766 41 views 3 comments 0 points Most recent by User_2025-01-30-03-53-16-644 Reporting and Analytics for HCM
-
Element Data History reportContent I am having issues getting a history report of the element data to work correctly. I am trying to pull in the data in a date range, and present the element data …User_2025-01-30-00-38-09-143 175 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Fusion Field - OTBI Subject / Folder MatrixContent Afternoon all, Is there a master matrix anywhere that lists fields in Fusion and cross-references them to their location subject area / folder / sub folder in OT…User_2025-01-28-05-39-23-766 117 views 2 comments 1 point Most recent by User_2025-01-28-05-39-23-766 Reporting and Analytics for HCM
-
Valid Job Grade reportingSummary We are trying to determine if we have muliple Valid Grades for Job CodesContent We found some Job Codes with multiple Valid Grades and I am having difficulty wri…User_2025-01-23-21-24-21-434 146 views 5 comments 2 points Most recent by Nitin.Goswami Reporting and Analytics for HCM
-
Table Name for Scheduled ProcessesSummary Am looking for the Database TABLE name for querying all scheduled/processes with their PROCESS_IDContent Hi, Am looking for the Database TABLE name for querying …User_2025-01-30-03-39-56-442 1.6K views 2 comments 1 point Most recent by Sricharan Monigari Reporting and Analytics for HCM
-
Changes only data in BI ReportsContent Please consider the following scenario: The Department of an employee is updated from 'Department A' to 'Department B' on 15th December 2017. The report is run o…Amrit 351 views 9 comments 0 points Most recent by User_2025-01-25-06-20-12-259 Reporting and Analytics for HCM -
Report on Comments from Performance FormsSummary I'd like to report on the manager and employee comments from a performance docContent Managers and employees are asked to provide a rating and comment on each co…User_2025-01-25-00-37-41-739 259 views 2 comments 1 point Most recent by User_2025-01-25-00-37-41-739 Reporting and Analytics for HCM
-
Table for getting the Scheduled HCM Extracts listSummary Need table names for getting the scheduled payroll flows listContent Hi All, I have a requirement to generate BIP report with all the scheduled payroll flows and…Sricharan Monigari 67 views 2 comments 0 points Most recent by Sricharan Monigari Reporting and Analytics for HCM -
OTBI Head count report sorting by Division(Error: No Result Found)Summary OTBI Head count report sorting by Division(Error: No Result Found)Content Hi Team, I am looking for a report in OTBI with Division , Employee count and System pe…User_2025-01-30-05-05-05-573 82 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Salary History report errors outContent I need to create a report that pulls future dated salaries loaded from Workforce Comp. I'm trying to create a simple analysis using the "Compensation - Salary Hi…Gala Meyerovich 73 views 11 comments 0 points Most recent by Gala Meyerovich Reporting and Analytics for HCM -
BI publisher report for persons who ticked yes for an interview with their HR contact .Summary Tables where I can find question and responses for interview between salaries and their managerContent Hello, I want to create a report to display alls persons w…
-
OTBI ACTIVE HEADCOUNT By CONTRACT TYPESummary Cross active headcount and contract typeContent Hello, I want to create a simple report that display active headcount by contract type and by Business Unit. BU e…User_NVBN4 50 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Share information on how the security works with bi publisher example with PER_PERSON_SECURED_LIST_VContent Hello, I want to share with you some research we have done on this subject and how the security works. first the security is done with Virtual Private Database (…User_2025-01-25-01-33-46-269 446 views 2 comments 3 points Most recent by User_2025-01-25-01-33-46-269 Reporting and Analytics for HCM
-
Seeking BIP report for Worker, Potential Life event and Processed Life EventSummary Seeking BIP report for Worker, Potential Life event and Processed Life EventContent I need a list of workers and their event information - Potential and Processe…User_2025-01-23-21-24-21-434 94 views 8 comments 0 points Most recent by User_2025-01-23-21-24-21-434 Reporting and Analytics for HCM
-
Dynamic Image according to different legal employerSummary Dynamic Image according to different legal employerContent Hi, is it possible to create a report (rtf template trough Word BI Publisher add-on) with a dynamic im…User_2025-01-28-21-18-09-074 83 views 6 comments 0 points Most recent by Vikram Agarwal-43618 Reporting and Analytics for HCM
-
Issue in SQL script to get Overall Summary section commentsContent Hi All, I have written a script to get comments entered by both Manager and Worker in the Overall Summary Section (OS) in the Performance Document. (See my scree…Achala Munasinghe 132 views 4 comments 1 point Most recent by Achala Munasinghe Reporting and Analytics for HCM -
Learning Evaluations Report in OTBISummary Cannot Report Learning Evaluations DataContent I am trying to create an OTBI report that contains data from the Learning Evaluations folder in Workforce Learning…User_2025-01-28-17-24-53-863 213 views 3 comments 0 points Most recent by User_2025-01-28-17-24-53-863 Reporting and Analytics for HCM
-
Problem when filtring on OTBI to take MAX(date) for many userSummary I want to filter for max(date) for many users , It works only for one user .Content Hello, I create a report to display person id with a item_text,but for each i…User_I6AXL 98 views 7 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Email BurstingSummary How to send BI report pdf output as attachmentContent There is a requirement to send the pdf output of a custom BI report to employees. I have added the bursting…Vivek Pathak-71652 94 views 9 comments 0 points Most recent by Mansur Khalil Reporting and Analytics for HCM -
Job Grade ReportSummary Report to connect Job Info to GradesContent I am looking for a way to pull on a single report Job Code, Job Name, Family, Function, Management Level, Job Level, …User_2025-01-23-23-44-45-599 169 views 6 comments 0 points Most recent by User_2025-01-23-23-44-45-599 Reporting and Analytics for HCM
-
Date format 'DD-Mon-YYYY' in OTBI Analysis PromptContent Can anyone please guide how to get the date format 'DD-Mon-YYYY' in the OTBI Analysis prompt. Please see the screen-shot attached, where I want to achieve it.Amrit 232 views 1 comment 3 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM