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
-
Trigger Extracts from BI PublisherSummary Can BI Publisher trigger HCM Extracts?Content Hello, Can BI Publisher catalog trigger an Extract? We have a working extract already and we want to trigger it usi… -
Important Information About Fusion OTBI R12 Patch Bundle 10Summary This note provides information about Fusion OTBI R12 PB10 (2017 October monthly patch bundle)Content This note provides information about Fusion OTBI R12 PB10 (2… -
Report to view workflow configuration in Fusion HCMSummary Report to view workflow configuration in Fusion HCMContent In Fusion HCM, we navigate to 'setup and maintenance' > 'Manage approvals for Human Capital Management… -
OTBI Error: The View Object "HcmTopModelAnalyticsGlobalAM.ManagerHierarchyAM.PersonNameDPVO" is usedSummary OTBI Error: The View Object "HcmTopModelAnalyticsGlobalAM.ManagerHierarchyAM.PersonNameDPVO" is used as the destination of more than one View LinkContent We are …User_2025-01-25-04-02-13-126 37 views 6 comments 0 points Most recent by User_2025-01-25-04-02-13-126 -
BIP Report with OTBI PromptsSummary How do I create a dashboard that uses OTBI prompts for a BIP reportContent Hi all - we are experiencing an issue since our Rel12 upgrade, where the parameters fo… -
Error 500 --Internal Server Error - BIP ReportsSummary Error 500 --Internal Server ErrorContent We have created a BIP reports but when we run it we get the following error message. Is there a way to fix it? thank you -
Encountering Inaccessible Column Error When Running Report as an EmployeeSummary Encountering Inaccessible Column Error When Running Report as an EmployeeContent Hi Experts, We have created a Report on WorkForce Management - Work Relationship… -
R12 Pre-built OTBI ReportsSummary How to get a list of Pre-built OTBI ReportsContent Hello Everyone, Does anyone know where I can get the list of all Pre-built OTBI reports or Analysis with all t… -
Report for reverse terminationsSummary Report for reverse terminationsContent We are currently looking to build a report that has those who may have been processed as termination but then had the term… -
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… -
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 236 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 -
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 63 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle