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
-
Unable to access Oracle Provided OTBI ReportsContent Hi All, We are unable to access Oracle provided standard OTBI Performance Management reports. We are in Fusion Cloud. I heard that we need to use Subject areas e… -
Where can I find Hire Reason in HCM OTBI/BI Answers?Summary Looking for subject area and field name for Hire ReasonContent I am working on an HCM OTBI/BI Answers analysis and would like to report Hire Reason. Can you tell…User_2025-01-28-17-24-53-863 51 views 6 comments 1 point Most recent by User_2025-01-28-17-24-53-863 -
Assignment Point-in-Time ReportContent I'm looking to be able to run a report that will pull assignment data as a specific point in time. Does anyone have a catalog they can share with me?User_2025-01-22-19-19-56-324 103 views 6 comments 0 points Most recent by User_2025-01-23-21-28-55-898 -
looking for HCM fusion reporting expertSummary HCM fusion reporting expertContent We went live with HCM fusion payroll, core, time, absence, and employee self service. We are looking for some short term repor… -
Report for Performance Document Question ResponsesSummary Report for Performance Document Question ResponsesContent I have created a performance document with only a questionnaire section. I am trying to build an OTBI r…User_2025-01-22-19-28-29-985 235 views 21 comments 0 points Most recent by Raghavendra Raghunath-Oracle -
Add BIP reports to flow patternContent Hi All, We developed multiple reports as per our requirements. Here we need to run few reports in a custom flow from Navigator-->payroll-->checklists so I though… -
eTEXT BIP BurstingContent Hi All, I developed SQL Query and eText template as per the requirement. Now I am trying to send eText output to mail through Bursting. When I submit the report … -
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 89 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 58 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 42 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 30 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 43 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