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
-
Query/Report to show Manager is blank in the Security Console (Oracle Fusion)Summary Query/Report to show Manager is blank in the Security Console (Oracle Fusion)Content I need a query or report to find for the users who ever has the Manager fiel… -
How to get the Offer accepted date of the person in BIP?Summary How to get the Offer accepted date of the person in BIP?Content Hello Team, We are looking for a table, where we will get the offer accepted date of the person. …
-
Head Counts in OTBI Subject AreasSummary What does every Head Count Mean?Content Hi All, We have some Infolet requirement where we need to use HEAD COUNTS. For this we need to understand what every head…
-
Report for Box 1 of the W2 balance valueSummary Provide a list of highly compensated employees using Box 1 of the W2Content I am trying to get a list of highly compensated employees whose Wages, Tips, other co…User_2025-01-28-09-44-42-254 86 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle -
Need tablenames to pull Valueset values in BI reportContent Hi, I have requirement to pull value set values in BI publisher report. I am not able to find the table names for the valueset in HCM. Can you please let me know…
-
Report detailing user with Manager email addressSummary I need to develop a report that includes a users email address, which is simple, but I also need to include the respective managers email address.Content I need …
-
Termination Report for Managers not reflecting all terminationsSummary I have created a termination report for managers but when a manager views, it is not accurate.Content The Termination Details Report was created for use in a Das…
-
Is it possible to display the filter values at the Header section in OTBI?Summary Is it possible to display the filter values at the Header section in OTBI?Content Hello Team, We are trying to display the filter values at the Title section in …
-
Adobe Flash to run reports/dashboards on browsersContent Hi All, Over the past few days while working in OTBI, I kept getting asked to run flash everytime I opened a report or dashboard- eventhough flash is already ena… -
XPT Ouput(User Interface Layout) is running under ProgressSummary XPT Ouput(User Interface Layout) is running under ProgressContent HI Team, We have report which has XPT Layout output(User Interface Layout).We have given open p…
-
Reporting on Weekly Changes to Workforce TrendsContent We have a business requirement to report of weekly changes to FTE count for our departments. Where there's not a weekly time dimension in the Workforce Trends su…
-
Accessing user-defined tables in OTBIContent Hi All, I have few user defined tables in HCM.Department ID and Department Name. Now I want to access this user defined table and user defined columns and put a …
-
Copy Link requires - Adobe Flash PlayerContent This is an annoying error which keeps coming for Line Managers. Is there a way to fix this issue? Thanks -
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 38 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…