Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for HCM
Discussion List
-
Calling UDT in OTBISummary We need to get UDT values on OTBI AnalysesContent Hi All, I am working on an OTBI analyses where we need to derive values from UDT. I am not able to see these UD… -
How to calculate the correct number of employeeContent Hi Guys, I need to calculate the correct number of the employee active in the company. I used the Headcount field with the filter Assignment status == Active, Ac… -
Parent Child ReportContent In my report, I am trying to only show the parents of a parent child relationship. I followed the guide to set up the relationship object but when I use a report…
-
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… -
Look Up Value as Of DateContent Hello, Is it possible to create a field in OTBI to look up a value as of date. The requirement I have is to pull an employees current job and salary and their jo… -
Problem in a Presentation VariableContent Hi Guys, I have a problem in a report that I created to filter the entry elements for effective start date. I don't able to change the effective start date field…
-
Report viewing problemContent Hi Guys, I have a big problem with the report viewing. I created a HR Dashboard, every employees can see the Dashboard, but who have the procurement role don't h…
-
Can we get 'Time in Position' through OTBI?Summary Can we get 'Time in Position' through OTBI?Content Hi Team, Is it possible to get 'Time in Position' column through OTBI. Means how long the assignment exists in…
-
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
-
Audit for multiple open assignment-related transactions on same associateSummary Audit for multiple open assignment-related transactions on same associateContent Good afternoon. Wondering if anyone has built an audit (in either OTBI or BIP) t… -
Number of days left of vacationsSummary Number of days left of vacations for a person who's been let go or has resignedContent Hi, I'm trying to get the number of days left of vacations from a person w…User_2025-02-05-01-30-45-449 39 views 5 comments 0 points Most recent by User_2025-02-05-01-30-45-449
-
Payroll User-Defined Tables Real TimeSummary OTBI joining subject areasContent Hello. I am trying to link the "Payroll User-Defined Tables Real Time" subject area to the "Person Real Time" / "Workforce Mana…
-
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…
-
Date prompt is getting passed in invalid format to BI report used in Dashboard.Summary Date prompt is getting passed in invalid format to BI report used in Dashboard.Content Hello, We are facing an issue in while using dashboard as BIP as content. … -
How to show Zero or another message in Infolet if Analysis does not return dataSummary How to show a message or 0 if analysis does not return any row, When there is a count it shows the count.Content How to show a simple message or just Zero (0) as…Prateek Parasar - GTUK, ACE Pro 39 views 11 comments 0 points Most recent by Caroline Gladwin-Oracle -
Limit what data users can see in OTBISummary We want to limit certain data that the users can see in OTBIContent We have a requirement to limit data on the UI and in OTBI that the user can see. For example,…
-
BIP report issueSummary SQL query time exceeds the limit (2400 sec). Stopped processing.Content Hi Team, As an Admin, I can run a report and it completes sucessfully for me. Users can't… -
We are not able see the BIP report jobs scheduled by othersSummary We are not able see the BIP report jobs scheduled by othersContent Hi All, We are not able see the BIP report jobs scheduled by others in Manage Jobs screen. We …
-
Report for Absences are going into auto denial statusSummary Report for Absences are going into auto denial statusContent Report for Absences are going into auto denial status We have Absence going into Denial status, not …
-
Plans to move from OBIEE 11.1.1.9 to 12.xSummary When does Oracle plan to move the OTBI/BIP cloud platform from version 11.1.1.9 to 12.xContent Is there a Statement of Direction or a blog post that states if an…
-
Workforce Trend Real Time - Calculate Weekly TurnoverSummary Trying to use Workforce Trend Real Time and Worker Assignment Event Real Time to calculate weekly turnover ratesContent Hi! I'm trying to create a report showing…
-
How to user Variable in OBI Agent AlertsSummary How to user Variable in OBI Agent AlertsContent Hi we used & to include any Variable in Oracle Alert and we have a similar requirement where we want to use the E… -
Analytics for Absence BalanceSummary Is it possible to make an analytics to get absence balance for a given dateContent Is it possible to make analytics to get the absence plan balances for a given …
-
Analyses showing list of users with a specific RoleSummary Analyses showing list of users with a specific RoleContent Hi, Can I create Analyses (not data model based BIP report) showing a list of users with a specific Ro… -
HCM HR/Payroll Approval Reminder EmailsContent My task is to send out emails to assignees that they have pending HR/Payroll approvals on Wednesday and Friday mornings. I wrote a data model containing this dat…
-
Distinct row in a employees reportContent Hi Guys, I need to realize a report with the following field: National Identifier National ID National Identifier Person type Name Last Name Name First Name Legi…
-
Performance Rating Level Name for Section and ItemsSummary Show Rating Level Name for both section and item when they use the same rating modelContent Hi, I kindly need to know if there is a way to display section rating… -
Export Pivot Table with >75k rows (Data Model)Summary Trying to export Pivot but keep hitting row limitContent Hi, I have a pivot view on a report that I need to export out in to Excel. Unfortunately, the list canno…
-
Audit Log on reportsContent Hi Experts, We are having multiple BI publisher and OBIEE reports set up in UAT and production environments. What is the most efficient way to run audit on the r…User_2025-01-30-00-14-06-021 134 views 7 comments 0 points Most recent by User_2025-01-28-16-10-52-033
-
User Report With Last LoginContent Hello, I'm having a hard time understanding why there is a lack of information regarding User login data. Does anyone have a report to be able to see the last lo…