SQL
Discussion List
-
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 52 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 K 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 53 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 53 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 228 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 52 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 81 views 1 comment 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM
-
SQL query fetching Duplicate rows for terminated employees with pending worker recordsSummary SQL query fetching Duplicate rows for terminated employees with pending worker recordsContent I created a SQL BI Publisher report to fetch all active employees a…User_2025-01-30-21-52-52-008 261 views 18 comments 0 points Most recent by User_2025-01-30-21-52-52-008 Reporting and Analytics for HCM
-
Tables to track employee activity to HCMContent Hi All, Can anyone tell us if there is a report,tables...or fields that we can use to create a report...to track if an employee has: 1) Attempted to login to HCM…User_2025-02-04-18-22-33-673 80 views 3 comments 0 points Most recent by User_2025-01-28-00-10-14-788 Reporting and Analytics for HCM
-
Exclude logged in user from indirect reportsSummary Exclude logged in user from indirect reportsContent Hi, I have a Direct and Indirect selector prompts for managers to use which displays direct and indirect empl…User_2025-01-30-03-54-32-528 48 views 9 comments 0 points Most recent by User_2025-01-30-03-54-32-528 Reporting and Analytics for HCM
-
Workforce Management - Absence Real TimeSummary Issue with Absence DashboardContent Hi, I am trying to create a OTBI report based on Subject Area - Workforce Management - Absence Real Time. Currently we have a…Shail Parekh 245 views 14 comments 1 point Most recent by Rambo Jacob Reporting and Analytics for HCM -
Report to fetch Hire Dates in a letterSummary Not able to compare among three date in BI PublisherContent I have developed a BI Report to extract salary of a person. And after this developed RTF template in …User_2025-01-29-18-45-19-617 42 views 2 comments 0 points Most recent by User_2025-01-29-18-45-19-617 Reporting and Analytics for HCM
-
How does per_ldap_users table get populated?Summary How does per_ldap_users table get populated?Content Two user accounts were created manually and assigned roles. I see that both of them are available in PER_USER…User_2025-01-25-04-02-13-126 103 views 3 comments 1 point Most recent by MandeepKGupta Reporting and Analytics for HCM
-
Query to get non person account detailsSummary Query to get non person account detailsContent Using the below query to get the non person account details but for few users the first name, lastname and email a…SuryaMuralidharan 75 views 2 comments 0 points Most recent by Janardhana K Reporting and Analytics for HCM
-
As-of-Date Doesn't work anymoreSummary As of date variable in OTBI doesn't workContent Hi, Since the last release, the feature of putting variable in OTBI analysis for effective date doesn't work. The…
-
Identify ALPHABETS in STRINGS in OTBIContent Hi All, We have an report where we need to identify ALPHABETS from a values coming up in the report as a filter criteria. For examples, pick all the Account numb…Vibha Pandey - Oracle 33 views 4 comments 0 points Most recent by Vibha Pandey - Oracle Reporting and Analytics for HCM
-
Unable to identify manage element screen under settlement date column in element entry tableSummary Unable to identify manage element screen under settlement date column in element entry tableContent Attached application screen shot from Manage element entry an…
-
Query to get active and active uses in the systemSummary Query to get active and active uses in the systemContent Query to get active and active uses in the system.We have Crosse verified the per_users table but didt g…Koteswararao Yenikepalli 78 views 3 comments 0 points Most recent by Jagdish Varadraj Reporting and Analytics for HCM -
Query/Table to view BPM commentsSummary Query/Table to view BPM commentsContent Hello All, We have requirement to capture the Approver comments in a report. Let us know if you are aware of table/query … -
BI Publisher GUI Outer Join QueryContent Hi, We have created a query which is comprised of 3 data sets.They are joined by the elements within the data models. Background: We used to have this pending ap…User_KOLMZ 37 views 3 comments 0 points Most recent by User_2025-01-22-18-30-18-571 Reporting and Analytics for HCM -
Percentage of columnSummary Need to calculate a percentage off Median salary by various attributesContent Attached sample. I can get the first 4 columns. However, I can't come up with the r…Mike Borghoff 59 views 8 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Calculations - level downContent I need to build three charts that hinge off one another: 1. Average or Median salary by Gender/BU/Management level. 2. From the chart above, I need to just get a…Mike Borghoff 42 views 1 comment 0 points Most recent by Aaron Leggett Reporting and Analytics for HCM
-
BIP report and sql injectionContent Hello Experts, While creating BIP reports in the Oracle fusion environment , do we need to consider Sql injection? If we have a BIP report that takes input value…User_2025-01-30-00-14-06-021 78 views 2 comments 2 points Most recent by User_2025-01-22-18-30-18-571 Reporting and Analytics for HCM
-
OTBI - Manager person number as the main keySummary Is it possible to refer the manager person number as the primary key in OTBIContent Hi, Can I make a report in OTBI so all the fields (assignment status, job, de…Yaniv 70 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
BIP Report to view the UCM file and its contentsSummary BIP Report to view the UCM file and its contentsContent Hello, In PROD we can't give UCM access to developers due to SOX compliance. Is there any way we can acce…