SQL
Discussion List
-
Filter out multiple resultsSummary Nationality field - can I rank it?Content Hi, I have a report that I am using for Brexit. I'm now under pressure to try and make it slicker. I'm wondering if any…User_2025-02-05-15-09-04-091 42 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
One report to view them all - person reporting showing department, assignment status etcContent Hi, Is there a SQL based data model that shows everyone in HCM, their assignment status, department, name, suffix, email, location, manager details, role details… -
Error when Filtering Logical SQL Report off OTBI ReportSummary Obdc Driver Error when filtering based off OTBI ReportContent Hello, I'm currently trying to filter a logical SQL changes report based off an OTBI Analysis that …User_2025-01-31-00-25-12-234 29 views 3 comments 1 point Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM
-
Need inputs to display More than 65531 rows in excel output by using Excel templateContent HI All, As per the requirement we developed Data Model and Excel template. While running the report getting below error, Waiting Time: 0.4 seconds Data Fetch Tim… -
Leave accruals and usage by absence typeContent In our legacy system we had a report that listed, by employee, all leaves that were accrued and all absences taken, by leave type, sorted by date. Is there a rep…Annette M 64 views 1 comment 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Relative Date Filter for AgentSummary How do you put a relative date filter on an agent for an analysis?Content When creating agents for analyses, we would like to have agents that run with prompted …User_2025-02-04-06-02-17-038 46 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Productivity ReportSummary A Report from Oracle to provide site productivityContent Can i ask if a report like this is possible? They are looking to measure productivity in the sites, so t…User_2025-02-04-17-26-38-144 47 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
BI Cross Report from External Source and HCM RecordsSummary Create a Report from external source file as XML or CSV data file in WCCContent Create a cross report with External data source file in Web Content Center and pe…Misael Gutiérrez-Oracle 43 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Active employees with no pay checkContent We have active, benefited employees that must meet a threshold of hours each pay period in order to maintain their benefits. Is there a way for me to report all …Annette M 56 views 1 comment 0 points Most recent by Adam Gates-Oracle Reporting and Analytics for HCM
-
Sql to find Learn content without a course, Offering and Selfpaced ActivitySummary Sql to find Learn content without a course, Offering and Selfpaced ActivityContent It would be a great help if you can give me the sql which can find the Content…Mansur Khalil 78 views 2 comments 1 point Most recent by Akash Kiran Jana Reporting and Analytics for HCM -
Search Prompts for Direct Database AnalysesSummary How do you add filters to an analysis created from a direct database query?Content When putting search prompts / search parameters on an analysis based on the OT…User_2025-02-04-06-02-17-038 27 views 3 comments 1 point Most recent by User_2025-02-04-06-02-17-038 Reporting and Analytics for HCM
-
Query to find recent payroll actionSummary Query to find recent payroll actionContent For a particular employee, on the same day, they have processed payroll actions such as "Regular Normal" once and "Pro…SuryaMuralidharan 440 views 1 comment 0 points Most recent by Thiru Ch Reporting and Analytics for HCM
-
Fiscal Year ReportingSummary Reporting from 1st date of fiscal year up until today, and from tomorrow up until last date of fiscal yearContent Hi, I am still very new to OTBI and SQL. What I…User_2025-02-05-10-44-58-756 52 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Email Subject line/Body with year and monthSummary Email Subject line/Body with year and monthContent Hi All, We have a requirement in which BI report output(excel attachment) need to be send to user (one email i…nitin Sharma 56 views 4 comments 0 points Most recent by nitin Sharma Reporting and Analytics for HCM
-
Users Record History in fusion HCMSummary Users Record History in fusion HCMContent Hi Everyone, Do we have any diagnostics report where we can get user records history ,complete changes happened on user…nitin Sharma 78 views 2 comments 0 points Most recent by Sugandha Burnwal-156870 Reporting and Analytics for HCM
-
BI Publisher : Edit button on the Search windowSummary How to enable the Edit button on the Search box in BI Publisher reportsContent Hello, Has anyone Know how to enable the edit button on the search dialog in a BI …Eduardo Nava 60 views 2 comments 0 points Most recent by Eduardo Nava Reporting and Analytics for HCM
-
Trying to create a custom role for BI Consumer (Read Only)Content Dear Community, We have a question regarding the OTBI security : we usually give a read-only role to the dashboard to our line managers (role details in attachme…[Deleted User] 1.1K views 11 comments 2 points Most recent by Kalyan Amaravathi Reporting and Analytics for HCM
-
BI Publisher - Prompts that update other promptsSummary Refresh Other Parameters on Change causing parameters to blankContent Hello Experts! I have a data model where we've built 8 parameters and I'm trying to make th… -
Pull date from prior rowSummary performance task number of days spentContent The start date in this is an excel field I manually created. Essentially, as people move thru the performance review…Mike Borghoff 36 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Benefits Status Report to monitor new hires who do not make benefit elections at all.Summary How will we be able to discern between a true waive and someone who has not touched enrollments?Content Is there away to query out employees who never went into …Vishal Gala 49 views 2 comments 0 points Most recent by User_2025-01-23-21-24-21-434 Reporting and Analytics for HCM
-
BI Publisher - CASE WHEN returns correct value on Tree View OnlySummary CASE WHEN is returning the correct value when I view the data in tree view e.g. Home or Mobile etc on BI Publisher but when viewed on table view the database val… -
GenerateHead Error when writing Employee Changes ReportContent I have an employee changes report that runs fine until I try to add two additional fields to it (Cost Center and Manager Name). Now I'm getting a GenerateHead er…Lauren Owen 26 views 3 comments 0 points Most recent by Parthiban Vaithiyanathan Reporting and Analytics for HCM
-
Need SQL/Catalog for Payroll Balances Report Based on EE Relationship ITDContent Hello All, Do you have any catalog/query to fetch employee payroll balance values based on employee “Relationship Inception To Date” dimension,. OTBI report do n…Janardhana Kondaveeti 210 views 1 comment 1 point Most recent by VijayaBaskar Ranganathan Reporting and Analytics for HCM -
Historic data of role assignmentsSummary Historic data of role assignmentsContent Hello Does anyone know if it is possible to return the history of a role being assigned to a user? For example User A ha…
-
DISTINCT NOT WORKSSummary DISTINCT NOT WORKSContent Hello everyone, Does anyone have any idea why my query does not work? I'm using DISTINCT but I get repeated rows. Also, we have 8500+ e…User_2025-01-25-01-17-59-580 52 views 9 comments 1 point Most recent by MandeepKGupta Reporting and Analytics for HCM
-
CASE Statement Future Termination DatesSummary Trying to show future termination dates as blank in active reportContent I have an all ee report. One of the fields is termination date. if someone has a future …Mike Borghoff 51 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Assignment Name vs Job NameSummary Report comparing Assignment Name and Job Name to list differencesContent The Oracle bug where Assignment Name and Job Title (Name) are different causes our downs…User_2025-01-23-21-24-21-434 62 views 10 comments 0 points Most recent by Debo Reporting and Analytics for HCM
-
Can we report on Workflow TransactionsContent Hi All, I am trying to see if we can report on Workflow Transactions. I am able to query fa_fusion_soainfra.WFTASK table which seems to have workflow data in HCM…Vibha Pandey - Oracle 230 views 9 comments 0 points Most recent by Vibha Pandey - Oracle Reporting and Analytics for HCM
-
Managers on a Leave of AbsenceSummary Managers on a Leave of Absence reportContent Hello, I am trying to create a report that will show managers, the managers Assignment Status (to be used to determi…Shanna Oppenheim 51 views 1 comment 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
BIP SQL Query to get absences hours and paid hoursSummary BIP SQL Query to get absences hours and paid hoursContent Hi All, Can someone guide me with the sql query to get the absence hours and paid hours of an employee …SuryaMuralidharan 79 views 1 comment 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM