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
-
OTBI Reports over Payroll DataSummary We experience terrible performance when we run OTBI reports over subject areas such as Payroll Balances Real TimeContent The OTBI reports tool is struggling to p… -
Analytics Dashboard section header and report link font formattingContent Hi All, I have embedded dashboard on homepage, which has report hyperlinks and section header displayed. I have managed to change the background color same as ho… -
BI Publisher Bursting Real Time Notification/TriggerSummary BI Publisher Bursting Real Time Notification/TriggerContent Hi experts! I need to create and send an email notification whenever a person has enrolled or complet… -
Need to create a report that will extract data which doesn't have costing options enabled at departmSummary Need to create a report that will extract data which doesn't have costing options enabled at departments, jobs, positionsContent Hello Everyone, We have requirem… -
Bursting Report With Multiple AttachmentSummary Bursting Report With Multiple AttachmentContent Hi Team We have a requirement to attach multiple document using busting query, How to add multiple attachment in … -
Timezone used by time parameter is always in GMT. How can I let user pick the timezone when enterinContent I have a BIP report with a parameter with a time component (It is a date type with a date string of" MM-dd-yyyy HH:mm:ss am"). What I am noticing is that date en… -
Using Headcount Values in Reports and DashboardsContent I am trying to use headcount values in reports and dashboards, but the values are not lining up correctly. I know how to load the assignment work measure via HDL… -
Job and Grade Rate OTBI ReportContent Hi, I have created job families and different jobs under each job family. Each job has been mapped to a grade, which is in turn mapped to a grade rate. Therefore… -
In which report Enterprise name along with organization structure is displayedContent Hi Team, Do we have any report which displays Enterprise name alone with org structure details like Enterprise, division and so on. Kind Regards, Rahul -
Require a report to show when a Primary Mailing Address is missing in the systemSummary It was noted with our T4's this year that an employee received his T4 with an incorrect Primary Mailing Address - when we look in the system, the Primary Mailing… -
Help Performance Section info Cannot Coexist with Overall RatingsSummary I get an error when I put section rating and overall Ratings togetherContent Hi All, I created a report that shows Overall Manager Rating but when I try to pulli… -
Displaying Dashboard to Welcome ScreenContent Hello All, We have been able to successfully add the Dashboard to the Welcome screen in a Sandbox with Page Composer. What we are running into now is any user no… -
Adding run_result_values for multiple element_names in OTBI analysisSummary Need help in OTBI analysis with adding the run_result_values for different element_namesContent Hello Everyone, I am new to OTBI analysis and I need help with co… -
Error when joining subject areasSummary Receving "View display error" when trying to join subject areasContent I'm trying to make an analysis where I need information from the subject area "Workforce m… -
OTBI Reporting Leave Begin DateSummary Displaying actual Leave Date or the date when the employee returned to workContent Hi All, Need some help with an Analysis that I have built to show employees th…User_2025-02-04-08-51-08-912 50 views 4 comments 0 points Most recent by User_2025-02-10-19-46-17-403 -
How to display embedded dashboard only on a custom page categoryContent Hi Team, I have embedded a dashboard on homepage springboard. Now that dashboard is embedded to all tabs of the springboard. 1) Is there a way to embed it only t… -
Distribution of completion per day - OLCContent Hi there I want to create a graphic and/or possibly pivot table for the following. I have a number of people who completed a course. Here is the idea MR. A - com… -
Trend report for Disability and Sexual orientationSummary incorrect calculations when trend subject are is joined with Person real Time Subject are.Content HI, I am having a requirement to show the trend of sexula orien… -
Getting double results in OTBI for learning completionContent Hi there, I am using the Completion Count, Overdue count and Not Started count from Learning Records Real Time to create a performance tile to show these figures… -
Need Help : 9 BOX Talent ReviewContent Hi Expets, I have been looking catlog or some kind of link form which we can build or design 9 BOX Talent Review. Tried in different sources and not able to find… -
Date and Time Generated in an OTBI Report or Dashboard with No ResultsContent Hi there, We have a few OTBI Analyses that are combined into a Dashboard and the Dashboard is then scheduled to be emailed on a bi-weekly basis. The ask is to in… -
Post 21B release HRC_TXN_DATA.Data cache column doesn't show XMLSummary Approved/Rejected Global transfer transaction XML data is not coming up in HRC_TXN_DATA data cache column.Content Hi All, We are aware of HRC_TXN_DATA data cache… -
SQL to Pull Most Current Ethnicity recordSummary Looking for BIP Data Model that will select the most current EthnicityContent Hi, I am creating a data model of person information and have been challenged when … -
Briefing Books FunctionalitySummary Briefing Books FunctionalityContent Hi All, I would like to know the briefing books functionality, Please share the briefing book document or session video if an… -
Tile in Fusion for Managers to directly take them to their Manager ReportsContent We are trying to figure out if it is possible to create a tile in Fusion for anyone with a Manager role to have a tile to take them to our Manager Reports folder… -
DATA_CACHE column deprecation from HRC_TXN_DATA tableContent We are currently on Oracle HCM Cloud 20D. We have a scenario where we need your suggestion/feedback. Oracle is deprecating DATA_CAHE column from HRC_TXN_DATA tab… -
Retrieving Affected Party column in HRHDContent Sharing the data model for reference and for others to benefit. This column was unavailable in OTBI at the time the report was built. -
Mail Merge TemplateSummary Create a document that will populate certain fields directly into the documentContent Looking to create a document i.e. VOE that will grab and populate the data … -
Calculating Month difference between DatesContent Hi, I have Data looks like bellow . Emp No. Occurrence Partnership Level Partnership Level Date Months Difference 1 1 Level1 1/1/2006 Months (12/1/2007-1/1/2006)… -
Report Recipient's list ReportContent Hi All, Is there any way to get Report for all recipients list. Recipient Name Report Name Frequency abc Report1 Daily xyz Report 12 Monthly Thanks, Vijay