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
-
How to pull APR document through SQL?Summary How to pull APR document through SQL?Content We have a business requirement to pull Annual Performance Document of all employee. Oracle says there is an ER with … -
Reporting on changes to users and their HCM security profilesSummary need a report to show any assignment changes for people with certain security rolesContent Hi everyone, We are early in our implementation of HCM. One of our rep…
-
Oracle seeded Total Turnover Report available?Content We have delivered a custom report to show the Total Turnover for a business. This can be filtered by a number of options - ie. Date Range, Business Unit, Region,… -
Report on total number of direct and indirect reports by managerSummary How can I sum distinct direct and indirect reports by manager?Content Hi - I'm having a hard time figuring out how to sum direct and indirect report total counts…
-
Filtering Between Two "TimeStampDiff" DatesContent Good Day, I was wondering if anyone has had a similar query and has also found a solution. The query is i want to search between Two Dates and for then for it to…User_2025-01-28-07-12-45-467 90 views 5 comments 0 points Most recent by User_2025-01-28-18-08-05-947
-
Need to get Manager Name dynamically in OTBI reportSummary Need to get Manager Name dynamically in OTBI reportContent HI All, We have a requirement need to develop a OTBI report based on the Manager i.e. if manager login…
-
Compensation Amount (Filtered by Team) field OTBI Subject Area in CompensationSummary Compensation Amount (Filtered by Team) field OTBI Subject Area in CompensationContent Hi All, Could you please suggest in which Subject Area/Attribute or BIP tab…
-
Help needed - report on employees - start date when employment made permanentSummary How to create a report where I get data on dates when employees employment changed to permanentContent Hi, I need a report from employees whose employment change…User_2025-01-28-07-55-21-868 59 views 5 comments 1 point Most recent by User_2025-01-28-19-49-15-062
-
Detailed data with fields for Reports from BI apps and OTBI vs datasets obtained via catalog managerSummary Detailed reports data with fields from BI apps and OTBI similar to the one obtained via catalog manager in OBIEEContent I am looking for information on detailed …
-
Bursting BIP QueryContent Hi All, We build BIP report with Bursting as per our requirement. The query which we build on the Performance Management module. If we run the report with Perfor…
-
OTBI - Report to see transactions approved which were initiated by Line Manager in MSSSummary OTBI - Report to see transactions approved which were initiated by Line Manager in MSSContent HR need to have visibility of when the following transactions have …
-
BI - using CASE statement in WHERE clauseContent We are creating a report in BI and it takes parameter from a dropdown list that populates based on SQL. And we need to use that parameter in the WHERE clause. Ex…
-
Is Performance Goal Action Taken available for reporting in OTBI / BI Answers?Summary Need to report Goal Action Taken in BI AnswersContent In the subject area Workforce Goals - Goal Status Overview Real TIme, is Action Taken available for reporti…User_2025-01-28-17-24-53-863 43 views 2 comments 1 point Most recent by User_2025-01-28-17-24-53-863
-
OTBI - Set the column heading label for multiple columnsContent Hi, I want to SET the columns heading label same as the Folder heading label by default for all the columns. I know you can do manually one column at a time manu…
-
Making a page to host a dashboardSummary I would like to be able to make a page that looks and feels just like the Manager DashboardContent Hello Everyone, I have a question in regards to setting up new… -
Salary Change AuditSummary Is there a way to run a report to find out who entered a salary change in Manager Salary and when?Content Is there a way to run a report to find out who entered … -
OTBI report with person details, competency name, profile name, profile status code, position code,Content what is the most feasible way to pull data which contains employee details with competency and profile name? I had tried using subject area Workforce Performance…User_2025-01-27-23-54-00-342 144 views 9 comments 0 points Most recent by Raghavendra Raghunath-Oracle
-
What is the Subject area for Career Statement?Summary I want to know which subject area give "Career Statement" in OTBI
-
Report doubling my values.Summary I have a report which should count every employee as 1, but for some reason counts them as 2.Content Hi, I have a traffic light report which counts employees who…User_2025-01-25-04-51-10-553 32 views 3 comments 0 points Most recent by User_2025-01-25-04-48-26-816
-
Having issue with OTBI Analysis report created using logical sqlContent Hi, We have created an OTBI ANALYSIS REPORT which is based on a logical sql and when we run it we are getting the below strange error msg: Result field position:…
-
Report Jam at OHUG Orlando (June 6-8)Content Sign up to guarentee some in-depth 1:1 report building using Oracle Transactional Business Intelligence (OTBI) for HCM, Taleo Enterprise Reporting or Taleo Learn… -
Remove expired dates from an end date report.Summary End dates of before the current date are appearing on my report.Content Hi, I have produced a report on end dates, such as fixed term and probation end dates. Th…User_2025-01-25-04-51-10-553 44 views 4 comments 0 points Most recent by User_2025-01-25-04-51-10-553
-
Goal DashboardSummary Goals - one Dashboard for different user/regional responsibilitiesContent Hey All, I'm wondering if you have faced the same issue like we do. Based on the "Goal …User_2025-01-23-22-38-50-675 105 views 12 comments 2 points Most recent by User_2025-01-23-22-38-50-675
-
Changes in Hours / Grade / Salary / Organisation / Business Units etcContent Hello, We are looking for a way to create an analytical report or maybe even a dashboard that can show when "Historically" an employee has changed one of these f…User_2025-01-28-07-12-45-467 133 views 3 comments 2 points Most recent by Raghavendra Raghunath-Oracle
-
A How-To Article on Creating a Pipe Delimited Report from a Subject Area in Oracle HCM CloudSummary Demonstrates How to Create a Pipe Delimited Report from a Subject Area in Oracle HCM CloudContent For those of you who have a little bit of idea about OTBI (Orac… -
Eligibility tables for data modelSummary Eligibility tables for data modelContent I am having some difficulty creating a data model that i need for the report bursting. I want to create a report that wi…
-
Reporting on Working Pattern/ Work Schedules aswell as current assignment information in a single reSummary Possiblity of generating a report Including Working patterns/Work and Assignment information within an Analysis/ReportContent Hello, We are currently struggling … -
Using interactions to Navigate into ModulesSummary Helping users navigate to relevant screens from analysisContent Hi, I'm trying to come up with creative ways to integrate the analysis into the Core HR modules. … -
Manager Name using OTBI Report for a Termination Person using the Workforce Management Worker AssignContent Is is possible to get the manager name for the terminated person using the Workforce Management-Worker Assignment Event Real Time Subject Area. Currently the rep…
-
Unable to pick latest salary details for a person using subject area "Compensation - Salary HistoryContent Hello All, I am having a trouble in pulling out the latest salary details for a person using "Compensation - Salary History Details Real Time" Subject area. I ca…User_2025-01-25-06-20-12-259 134 views 18 comments 0 points Most recent by User_2025-01-25-06-20-12-259