SQL
Discussion List
-
How to convert a datetime columns from a timezone to another oneContent Hi, we are trying to extract the start and end date of a learning activity in the correct timezone. as you can see in the screenshot we have created an activity …Alberto Boccato 21 views 2 comments 0 points Most recent by Alberto Boccato Reporting and Analytics for HCM -
Identify retro changes on absence entriesSummary Identify retro changes on absence entriesContent How do we identify retro changes on absence entries? For example. employee A applies for leave from 10/1/2020 to…Sowdha Murugan 29 views 3 comments 1 point Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM -
Prompted Bar Graphs for custom fields with case statementsSummary Prompted Bar Graphs for custom fields with case statementsContent We have a bar graph with a couple of custom fields derived using case statements. The fields on…User_2025-02-10-08-27-16-805 25 views 6 comments 1 point Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Ability to enable Percentage of total on a line graphSummary Ability to enable Percentage of total on a line graphContent I am building a line graph and would like to set the data markers as a % of the total value instead …User_2025-02-10-08-27-16-805 14 views 9 comments 0 points Most recent by User_2025-02-10-08-27-16-805 Reporting and Analytics for HCM
-
How can I report on top 5 reasons for short term sicknessSummary Want to adapt the seeded report to show absence reasons for duration limitContent Hi How can I show the top 5 reasons for an absence of less than 28 days duratio…LTalbott2 21 views 7 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Report for Scheduled jobs and AgentsSummary Report for Scheduled Jobs and AgentsContent Hi All, I went through the topics but couldn't find an answer to the question about a report being created that shows…User_2025-02-04-08-51-08-912 44 views 1 comment 1 point Most recent by Andrew_Schmitz Reporting and Analytics for HCM
-
Can I rename the person level 1.00 in Assignment List when referring to this in a prompt?Summary The person level is 1.00. Can this be renamed as a reference in the prompt to Direct Reports?Content Hi Is this possible to rename the 1.00 person level to Direc…LTalbott2 16 views 4 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Audit report for Workflow ConfigurationsSummary Does anyone have a report that can show who made changes to a specific workflowContent We have an audit need that we would need to see who made changes to workfl…Andrea Hernandez-Sinclair 70 views 6 comments 3 points Most recent by AshishERPCloud Reporting and Analytics for HCM -
Report to show employees that have over contributed to CPPSummary CPP over contribuionsContent Hi all, Can someone please point me in the direction of where I could pull out the current CPP Contribution limit? I need to compare…User_2025-02-04-08-51-08-912 28 views 5 comments 0 points Most recent by User_2025-02-04-08-51-08-912 Reporting and Analytics for HCM
-
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 84 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 21 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 55 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 52 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 902 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 78 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 35 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 31 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 17 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 46 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 840 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 32 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 22 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 41 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 46 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 31 views 2 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM