SQL
Discussion List
-
Tuning SQL queriesSummary Does anyone have any hints or tips they can share on techniques to tune SQL queries in BI Data Models?Content I have a BI Report which contains a single data mod…Jon Taylor 73 views 2 comments 1 point Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM -
Learning OTBI Report -> Missing 'Classroom' details upon adding 'Instructor' DetailsSummary Learning OTBI Report -> Missing 'Classroom' details upon adding 'Instructor' DetailsContent Hello, Can anyone please help? I have an OTBI report around Learning …SantoshKumarBhairi 86 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM -
HCM - Actual working hour and hourly wageContent Hello, I'd need to create a query (data model) for part-time employees in our organization for their actual working hour and hourly wage for a particular period …
-
Standard Working Hours and Standard Working Hours Frequency of Legal Employer or Legal Entity thru OSummary How to get the Standard Working Hours and Standard Working Hours Frequency of Legal Employer or Legal Entity thru OBIEEMark kristan De los Reyes 24 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Current and Proposed Values in a pending BPM workflowSummary Getting the Current and Proposed Values in a BPM workflow notification in BI reportContent We have a requirement to build a report where the HR Specialist can vi…Akash Kiran Jana 56 views 5 comments 0 points Most recent by Akash Kiran Jana Reporting and Analytics for HCM
-
Subqueries in Logical SQLSummary I've probably failed at some simple syntax..Content Attempting to build some fairly complex queries using Logical SQL Analysis in OTBI. This query: SELECT "Worke…User_2025-01-28-21-32-42-630 51 views 4 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Query help needed to determine duration in job code, title, pay gradeSummary Query generates a list of the job code, title and paygrade combinations for an employee with start and end datesContent Hi All, I have seen several queries regar…User_2025-02-04-08-51-08-912 24 views 5 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Need query to get Termination or Resignation Requests pending for approvalContent Need query to get Termination or Resignation Requests pending for approvalMohamed Salah 877 views 5 comments 0 points Most recent by Mohamed Salah Reporting and Analytics for HCM
-
Transaction comments reporting - Termination ReportContent With the release of the new UI, the per_periods_of_service table no longer contains the comments for the termination transaction, instead the comments are placed…Annette M 80 views 8 comments 0 points Most recent by Rakesh Lathiya 2018 Reporting and Analytics for HCM -
Development Goals (individual) approval StatusContent How can I get the Approval Status and time approved into Development Goals Status Report. Saw a few recommendations but some seem to be for goal plan for perform…Mike Borghoff 36 views 2 comments 0 points Most recent by Mike Borghoff Reporting and Analytics for HCM
-
Need sample query to check if employee has location as on hire dateContent Hi All, I'm in need of a sample SQL query to check if employee has location as on hire date.Please share if you have the same. Thanks, Ravichandran Version R13
-
BIP - data model joining different data sourcesSummary BIP - data model joining different data sourcesContent Is it possible to join data from two different data sources 1) from a SQL query 2) from an Oracle BI analy…
-
Help BIP Report not pulling correct infoSummary We recently went Live with OLC. One of the reports we built is a BIP report with several parameters.Content Here is the WHERE Clause with parameters. For some re…Mike Borghoff 32 views 3 comments 0 points Most recent by Mike Borghoff Reporting and Analytics for HCM
-
BI Parameter not picking up exact value from XMLContent We have a BIP report with three parameters Learning Item Name, Completion Date and Person Number. The report is working fine for more Learning Item Name's except…User_2025-01-31-00-25-12-234 18 views 4 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM
-
Set up an Agent to pull last 7 days of hiresSummary Set up an Agent to pull last 7 days of hiresContent Hello, We have an employee roster report that is widely used by our HR team for various uses. It does not hav…User_2025-01-23-21-37-42-476 47 views 3 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM
-
OTL Approved time cards details with Reported hours and Calculated Hours BI Report QuerySummary OTL Approved time cards details with Reported hours and Calculated Hours BI Report QueryContent Dear Team, We need Oracle Fusion OTL Approved time cards details …VenkatReddy Pulichintha 827 views 4 comments 0 points Most recent by VenkatReddy Pulichintha Reporting and Analytics for HCM -
Report on retro absence recordsSummary Retro absence records for payrollContent Hi all, I am trying to modify a custom report to include absences that were added to the system during the pay cycle but…User_2025-02-04-08-51-08-912 33 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Get the list of persons included in an Access for a Learning OfferingSummary Access Group Details For each Offering name and EmployeeContent Hi Every One, for an Offering in the Learning Catalog I have created an Access Group. I would lik…Ashok Naramsetty 21 views 2 comments 0 points Most recent by Ashok Naramsetty Reporting and Analytics for HCM
-
LSQL Newbie questionSummary Trying to learn to write LSQL. Need assistance with the errorContent Hello all, I just started learning to write LSQLs. After going thro the training materials, …User_2025-02-04-15-06-22-759 43 views 2 comments 1 point Most recent by User_2025-02-04-15-06-22-759 Reporting and Analytics for HCM
-
Employee Distribution Summary ReportSummary Employee Distribution Summary ReportContent This sample report gives an insight into the different types of Source System Owner along with the total employee rec…AshishERPCloud 47 views 1 comment 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Combining columns from different work area/Competency ReportSummary how can i develop a report with columns from two different work areas.Content Competency Assessment Report Sr.No Person Number Person Name Parent Department Depa…Michael Nega Gebrehawariyat 33 views 2 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
SQL Needed for DatesSummary Calculating the later of two dates using SQLContent We are creating an OTBI report to figure out when to discard of hard copies of paperwork. To calculate the sh…Rebekah Gilday 52 views 1 comment 0 points Most recent by Rebekah Gilday Reporting and Analytics for HCM -
Time Card Status and Hours for AuditSummary Audit Time Card Status and HoursContent Hi, Can you please help me on time and labor audit details. I have a scenario where, 1. Employee First Entered 24 hours f…User_2025-02-04-13-27-19-123 253 views 2 comments 0 points Most recent by Akash Kiran Jana Reporting and Analytics for HCM
-
SQL for disciplinary & PIPSummary SQL for disciplinary & PIPContent Hi, I'm building a BIP report, I need to capture details from Disciplinary & PIP under Person Extra Information I would appreci…User_2025-02-07-19-03-14-525 30 views 2 comments 0 points Most recent by User_2025-02-07-19-03-14-525 Reporting and Analytics for HCM
-
Need query to get the data loaded through HDL FileSummary Need query to get the data loaded through HDL FileContent Hi Experts, Greetings of the day!! We have loaded the Element entries to employees through HDL via diff…Charan Kollipara 1K views 1 comment 1 point Most recent by Raghavendra M Reporting and Analytics for HCM
-
Dashboard Prompt values in format YYYY-MM using TO_DATETIMESummary date formatsContent hello, Looking for some suggestion on date format conversions in dashboard prompt, here is my scenario: One of my dasboard has a month prompt…SantoshKumarBhairi 41 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Retrieve top 2 records per employeeSummary Need to figure out a way to determine the top 2 records for an employeeContent Hi All, I am read through some posts but still haven't found a solution for what I…User_2025-02-04-08-51-08-912 41 views 7 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Insert the profile image in a BI Publisher report dinamicallyContent Hi, I need to show the employee profile image in a report built using a .XLS template in BI Publisher. The field I'm using is "IMAGE" (BLOB type) from the table … -
Creating a BIP report based on a Procedure CallSummary Creating a BIP report based on a Procedure CallContent Hi Team, I need to create a BIP report based on a Procedure call. Is there any documentation available aro…MandeepKGupta 468 views 3 comments 1 point Most recent by Abhishek Nigam Reporting and Analytics for HCM
-
Location Transfers during the current yearSummary How to get the location for the first of the year and any changes throughout the yearContent Hi All, I have a requirement to pull in changes to an Employees Work…User_2025-02-04-08-51-08-912 39 views 2 comments 0 points Most recent by User_2025-02-04-08-51-08-912 Reporting and Analytics for HCM