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
-
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 81 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 63 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 66 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 151 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 -
Compensation Letter - one dynamically generated letter ?Summary Compensation Letter - one dynamically generated letter ?Content Requirement: We have a requirement in regards to Compensation worksheet letters. For the Salary R… -
Users and assigned rolesSummary Report to fetch all users and roles - Audit purposes / Security ReviewContent Hi - We are trying to get a report that would capture all users set up in the syste… -
Global Transfer actions returning duplicate recordsSummary Looking for a quantifier to alleviate duplicate employee records when last action was a global transferContent I have an analysis that I run for all active emplo… -
BPM Worklist Transaction LogSummary BPM Worklist Transaction LogContent Prior to upgrading to R12 I had access to the BPM Worklist Transaction Log as a Hr administrator where I could see all HR and… -
Need Help Formatting Output in BI AnswersContent I am in HR and am trying to write a report quickly without asking HRIS for help in the BI Answers section of the system. I was easily able to format the date to …