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 Distinct for OTBI reportsSummary We want to see only one result for specific areasContent Hi All, I have one report about absences and balances which belongs departments. We used Sum for some sp…User_2025-02-04-18-26-11-309 1.3K views 6 comments 1 point Most recent by User_2025-02-04-18-26-11-309 -
Analysis of seeded HR dash boardContent Hi Team, Can any one know where to find the analysis of seeded HR dashboard ? We have checked all the folders in reports and analytics. -
Recreating HR dash boardContent Hi Team, Since the HR dash board willnot availabe after the latest patch, We are recreating it. We are facing following issue, 1. In one of the choice list "maxi…
-
Global Transfer ReportingContent Hi all - we have come across an issue for reporting that we need your expertise on. Recently, we found that a Global Transfer action-action reason can be correct… -
Reporting on Approval TransactionsSummary Trying to report on pending transactions to pull the data from the notifications onto one report. Struggling to find tables to show Current and Proposed Values a…
-
Query to get active and active uses in the systemSummary Query to get active and active uses in the systemContent Query to get active and active uses in the system.We have Crosse verified the per_users table but didt g… -
Analyzing use of reportsSummary Any way to get analysis on who is using what reportsContent Hello, We are trying to assess which of our reports are being used most often by our end users (HR an…
-
Query/Table to view BPM commentsSummary Query/Table to view BPM commentsContent Hello All, We have requirement to capture the Approver comments in a report. Let us know if you are aware of table/query … -
Manager Assignment vs Worker Assignment in OTBISummary Manager Assignment StatusContent Hi Team, I know there are a few Manager's information fields available in OTBI but I could not find Manager Assignment Status, f… -
Loan 401K Accrued BalanceSummary Trying to find where the Loan 401K accrued amount is stored in OracleContent Hi, We have a number of 401K Loans and due to the way we process thru our vendor we …
-
How to link Data Sets belonging to different Data Sources in Oracle BI Publisher in HCM CloudSummary Approach to link data sets created from WebServive and SQL Query Data SourcesContent Hi All, We have a requirement to build reports on data from external data so…
-
Hyperlinking BI Publisher reports in a DashboardContent Hello, We have a requirement to create a dashboard which will list all the reports available for certain user popluation. As per screenshot you can see that we m… -
Report for staff eligible to performance document without goal enteredSummary Report on staff eligible to performance without goalContent Hello Does anyone has a report that would filter the eligible staff to a particular performance docum…
-
How do I report on only the most recent assignment (active or terminated)?Summary I need to build a report of all employees and only want the most recent assignment to appear on my report.Content Hi all, Does anyone know how to report on all t…
-
Top Manager field not populatedSummary Some employees are missing a Top Manager so they don't appear on reportContent Does anyone know how the Top Manager field gets assigned? I pulled it into a repor…
-
Managers on a Leave of AbsenceSummary Managers on a Leave of Absence reportContent Hello, I am trying to create a report that will show managers, the managers Assignment Status (to be used to determi… -
HCM Cloud OTBI Workshop at Oracle ParisContent In the last few years we have been running a popular HCM Cloud OTBI Workshop in EMEA to help customers get the most from their investment in HCM Cloud. We plan t… -
OTBI Conditional Formating - Color Coding Not workingContent Hello everyone, I have created passport details report. This report contains field Passport Expiration Date. I would like to color cells where expiration date is…
-
Need new table names to pull calculation card detailsSummary Need new table names to pull calculation card detailsContent Hi Team, i am looking for the table names/query to pull the calculation card details like Federal , …
-
Prompt Search Edit functionality for BIP reportsSummary How to achieve the prompt search edit functionality for BIP reports similar to one available in Analysis ReportsContent How to achieve the prompt search edit fun…
-
Element result report - explanationSummary How the Element result report is designedContent Hi All, Can anyone elaborate me how the Element result report is designed. I am able to understand the Extract's…
-
How to adjust default selection in Line manager dashboardSummary Change default selection in Line manager dashboardContent In the Line Manager Dashboard by default one BU is marked. I want to change this to 'All'. I have copie…
-
Bypass report securitySummary bypass report securityContent Is there a way we can bypass user security when setting up a report? We have created some workforce KPI dashboard reports for a sma… -
Direct Report - OTBI Report CatalogContent Hello from Columbus, Ohio! Does anyone have a nice Direct Report with Managers and Direct Reports listed? I'm looking for an .xml catalog file that I can share i…
-
Which Subject Area holds the EmailAddressIdContent Could anyone tell me which subject area I can find the EmailAddressId? I need this to update email addresses through Data Exchange for the full version of HCM Da…
-
Legal Employer Hire Date in OTBI ReportContent User is creating OTBI report using subject area "WorkForce Management - Work relationship Real Time" subject area. But user is not able to find any column for "L…
-
Tables for getting user information under Security consoleSummary Query to get security console User infoContent Hi All, I am developing a BI Publisher report to get the User information that is available under Security console…
-
BI PUBLISHER FORMATING DATEContent I am developing a report in BI publisher (using rtf template) and we need to show the current date as just 3 letters of the Month name and year. eg: If the date …
-
Users Preferred Timezone reportSummary Listing timezones set up in User's preferences by UserContent Hello Everyone, I found this script in one Oracle Support documents but I can't run it as it is sho…
-
Changing Date Format at ReportSummary We can not change date format as we want to see.Content Hi All, You can see in below screenshot that we have date format at report column. We can only choose 3 o…User_2025-02-04-18-26-11-309 62 views 5 comments 3 points Most recent by User_2025-02-04-18-26-11-309