SQL
Discussion List
-
Reporting on employee's contacts' phone numbersSummary User unable to report on employee's contacts' phone numbers, even though they have access to the fieldContent Hello Experts! One of our HR reps is unable to repo…User_2025-01-29-23-59-58-976 148 views 17 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Is it possible to insert SQL into OTBI reports to pull correct version of Enterprise Seniority Date?Summary Is there a way to pull in a small piece of custom SQL to pull the right version of Enterprise Seniority Date into our custom OTBI reports?Content We know we want…User_KNIL2 67 views 2 comments 2 points Most recent by AshishERPCloud Reporting and Analytics for HCM
-
Add Column to Reflect whether Measurement is Present in an Employee's GoalSummary There needs to be 1 column added to a Goal report namely "SUCCESS_MEASURE_EXISTS" which will reflect any of the following values: Complete, Incomplete, PartiaCon…Aahiri_Sarma 43 views 2 comments 0 points Most recent by Rebecca Emerson Reporting and Analytics for HCM -
Line Mgrs Unable to View Term DataSummary Has anyone created a report or dashabord with term data and the line mgr can see this data?Content I've created a dashboard that will allow managers to view Head…User_2025-01-25-00-37-41-739 107 views 26 comments 0 points Most recent by Orange Reporting and Analytics for HCM
-
Display Person Image in a ReportSummary Can I display person image in OTBI or BI Publisher Report?Content Hi, There is an option to display the person image in an OTBI report or BI Publisher report? Th… -
Table name for department history of employeeSummary Table name for department history of employeeContent Hi All, May i know the any other table name which tracks the department history of employee except per_all_a…nitin Sharma 88 views 1 comment 2 points Most recent by AshishERPCloud Reporting and Analytics for HCM
-
Note to Self: Fixing timeout errors in BIPSummary Solution to BIP timeout errors from Support Document 2307631.1Content Bit of a noddy one, but this is really just a note to myself as I occasionally encounter th… -
Analysis to find New Managers created in the last 30 DaysContent Hi All, I have a requirement to create Analysis to find the New Managers created in the last 30 days. Steps i have followed are below 1) Create Analysis to find …User_2025-01-30-00-14-06-021 67 views 8 comments 0 points Most recent by User_2025-01-30-00-14-06-021 Reporting and Analytics for HCM
-
Roundup Values in reportsContent We have created a OTBI report and a SQL based BI report. Both of them showing values with decimal numbers. We need to round up values. Is it possible ? Please sh…User_2025-01-28-21-18-43-496 42 views 2 comments 0 points Most recent by User_2025-01-28-21-18-43-496 Reporting and Analytics for HCM
-
Has anyone worked on BIP report to fetch the data of all employees who have been active in 2018 at sSummary Has anyone worked on BIP report to fetch the data of all employees who have been active in 2018 at some point with the latest legal employer infoContent Hi, Has …User_2025-01-30-21-52-52-008 99 views 2 comments 0 points Most recent by User_2025-01-30-21-52-52-008 Reporting and Analytics for HCM
-
Default Presentation Variable Prompt to AllContent Hello Customer Connect community, Is there a way to default a presentation variable to default to all? I am using the following syntax in my logical SQL: AND Cou…User_2025-01-22-19-43-38-766 100 views 5 comments 0 points Most recent by User_2025-01-22-19-43-38-766 Reporting and Analytics for HCM
-
Languages for a personContent In SQL, which table(s) would I need to look at to get the following data for a person? * Language * Speaking Level * Writing Level * Reading Level * Sign Level T… -
Find Out a Person's Grade at a Particular DateContent Hi, I've been fiddling around with SQL but getting nowhere quick due to a number of factors. I'd like to keep it to SQL as my OTBI related permissions aren't 100…
-
Outputting Dates (no timestamp) to Excel and keeping date formatSummary Outputting Dates (no timestamp) to Excel and keeping date formatContent Good afternoon. In our BIP reports, we have been removing the timestamp portion from date…Rich R 89 views 1 comment 1 point Most recent by User_2025-01-30-03-54-32-528 Reporting and Analytics for HCM -
Seeking Performance Management tables for specific data fieldsSummary Seeking Performance Management tables for specific data fieldsContent Hi. My team is building a Performance Management BIP report and is seeking to include the f…
-
Query taking more time to split,compare using regexp_substr() functionSummary Query taking more time to split,compare using regexp_substr() functionContent Hi , i have a report to get goal approvers names w.r.t. goal if pending with approv… -
Can you add a prompt to an analysis that uses a left outer join (or any join)?Content I have created an analysis that pulls in data from the "Workforce Succession Management - Talent Pools Real Time" subject area and the "Workforce Profiles - Pers…Duane Gay-Oracle 80 views 5 comments 1 point Most recent by Sandra Barr Reporting and Analytics for HCM -
"Approval Delegate to others" table nameSummary "Approval Delegate to others" table nameContent Hi All, i have an requirement to get report of all the "Approval delegate to others" in oracle fusion .i am unabl…nitin Sharma 69 views 2 comments 0 points Most recent by nitin Sharma Reporting and Analytics for HCM
-
Report for fields using in systemSummary Report for fields using in systemContent Hi Everyone , Do we have any standard report or SQL query ,which will identify all the fields in table which is linked w…nitin Sharma 41 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
URL to LSQL Analysis with ParameterSummary How to prompt on LSQL column so that assignment_id can be passed in URL?Content Hi guys, We have a Logical SQL analysis which we'd like to embed on the app scree…Pavel Kartuz 51 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Need to display current year as default value of a date parameter in BI publisher data modelSummary Need to display current year as default value of a date parameter in BI publisher data modelContent Hi, We need to display current year as default value of a dat…User_MC37Q 841 views 6 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM
-
Count the number of employees per FTESummary Report which present the number of the employees per FTEContent Hi, We tried to create an analysis that count the number of the employees per FTE (Full-Time Equi…Yaniv 122 views 6 comments 2 points Most recent by Caroline Gladwin-Oracle Reporting and Analytics for HCM
-
BIP report generating JAVA exception "java.lang.NullPointerException"Summary BIP report running into errorContent I am trying to run a BIP report but its generating an error.On running the data model for over 200 rows it generates the fol…User_2025-01-31-02-27-22-166 87 views 1 comment 0 points Most recent by Thiru Ch Reporting and Analytics for HCM
-
Absences ReportSummary get the working dates between start_date and end_dateContent we have requiremnet to generate absences report, need help on sql query, If any empployee having abs… -
Link BIP Report to InfoletSummary Can we Link BIP Report to InfoletContent Hi All, Can we Create BIpublisher Report and link to Infolet, and how we can give access to particular user these infole…
-
Table to get employee title informationContent Hi For the purpose of developing a SQL report required to know the correct table. I have referred tables and views document but could not able to find it. Can so…User_2025-01-28-21-18-43-496 35 views 3 comments 0 points Most recent by User_2025-02-01-08-03-07-149 Reporting and Analytics for HCM
-
Sql query is not workinkgContent Hi, trying to excute the following sql via BI publisher per support document: Doc ID 2187087.1 Select * from per_assignment_supervisors_f sup, per_all_people_f p…Gal Shani 69 views 8 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM -
How to create a report to pick address fields which have invalid charactersSummary How to create a report to pick address fields which have invalid charactersContent Hi I am working on a requirement to create a report which would pick invalid c…User_2025-01-30-21-52-52-008 41 views 9 comments 0 points Most recent by Sricharan Monigari Reporting and Analytics for HCM
-
Max Coverage Date for Enrollment Results in OTBISummary Looking for the max coverage date by employee and benefit plan/optionContent Hello, I want to report the details of an employee's current enrollment (as of today…Susan Anderson 51 views 2 comments 0 points Most recent by Susan Anderson Reporting and Analytics for HCM -
Performance Management tables: Need to capture evaluations, performance documents, tasks, sectionsSummary Performance Management tables: Need to capture evaluations, performance documents, tasks, sectionsContent Hi, We need information about how to capture the evalua…User_MC37Q 355 views 3 comments 0 points Most recent by Vasanthakumar Ravi Reporting and Analytics for HCM