SQL
Discussion List
-
Date Parameter in BI Publisher ReportSummary Date Parameter in BI Publisher ReportContent Hi All Date Parameter in BI Publisher Report showing one day off in output, Tried setting of user time zone under My… -
Report for MFA Multi factor authenticationSummary Report to identify which employees have activated Multi factor authenticationContent Hi Do you know if there is any subject area or database table where I can se…Rogelio H 30 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to export approval rules configured for HCM transactions such as Absence, Employment etc.Summary How to export approval rules configured for HCM transactions such as Absence, Employment etc.Content Looking for a report to fetch the custom approval rules conf… -
Logical SQL Reports and Report HeadingsSummary Logical SQL Reports and Report HeadingsContent Hi, I have created a report using Logical SQL and was wondering if it is possible to include a user friendly Colum…Karen Waddell 32 views 7 comments 2 points Most recent by Karen Waddell Reporting and Analytics for HCM -
Set PARAM_EFFECTIVE_DATE within a UNIONSummary Combine results of 2 analysis when one has an effective dateContent I have two reports with the same columns and I am combining them with a UNION. However one an…s_b 40 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Legal Employer Hire Date and Enterprise Hire Date on Work Relationship DetailsContent Hi All, Can someone help to find underline tables and fields for "Legal Employer Hire Date and Enterprise Hire Date on Work Relationship Details Tab" If you have…User_2025-02-07-19-03-14-525 64 views 2 comments 1 point Most recent by AshishERPCloud Reporting and Analytics for HCM -
OTBI Agent Email Analysis Run As Of Date Derived by SQLSummary Trying to setup existing 'Point in Time' analysis with AsOfDate Parameter as automated agent that uses SQL to derive the last day of the prior month at runtimeCo…James Hoffmann 87 views 13 comments 0 points Most recent by James Hoffmann Reporting and Analytics for HCM
-
How can I filter on column and not a measures in OTBISummary Filter in a sample column and not a measures how can i do it??????Content Hello, I want to transform a simple column in otbi into a measures to create a filter :…User_I6AXL 42 views 2 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Fusion HCM OTBI/BI report usage analytics?Summary How to get OTBI/BI report usage analytics?Content Is it possible to get OTBI or BI report usage analytics? VIZ., input - Report Name Output - list of users who r…User_2025-01-25-04-02-13-126 328 views 24 comments 1 point Most recent by AshishERPCloud Reporting and Analytics for HCM
-
Non Prod Last refresh (P2T) dateSummary Non Prod Last refresh (P2T) dateContent Hello All, Is there any way we can find the Non Prod environment last refresh (P2T) date by using a query/table or profil… -
Question marks in attributes causing filtering troubleContent Hello Experts, We've encountered a situation where a course has been setup in our learning module with a question mark at the end. We've found that when we try t…Rob F 13 views 5 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
How can I get Job Change Date?Summary Sending data to LMS need to send Date a job changesContent Hello Everyone, I am having a business case where we as a company need to send Job start date and when…User_2025-02-10-15-06-52-222 70 views 4 comments 0 points Most recent by Rahul Bedia Reporting and Analytics for HCM
-
Need a SQL Query to fetch previous employment element entry details.Summary Need a SQL Query to fetch previous employment element entry details.Content Hello Team, I have a requirement to fetch Previous employement element entry details …User_2025-02-10-16-28-01-402 660 views 2 comments 0 points Most recent by Rahul Bedia Reporting and Analytics for HCM
-
Remove DuplicatesSummary Remove DuplicatesContent How to remove duplicates from Excel template? Regards, ReddykrishnaReddykrishna 53 views 3 comments 0 points Most recent by Karen Costakes Reporting and Analytics for HCM -
Need a SQL query to fetch Previous salary and previous assignment working hours of an employee.Summary Need a SQL query to fetch Previous salary and previous assignment working hours of an employee.Content Hello, I have a requirement to fetch Previous salary and p…User_2025-02-10-16-28-01-402 1K views 2 comments 0 points Most recent by User_2025-02-06-20-13-56-572 Reporting and Analytics for HCM
-
SQL Code to Extract Setup Grade Rates with Grade NameSummary SQL Code to Extract Setup Grade Rates with Grade NameContent Team, I have a similar requirement. I am trying to fetch the setup data of Grade Rates with Grade na…User_2025-02-01-03-43-13-079 115 views 3 comments 0 points Most recent by Rajeev Nayan Reporting and Analytics for HCM
-
How to exctract the AddressId in OTBI (PersonAddress)?Content Hello experts, is there a way to extract the Person Address Id in OTBI? In case, do you have the SQL Query to extract the AddressId? Thanks in advance for your t…Valerio Curzi 35 views 2 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
OTBI - prefix for current date minus daysSummary How can I define prompt for an OTBI report which is the current date minus variable of daysContent Hi, I'm trying to create a prompt of number, so if the user wi…
-
Learning -> How to achieve Fusion Security into Custom BIP Reports through SQL?Summary Apply fusion security into custom-sql reportsContent Hi, Can anyone please help? I am in the process of developing a few custom reports using sql/bip option and …SantoshKumarBhairi 101 views 3 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Is it possible to write a validation query against excel/csv data source in data model?Content I have created 2 data sets using excel and csv as data source. I want to write basic query to validate data from these files. Is it possible to validate excel da…Samir Patro 39 views 4 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM
-
Duplicate Manager Data Integrity ReportSummary Duplicate Manager Data Integrity Report not workingContent Hi All, We have a data integrity report that we would like some help troubleshooting. This report is i…User_2025-02-07-16-42-37-187 31 views 4 comments 0 points Most recent by User_2025-02-07-16-42-37-187 Reporting and Analytics for HCM
-
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 22 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 22 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 17 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 30 views 5 comments 0 points Most recent by User_2025-02-04-08-51-08-912 Reporting and Analytics for HCM