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
-
How to remove Grouping of data in OTBISummary How to remove Grouping of data in OTBIContent I have Created a report to fetch the absence Entries for a Person.And in the Prompt i am using Start date column. i… -
Time card transferred to Payroll with success and failureContent Hi All, I am working on a report to get details of 1. Timecards transferred to Payoll. 2. Time cards not transferred to Payroll due to error and 3. Time card exc… -
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… -
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… -
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… -
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… -
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… -
Bulk fetch failed. (HY000)Summary While casting date in the filter criteria getting error for BulK Fetch Failed - OTBIContent Requirement - Service Anniversary report (Need to get the Employees d… -
OTBI Agent not sending some of the recipients emailsSummary OTBI Agent not sending some of the recipients emailsContent Hello, One of the recipients mails in agent - is not being sent , ALL other mails are sent . what cou… -
Security for BI Email NotificationsSummary securing a field on a notificationContent Is there a way to secure a field on the BI email notifications? For example, if we want only certain users to see the '… -
Calculations - level downContent I need to build three charts that hinge off one another: 1. Average or Median salary by Gender/BU/Management level. 2. From the chart above, I need to just get a… -
Is there any easiest way to find the Fact/Measure columns in OTBISummary Is there any easiest way to find the Fact/Measure columns in OTBIContent Hi Team, I am looking for the easiest way to find the Fact/Measure columns in OTBI inste…User_2025-02-04-07-00-18-658 234 views 6 comments 0 points Most recent by User_2025-02-04-07-00-18-658