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
-
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… -
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… -
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… -
HCM- Approval Notification Archive Real Time not returning dataSummary No results returned when using the new Approval Notification Archive Real Time subject areaContent I'm attempting to create a new analysis using the HCM-Approval… -
BI & OTBI - Latest pay periodContent How do I get the latest pay period in BI and OTBI ? We are giving 2 date parameters for users - Start date and end date If they enter it, then we calculate balan…
-
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…
-
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… -
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…
-
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… -
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…
-
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 … -
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 …
-
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
-
Need help setting the Month-end Date on ReportsSummary Need help setting the Month-end Date on ReportsContent The Calendar month-end date reported from the Time dimension on historical subject areas is reporting one …
-
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… -
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 84 views 9 comments 0 points Most recent by User_2025-01-25-01-33-46-269
-
Report Table Results TruncatedSummary Formatting Report OutpuitContent Anyone know how I accidently shrunk the table results like the attached pic?
-
Security for OTBI Reporting Using Workforce Compensation Subject AreaSummary Required security to create and view OTBI reports using the Workforce Compensation subject areaContent Release 8 and Prior The delivered Compensation Manager job…
-
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…
-
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… -
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 66 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle
-
GUID codes in OTBISummary Can i obtain specific GUID codes from OTBI?Content Hi, Can I use OTBI to extract the GUID codes for specific data fields? For example, I would like the GUID for …User_2025-01-28-05-39-23-766 65 views 7 comments 0 points Most recent by User_2025-01-28-05-39-23-766
-
R12 Upgrade: OTBI Reports are not runningContent Since the R12 upgrade when trying to run any OTBI Report by clicking on Apply or OK, nothing happens in the page, and the report does not generate. Open the repo…
-
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 155 views 6 comments 0 points Most recent by User_2025-01-29-19-59-40-005
-
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…
-
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…
-
Aggregated Security in OTBIContent Hi all A question on the aggregation of security in OTBI. We have a requirement where HR users may have access to different groups of employees via their Data Ro…User_2025-01-25-01-23-28-110 78 views 2 comments 0 points Most recent by User_2025-01-25-01-23-28-110