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 Rows in a ReportSummary How to see the number of rows in a reportContent I am new to OBTI and am trying to build report up slowly and trying not to lose employee details as I go along o… -
Report to fetch Open Notifications for the employeeSummary Report to fetch Open Notifications for the employeeContent Hi Guys, I have a requirement to send all the open notifications as a summary via email every week to … -
Analysis about own Person ProfileContent Hi, it seems that Worker cannot see information about own Person Profile on analysis (Workforce Profiles - Person Profile Real Time). Can we achieve this by cust… -
Need Employee Leave Balance Report ?Summary Need any pointers/hints for building Employee Leave Balance ReportContent Expected Layout Parameters Effective Date : 06-Jul-2015 Employee Leave Balance Report P… -
Grouping EthnicitiesSummary Grouping ethnicities after a single row of data has been calculatedContent Hi everyone, Using this post, I was able to successfully get an ethnicity report to re…User_2025-02-11-03-07-51-707 168 views 4 comments 0 points Most recent by User_2025-02-11-03-07-51-707 -
Nationality Head Count AnalysisSummary Nationality Head Count AnalysisContent Hi All, May I know if anybody has done head count analysis based on Nationality . Could you please guide me. If I take fro…User_2025-02-06-09-41-56-955 35 views 4 comments 0 points Most recent by User_2025-02-06-09-41-56-955 -
How to get link between Plan, Plan option and Elements for individual compensation plans?Summary How to get link between Plan, Plan option and Elements for individual compensation plans?Content Hi Team, We have a requirement where to fetch all the elements a… -
One prompt for multiple views in OTBIContent Hello, I have developed an OTBI analysis which will have two different views (Pivot table & Graph). Can we have a single Prompt for both the views? I do not see … -
Absence cases and Details linked to absenceContent I am looking to build a report that includes the absence cases and the associated absence and details from the documents that have been attached in order to prov… -
Oracle Employee auditing that captures changes to a persons recordContent We currently have been looking at the history tab within person management and have realized that it does not give us much information. After connecting with Ora… -
Effective Date of Latest Job CodeSummary Pulling Effective Date of Latest Job Code in an analysisContent I have created an analysis using the subject area ‘Compensation – Salary Details Real Time’. I ha… -
OTBI - HCM Manager dashboard Session 01 - 11/March/2021Summary OTBI Reporting overviewContent This OTBI working session conducted on March-11-2021 had an overwhelming response of 277 attendees. I hereby attach the resources …Raghavendra Raghunath-Oracle 65 views 0 comments 1 point Most recent by Raghavendra Raghunath-Oracle -
Promotion SpeedContent Hi All! Has anyone had luck working on promotion speed ratios out of OTBI? Diving into this in the next week or two and wanted to see if anyone else has worked o… -
OTBI Direct & Indirect Headcount #'s by managerSummary Is there an OTBI/Non-Sql means to extract this data?Content What I'm looking for is a way to capture both direct and indirect manager numbers. I.e., if you're a … -
How to replace DATA_CACHE with XML_DATA_CACHE syntax in Oracle BIP Data Models?Summary How to replace DATA_CACHE with XML_DATA_CACHE syntax in Oracle BIP Data Models?Content Hi Experts, We came to know that Oracle deprecated 'DATA_CACHE' column and… -
Combining Oracle HCM and data from external sourceSummary How to create a data model for BI report using combination of Oracle and external dataContent Hello All, I need to generate a CSV file, to be sent periodically t… -
BI excel template xsl when otherwise tags giving data in different format with extra spacesSummary BI excel template xsl when otherwise tags giving data in different format with extra spacesContent Hi All, In one of the custom BI report we are using excel temp… -
Table and Column for Override Average Weekly Earnings field on Maternity LeaveSummary Table and Column for Override Average Weekly Earnings field on Maternity LeaveContent Hi Experts, We have a requirement to fetch the Override Average Weekly Earn… -
Managing privileges for AgentSummary Schedule an AgentContent Hello Everyone, Does anyone know which privilege from the list below removes the access from users to Schedule Agents? Thank you, Alvaro… -
BIP Report Scheduling IssueContent Hi all, I'm currently in the process of scheduling the reports we've built using BIP data models, but we've noticed that all schedules that I've created only sho… -
OTBI analysis for Performance rating #Content Hello, We have a requirement to develop an OTBI analysis that gives the count of employees for each rating in a particular department. I am using the subject are… -
Restrict to run reports for delivered Employee RoleSummary How to restrict with delivered Employee Role to run reports from BIContent Hi Experts, We have noticed that general Employees have access to run reports (like Pa… -
Behaviors tagged under each competency in Talent profileContent Hi, Can someone help me with the database table where we get the Behaviors tagged under each competency? Regards, Nivya -
OTBI analysis for Performance rating #Content Hello, We have a requirement to develop an OTBI analysis that gives the count of employees for each rating in a particular department. I am using the subject are… -
OTBI layout performance tile how can i make the square border thicker?Summary OTBI layout performance tile how can i make the square border thicker?Content Hello We have an OTBI with layout of a sum displayed in a ‘performance tile ‘. The … -
Pivot Report - Have a heading and change value sequenceSummary How to change value sequence and have a label in pivot report?Content I have created an OTBI report with pivot output. On left side is the desired output and on … -
How to customize CSV output using BI PublisherContent Hi, We are in the process of creating outbound interfaces from Fusion to another system. To that purpuse we uses reports created with BI Publisher and the output… -
OCI – HCM Analytics: Getting Started With Oracle Fusion HCM Analytics, 23 March 2021, 9 a.m PT - SubContent Submit your questions for the OCI – HCM Analytics: Getting Started With Oracle Fusion HCM Analytics session to have them answered during the live event. Post you… -
OTBI how to round up a number with decimal points to be without the points?Summary OTBI how to round up a number with decimal points to be without the points?Content Hello, In OTBI report, there is a field based on sum of FTE , which may includ… -
HEX values for seeded pie chart colorsSummary HEX values for seeded pie chart colorsContent I have built a pie chart for Performance ratings for a Dashboard. The systems default to 3 colors - Yellow, Blue an…User_2025-02-10-08-27-16-805 20 views 2 comments 2 points Most recent by User_2025-02-10-08-27-16-805