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
-
Dashboard Prompt values in format YYYY-MM using TO_DATETIMESummary date formatsContent hello, Looking for some suggestion on date format conversions in dashboard prompt, here is my scenario: One of my dasboard has a month prompt… -
Export Geography HierarchySummary How can I export the geography hierarchy?Content Hi, I couldn't find any option to export the full geography hierarchy as we defined in the "manage geography hie… -
Retrieve top 2 records per employeeSummary Need to figure out a way to determine the top 2 records for an employeeContent Hi All, I am read through some posts but still haven't found a solution for what I… -
Absence Accrual Plan attributes report neededSummary Is it possible to create a report that dumps all of the attributes related to an Accrual Plan?Content In OTBI, using the Subject Area: "Workforce Management - Ac…
-
Report on data entry by useridSummary Is there a way to pull transactions by person?Content Hi All, is there a report (or do you know the tables) that could be used to find the transactions/data entr… -
Assignment Changes Old and New ValuesSummary Reporting on Assignment ChangesContent I have a requirement for a report that shows Assignment changes with old and new values. For example, Department old and n…
-
Absence Report (back in time)Summary Is it possible to report absences as they were back in time?Content Hi, I provided a report to one of our customers yesterday that showed all absence between Jan…User_2025-02-05-22-44-35-842 39 views 6 comments 0 points Most recent by User_2025-02-05-22-44-35-842
-
Insert the profile image in a BI Publisher report dinamicallyContent Hi, I need to show the employee profile image in a report built using a .XLS template in BI Publisher. The field I'm using is "IMAGE" (BLOB type) from the table … -
Performance issue in absence line manager in OTBI reportsSummary Performance issue in absence line manager in OTBI reportsContent Hi Experts, I'm facing performance issue in a simple otbi report, my report has below fields Emp…
-
Worker Category changes not reflected in Workforce Management - Worker Assignment Event Real TimeSummary Worker Category changes not reflected in Workforce Management - Worker Assignment Event Real TimeContent Hello guys, Here is our business problem: Some of our co…User_2025-02-05-11-42-08-011 26 views 2 comments 0 points Most recent by User_2025-02-05-11-42-08-011
-
Security Matrix - Custom AnalyticsSummary Sharing the Security Matrix Analytics which reports the mappings between rolesContent Hello All, I have seen lot of posts asking for a solution to generate the S… -
job name changeSummary OTBI analysis to show job name historyContent Hi, I've searched the forum and sharing centre for this but can't see anything, so apologies if answered elsewhere.…User_2025-02-08-05-56-00-229 30 views 3 comments 0 points Most recent by User_2025-02-08-05-56-00-229
-
Workforce Trend Real Time PerformanceSummary Is there anything I can do to tune the performance of this subject area?Content Hello Experts! I'm starting to use Workforce Trends where we are trying to count … -
Do we have a feature in BIP reports to send a notification to certain email ids with the success/faiSummary Do we have a feature in BIP reports to send a notification to certain email ids with the success/failure status of the report?Content Hi, Do we have a feature in… -
Creating a BIP report based on a Procedure CallSummary Creating a BIP report based on a Procedure CallContent Hi Team, I need to create a BIP report based on a Procedure call. Is there any documentation available aro…
-
Unable to report from subject area 'Workforce Talent Review - Talent Review Tasks Real Time'Summary No results from OTBI sa 'Workforce Talent Review - Talent Review Tasks Real Time'Content Hello, Can anyone please help? I am unable to get any data from the subj…
-
Conditional formatting on Pivot table - heat mapContent I have created a report to look at the amount of annual leave taken so far in the year by different teams. I am having trouble putting the conditional formatting…
-
Location Transfers during the current yearSummary How to get the location for the first of the year and any changes throughout the yearContent Hi All, I have a requirement to pull in changes to an Employees Work…User_2025-02-04-08-51-08-912 39 views 2 comments 0 points Most recent by User_2025-02-04-08-51-08-912
-
Adding Hyperlink to InfoletSummary Want to add a hyperlink to an infoletContent Hi All - I want to leverage my infolet tile as a hyperlink. Have seen it done in the past at a prior company. Does a…
-
Active Job Titles & Salary RangesSummary pulling in all active job titles with salary rangesContent I have created an analysis using the 'Compensation - Salary Details Real Time'. The purpose of this an… -
Flexibility to create an OTBI report and put null value as a filterSummary We have a requirement from the client wherein the HRBP wants to put a logic that the report should help in extracting data of position incumbents , where the ass…
-
How to find a report in analytics (Balance Exception Report)Summary How to find an base report in the analytics tool to see if it can be customized.Content Hi All, My users have asked if it is possible to add the Assignment Statu…
-
Workstructure and Employee Incumbent Report using Subject AreaSummary Workstructure and Employee Incumbent Report using Subject AreaContent Hi Friends, I am aware it is possible to get Workstruture and Incumbent Details using a cus… -
Duplicate LinesSummary What function or formula is best to useContent Hi, I have numerous OTBI Analysis reports that will have 2 or 3 lines per employee because certain columns will co…User_2025-02-05-22-44-35-842 51 views 4 comments 0 points Most recent by User_2025-02-05-22-44-35-842
-
Sharing of different module BI reports between usersContent Hi All, We have certain reports that needs to be shared between users of different modules. For example: There are certain payroll reports that are also required… -
Employee change address reportContent Hello, we are looking to create a report that show changes to an employee address for that month, and to see there old address on the report as well. We want to …
-
Reporting on benefit plan elections and plan ratesSummary Reporting on benefit plan elections and plan ratesContent Does anyone have a report to share on plan / option elections along with the employee and employer cost…
-
How to limit Nationality in report?Summary Multiple nationalities for some employees - I only want the the main or primary nationalityContent Hi, I've attached the XML - can anyone modify the report so th…User_2025-02-05-22-44-35-842 28 views 9 comments 0 points Most recent by Raghavendra Raghunath-Oracle
-
Organizational chart with performance ratingsContent Is it possible to create a chart in OTBI in org-chart form that shows position name, position incumbents, incumbents' performance ratings and demographic details?
-
Oracle BI publisher - Which tool oracle is decommissioning ?Summary Hi Team, Can you please confirm which part of BI publisher is going to decommissioned ?We are planning to move fully in OTBI but need BI as wellContent Hi Team, …