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
-
Report of dependents enrolled in each planSummary Report of dependents enrolled in each planContent Hi, trying to find a report that displays the benefit plans where each dependent is enrolled. So for an employe… -
Subject Area for Onboarding TaskContent Hi All, Is there a subject area to pull the data from the Me-->Quick Actions-->Onboarding Tasks for the pending workers. I tried using the subject area: Workforc… -
BI Publisher - CASE WHEN returns correct value on Tree View OnlySummary CASE WHEN is returning the correct value when I view the data in tree view e.g. Home or Mobile etc on BI Publisher but when viewed on table view the database val…
-
Link to most recent scheduleContent All - In BI Publisher reporting, is it possible that we are able to provide a static link to the most recent scheduled report? I have a report that is run daily … -
Worker Assignment Event - Created ByContent Hi, I am interested in finding out which user created the assignment event. I get the user "FUSION_APPS_HCM_ESS_LOADER_APPID" created this. How would I find out …User_2025-02-01-04-05-22-904 56 views 9 comments 0 points Most recent by User_2025-01-28-16-10-52-033 -
Time and Labor Manager SecuritySummary Time and Labor Manager Security includes BI Author SecurityContent Hello, Does anyone know why the Time and Labor Manager - Line Manager Security Role includes B…User_2025-01-28-20-36-10-715 39 views 4 comments 0 points Most recent by Raghavendra Raghunath-Oracle -
Joining Recruiting and Checklist subject areaContent Hi All, I have a requirement where I need to get the details of the pending worker in HCM, but I also need the Candidate ID. My question is how to join the follo… -
Citizenship FieldContent Hi Guys, I don't able to find the field "Citizenship", some one know in which subject area can I find it? Best Regards Giuseppe -
Subject Areas - Seniority Dates and Per Periods of ServiceSummary Subject Areas - Seniority Dates and Per Periods of ServiceContent We are wondering if there is a subject area, or an enhancement to allow for analysis to retriev… -
Pull date from prior rowSummary performance task number of days spentContent The start date in this is an excel field I manually created. Essentially, as people move thru the performance review… -
Custom Field in report with more Subject AreasContent Hi Guys, I have to create a report with some custom fields, but I need some fields that are in another subject area. When I have been inserted the other subject … -
Hiding the 'Export' option on custom analysesSummary I am looking for guidance on how to disable to the ability to export an analysisContent Hello, I am hoping for some guidance on the steps I need to take to disab… -
Person running report not showing up on reportSummary Inaccurate dataContent I've created a few different report and I've found that when I run the report my data is not on present. This causes issues for our payrol…User_2025-01-31-00-25-12-234 47 views 10 comments 0 points Most recent by User_2025-01-31-00-25-12-234 -
Need BI SQL to fetch previous row assignment and salary details of employeesSummary I need to fetch previous row details based on latest row effective end dateContent In My BI Report, if i passed effective end date as a parameter , then employee… -
Need Header even No Data returns on BI Publisher output (CSV)Summary Header is not coming in BI report when No Data returns (CSV)Content In My BI Report, I am passing date as a parameter. When No Data Returns for date parameter, H… -
CASE Statement Future Termination DatesSummary Trying to show future termination dates as blank in active reportContent I have an all ee report. One of the fields is termination date. if someone has a future … -
Embedding BI Publisher Report on DashboardSummary Embedding BI Publisher Report on DashboardContent Hello, Looking for a better way to display an embedded BI Publisher report in a Dashboard. The views between BI…User_2025-01-28-20-36-10-715 136 views 7 comments 0 points Most recent by User_2025-01-28-20-36-10-715 -
Reporting on Employee Schedule ChangesContent Hi, Has anyone built reports around employee schedule changes? For example, if a manager goes into Time Management > Manage Planned Schedule and changes the sche… -
Failed notification messages on providing a wrong email addressContent Hi All, We are developing one BIP report where we have utilized the bursting option to send an email to employees based on certain changes. Currently, we are sen… -
Nesting Case statements?Summary Is it possible to nest Case statements in otbi?Content I am working on a recurring report that requires me to classify people based on certain characteristics. I… -
BI report based on HCM extract outputSummary BI report based on HCM extract outputContent Hello experts, I have a requirement of creating a BI report based on ' HCM extract output which is set as Changes On… -
Manager Self Service MetricsSummary Manager Self Service MetricsContent I would like a report that displays metrics on how often managers are initiating employee data changes in Oracle. Also, I wou… -
Active User Name Flag (Terminated Employee or Active Employee)Summary Does OTBI provide an Activated User Flag?Content We have a requirement to provide an audit report in HCM that shows any active HCM user accounts for terminated e… -
Audit Document Records AccessContent Hi experts - hoping you can help with an OTBI or BIP audit report. I have the tables needed to run a report on what documents exist in the Document Records secti… -
Create performance titleContent Hi Guys, How i can realize a performance title that show the Learn Count for each plan cycle name? Best Regards Giuseppe -
Is it possible to get Previous/Prior Salary Frequency from OTBI Subject areas?Summary Is it possible to get Previous/Prior Salary Frequency from OTBI Subject areas?Content Hi Team, Is it possible to get Previous/Prior Salary Frequency like Annuall… -
Sub Folder for Requisition field in Workforce ModellingContent Hi Guys, I'm creating a proof of concept for the reporting that can be done out of the workforce modelling area and can't seem to locate the field 'Requisition'.… -
Subject area for Work StructuresContent Hi, For getting all jobs,departments and position information what is the suitable subject area please ? Thanks -
How to get Phone number, Email Address, Home Address and Bank details old values using BIP ReportSummary How to get Phone number, Email Address, Home Address and Bank details old values using BIP ReportContent Hi Team, We are creating new HCM BIP Report to Fetch the… -
Table to get the currency listContent I need to find a table to get the currency list maintain in manage currency task.' And I could not able to find in Tables and Views page. Appreciate your ideas.