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
-
Number of hires by contract type in OTBI reportSummary I want to use 2 subject areas (contract type) and assi event real time to display number of hires by contractContent Hello, I m not able to join the number of hi… -
Termination report with subquerySummary Looking for a subquery that would eliminate currently active employees form termination reportContent Hello, I am trying to build a termination report for our or… -
Current Employee Report returning an additional row for some employeesSummary Some employees have additional row with only a few populated columnsContent Our current report reflects 14 employees with an extra row; however, only a few of th…User_2025-01-28-20-43-56-568 57 views 2 comments 0 points Most recent by User_2025-01-28-20-43-56-568
-
Tables vs Subject AreaSummary How to quickly find the right Subject Area from a particular tableContent Hello everyone, I have a Disco report based on the following tables. So, we may say the… -
Subordinate Salary ReportContent I want to create a report wherein I can capture the salaries of an supervisor's direct reports. The client wants to ensure that the difference in salaries betwee… -
How to report on Work Schedules in R12Summary Trying to report on Work SchedulesContent Hi, I am trying to build an OTBI report on work schedules in R12, it is my understanding with R12 this functionality wa…
-
How get approver comments?Content Hi All, I am just trying to find a subject area to get the approval comments at the point of approval of a performance document? Is it possible to get from subje… -
BI report - Worker Assignment StatusContent I am creating a BI report and I need to show Assignment Status just like how it is showing in OTBI as follows: Active - Payroll Eligible Leave - No Payroll Leave… -
Rel12 PB8: OTBI HCM Prompts subject areaSummary A new subject area has been added to the list of HCM OTBI subject areas. The purpose of this subject area is to setup dashboard prompts and use them in the dashb… -
OTBI HCM Prompts Subject AreaSummary How do I use the Subject Area: OTBI HCM Promps?Content Hi all - I noticed a subject area I had not seen before: OTBI HCM Prompts. I am unsure how to use this, bu… -
OTBI vs OBIA (Data Warehouse)Summary When do I use OTBI vs OBIA?Content Hi all - I am still learning our environments and would like to understand when to use OTBI/BIP and when to use OBIA (Oracle d…
-
Sickness Absence & Right to Work DashboardsContent Hello, I'm looking to provide two dashboards to the business based around 1) sickness absence and 2) the status of an employees right to work (nationality/passpo…User_2025-01-29-19-59-51-150 81 views 2 comments 0 points Most recent by User_2025-01-29-19-59-51-150
-
What subject area to use for user roles?Summary Need to create a report that show the roles each employee is assignedContent Hi. Can someone please share if there is a subject area folder available that would …
-
Email Trigger through OTBISummary Need Email to be triggered to IT department if any name changes happens in the 'Last Name' or 'First Name' through OTBI agentsContent Hi Team, we have a requirem…User_2025-01-23-22-36-48-692 237 views 6 comments 0 points Most recent by User_2025-01-31-00-25-12-234
-
OTBI: Default date promptContent Hi, I want to display current_date as my default value in the Date prompt. How can I do it? Thanks Alex
-
Number of employee with a salary = 0Content Hello, I try to do a really simple OTBI : get the number of employee with a salary = 0 I don't manage to do this, I have 0 result with the code below is there so…User_2025-01-25-01-33-46-269 81 views 9 comments 0 points Most recent by User_2025-01-25-01-33-46-269
-
Worker's Folder Take Forever To Load in OTBI Subject AreaSummary Worker's Folder Take Forever To Load in OTBI Subject AreaContent After the Release 12 upgrade, we have been facing issues creating Analysis, the Worker's Folder … -
Report Table Results TruncatedSummary Formatting Report OutpuitContent Anyone know how I accidently shrunk the table results like the attached pic?
-
Talent Profile ReportsContent Our legal team has requested an audit trail type of report for Talent Profile details. Specifically they want time stamps of when data was added or removed by wh… -
OTBI Analysis Based On Static DataSummary Is it possible to create OTBI Analysis Based on static data in Oracle HCM Cloud?Content Hi Experts, I am aware we can create BI Data Model using static data( Exc… -
BI Publisher for WORD creates last row of a table as merged cellsSummary BI Publisher for WORD creates last row of a table as merged cellsContent With BI publisher for WORD I created a template with a table to be able to run the repor… -
OTBI Comp Report That Restricts ViewsSummary OTBI Compensation Report using a custom DM needs restriction on dataContent We've created an OTBI comp report using a custom data model. This report is allows mg…
-
Performance Rating Status - "Not Started", "Ready", or blankSummary Unable to see employees eligible for their Performance Review but haven't began the processContent Has anyone been able to pull employees eligible for a Performa…User_2025-01-28-08-47-04-905 64 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle
-
Scheduling the report(Email Notification) if the data is present in itSummary Scheduling the report(Email Notification) if the data is present in itContent Hi All, Greetings !! Our customer's requirement is to receive the report/Email noti…
-
Change report to automatically select records two months priorSummary Automation of report selecting records two months priorContent I have a report that I run each month which is then sent to another department. The purpose of the… -
Duplicate Rows for a report trying to capture each employees self and manager evalsSummary Performance Review ReportContent I'm trying to create one report which will capture an employee's self eval and performance review status'. If it worked perfectl…
-
Unable to see Infolets I've CreatedSummary No Infolets visibleContent I have created several Infolets in Business Intelligence - but none of them show up on the Infolet Repository - only Competitions show…User_2025-01-29-19-59-40-005 152 views 6 comments 0 points Most recent by User_2025-01-29-19-59-40-005
-
Report to capture complete reporting lineSummary Supervisor hierarchy ReportContent Hi everyone - Has anyone here had a requirement to pull out the complete reporting line of one manager? We are trying to creat…
-
In Cloud HCM are personalisations configuration or customisation?Summary In Cloud HCM are personalisations configuration or customisation?Content In Cloud HCM are personalisations configuration or customisation? E.g. if we hide some i…
-
UK Statutory reporting available in Oracle HCM Cloud including HESA, RTI, etc.Summary What is the UK Statutory reporting available in Oracle HCM Cloud including HESA, RTI, etc. ?Content What is the UK Statutory reporting available in Oracle HCM Cl…