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
-
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 43 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
-
Do we have any report to see configured Approval Rules?Content Hello, We need a list of all HCM related processes for which approvals are configured in system. Do we have any report or query through which it can be extracted…
-
Candidate and questionnaire JOIN BIP reportContent Hi,How to join the questionnaire and answers to a specific candidate in BIP.does anyone have a working SQL that can share ? Thank You
-
Workers Compensation wage reports neededSummary Looking for recommendations and examples of reports related to Workers CompensationContent Our team that administers our Workers Compensation programs has not fo…
-
Bank Account UpdatesContent I was wondering if anyone had a report that was able to pick up changes to bank account information? We currently have a report that pulls the last update date o…User_2025-01-31-00-25-12-234 134 views 4 comments 0 points Most recent by User_2025-01-31-00-25-12-234
-
Count of attribute column in Learning Real TimeContent Hi there I want to have a count of an attribute column in Learning Real Time. For instance, I have a table with the names of the users and a course name. I want …
-
Need help with BI publisher reportSummary Need help with SQL for BI publisher ReportContent Hello, I have a BI publisher report that is run at the end of every pay period to provide payroll information o…