SQL
Discussion List
-
Persons without data in organization level are missing in OTBI reportSummary if one person don't have data in the 5 level of organization will not appear in the reportsContent Hello, I hava some GID that are missing in my reports. When I …User_I6AXL 37 views 2 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM -
Impact to Custom BIP reporting due to R13 upgradeSummary Impact to Custom BIP reporting due to R13 upgradeContent Hi, Wanted to check if any customer needed to change custom BIP reports related to Compensation/Performa…User_2025-01-29-21-55-25-526 63 views 1 comment 1 point Most recent by Dr Surlina Yin-Oracle Reporting and Analytics for HCM -
Extract the value 'WorkTermsAssignmentId'Summary I need the field WorkTermsAssignmentId for the HCM data loaderContent Hi, I'm trying to make mass update via the HCM data loader. One of the required field is 'W… -
Error advanced sql request using two subject areasSummary avanced sql query errorContent Hello , Attached the request I did to display competeny proficiency and target for the job profile. I have an error message . Any …User_I6AXL 44 views 4 comments 0 points Most recent by Anil Pillaresetty Reporting and Analytics for HCM
-
Slow loading of a reportSummary OTBI report loading slow as ****Content Hi, I have a quite simple report in OTBI that shows the top 10 termination reasons by jobs, i.e which jobs have the most …
-
BIP - Merging rows using an eText Template based on a conditionSummary The XML returned contains multiple rows for an employee, the requirement is to merge them all into one row using an eText TemplateContent Hi, We have a requireme…Brendon Charles-24581 36 views 1 comment 2 points Most recent by Sricharan Monigari Reporting and Analytics for HCM -
Competencies : target level and mine level in OTBISummary Competencies by target level and mine levelContent Hello, I cannot find in OTBI the mine level and target level . For example for the competency ITM_Architecture…
-
Many case statementSummary What is the correct syntax for many ifContent Hi, I would like to create a column (in OTBI report) that group the employees by their seniority (in years). So for…
-
Report capturing BPM workflow configurationSummary Can we create a report to capture workflow configuration rules for validation?Content Hi All - We have almost 100 rules configured for *VariableAllocation task.I…User_2025-01-25-04-02-13-126 101 views 4 comments 1 point Most recent by Piyush Mohapatra -OC Reporting and Analytics for HCM
-
calcul division , result wrong OTBISummary result of Division of sum (measure ) /sum(measure ) is not goodContent Hello , I want to calculate the percentage of headcount by competency So I have the number…User_I6AXL 61 views 8 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Assignment Audit ReportSummary Looking for a report that includes Updated, Corrected, and Deleted AssignmentsContent Hello, I am searching for an existing report or a way to report an audit of…User_2025-01-28-17-24-53-863 204 views 4 comments 0 points Most recent by User_2025-01-28-17-24-53-863 Reporting and Analytics for HCM
-
What does DATA_DS G_1 mean in BIP?Summary What does DATA_DS G_1 mean in BIP?Content Hello All, I am running a SQL in BIP and it is returning DATA_DS G_1 (see attached SQL and screenshot of DATA_DS G_1). …User_2025-03-07-21-07-25-805 442 views 6 comments 1 point Most recent by User_2025-07-18-02-05-33-261 Reporting and Analytics for HCM
-
Top N querySummary Filter top 5 leaving reasonContent Hi, I want to create a report that shows the top 5 reasons of leaving (e.g. 'found another job", "Low salary" etc.). I know wh…
-
Job Function NameSummary Need Function Name in BI Publisher reportContent Hello, I am building a BI Publisher report and need to pull in the Job Function Name I found the JOB_FUNCTION_CO…User_2025-01-23-21-24-21-434 697 views 3 comments 2 points Most recent by User_2025-01-23-21-24-21-434 Reporting and Analytics for HCM
-
Absence Accrual Plans for EmployeesSummary Need query table/analysisContent One of our states where our employees are located has ruled to provide hourly employees with sick pay of 40 hours per year after…Frank Wheatley 147 views 9 comments 0 points Most recent by Sricharan Monigari Reporting and Analytics for HCM
-
Table name to find the approved date and approve by columnSummary Table name to find the approved date and approve by columnContent Hi, I have a requirement to create a report with approved date and approved by column. My custo…User_2025-01-29-01-27-20-754 67 views 3 comments 1 point Most recent by Dr Surlina Yin-Oracle Reporting and Analytics for HCM
-
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 65 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.5K 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 328 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 239 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 74 views 11 comments 0 points Most recent by Gala Meyerovich Reporting and Analytics for HCM