Get Started with Redwood for Oracle Cloud HCM Begin Now
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
-
List of employees that are LINE MANAGERSSummary List of employees that are LINE MANAGERSContent Employee Details that are Line Managers Hello Community, Could anyone share a sample report which will list down … -
All pre-built reports for HCM and FinanceSummary All pre-built reports for HCM and FinanceContent Where do I get full list of pre-built (OOTB) reports (OTBI and OBIA) for HCM and Financial? I got bits and piece…
-
Error Password Protecting Excel Templates in BIPSummary Trying to password protect BIP reports that were built using the excel add in, but incorrect file type is showing up.Content Hi all, I'm having some issues with …User_2025-01-31-00-25-12-234 40 views 2 comments 0 points Most recent by User_2025-01-31-00-25-12-234 -
Changes to 19b patch affected custom fieldsSummary Changes to 19b patch affected custom fieldsContent Hi all, We have custom fields under Workforce management - worker assignment real time > Location. After 19b p…
-
Employee Roster by Month Including Hours WorkedContent Does anyone have an example of a report that can be selected based on a begin/end date and list all employees with an active assignment for a specific department… -
Is it possible to create OTBI analysis that should reports person numbers for alternate Managers andSummary We are trying to create an OTBI analysis that should reports person number for alternate Managers and Line managers both.Content Requirement- Need to create an O…
-
19B Release causing report issuesSummary OTBI Report with Location GL field is breakingContent 19B released over the weekend. Noticed that reports that have Location GL field are causing ODBC error now.…
-
Learning Analysis Need Column for Last Job ChangeSummary Find the date the colleagues Job Title ChangedContent How do I add a field to an analysis for Learning Module that will show the correct date the colleague's Job… -
History of benefit element entry electionsContent Is there a way to report the history of a benefit element assigned to employees and the rate value (communicated rate value)? I am trying to find out what the em…
-
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…
-
Display dates in Hebrew language in BI Publisher RTFSummary How to display dates in hebrew in dd.monthname.yyyy format in BIP RTF TemplateContent Hi All, I want to display date in hebrew language in the format dd.Month.yy…
-
Area of Expertise - Subject AreaContent Hi, I am trying to create Skills and Qualifications report from below subject area. --Workforce Profiles - Person Profile Real Time I wanted to add "Area of Expe…User_2025-01-30-00-14-06-021 114 views 5 comments 0 points Most recent by User_2025-01-30-00-14-06-021
-
SQL query fetching Duplicate rows for terminated employees with pending worker recordsSummary SQL query fetching Duplicate rows for terminated employees with pending worker recordsContent I created a SQL BI Publisher report to fetch all active employees a…User_2025-01-30-21-52-52-008 259 views 18 comments 0 points Most recent by User_2025-01-30-21-52-52-008
-
PDF/A output is not working as expected in BI Publisher reportSummary How to set PDF/A output for a BI Publisher report in HCMContent Hi All, I want to set output type of a BI Publisher report as PDF/A as my intention is not to let…
-
Learning BI PublisherSummary What is the good starting guide for BI Publisher?Content What is the good starting guide for BI Publisher? -
Detail Compensation Bonus StatementSummary Need report detailing components of an associate's bonus payoutContent We are looking for a detail Compensation Bonus Statement report that can help us see at th…
-
OTBI reports for Individual CompensationSummary Are we planning to launch any OTBI reports for Individual Compensation? If yes, do we have an ETA?Content We have quite a subject area for Workforce Compensation… -
Multiple Worksite ReportingSummary I need a report that has the headcount for each work location over the last quarter and the gross wagesContent Hi, In our previous system, we have a report calle…
-
Department Tree - Father and two Child Levels of a Department in inputContent Hello everyone, I'm trying to create a OTBI Report to extract Father and two Child Levels of a Department given in input. Extracting the Father of a Department i…User_2025-01-31-00-30-34-540 86 views 2 comments 0 points Most recent by User_2025-01-31-00-30-34-540
-
Assigment History - Old Value and New ValueSummary How can we get old value and new value for Assignment History?Content Hi All, Is there any way to get old value and new value for worker's assignment changes? We…User_2025-02-04-18-26-11-309 192 views 3 comments 2 points Most recent by User_2025-02-04-18-26-11-309
-
Reporting on Worker Comp Change Statement ActionSummary Comp Change Statements can be enabled in ESSContent We need to know when a worker accepted/declined/signed statements that are shared with them in ECC. Is there … -
Remove formatting characters from text in Data Model reportSummary Reporting on a free-text field in a Data Model results in formatting charactersContent We have a report set up to capture employees "career statement" from Caree…User_2025-02-03-23-33-26-899 26 views 5 comments 0 points Most recent by User_2025-02-03-23-33-26-899
-
How to trigger the sending of a report with an action typeSummary Is it possible to trigger the sending of a report with the performing of an action?Content Hi, Is it possible to trigger the sending of a report with the perform…
-
Need subject area for cost center and companySummary Need subject area for cost center and companyContent Hi, I assign cost center and company values at department level . Now I want subject area for extract detail…
-
Headcount by Business Unit and locationsSummary Headcount by Business Unit and locationsContent Hi Friends There are a couple of reports in which we get Headcount by Business Unit and locations. We have around… -
Arrange Order and Delete Fields in Data ModelContent I'm dragging and dropping to change the field order in the data model but when I go to run the export, the fields are in the exact same order. I have saved it an…
-
Dynamic column generation - Reporting with BIP (RTF/Excel Template)Summary Need to dynamically generate columns based on the number of elements currently present in the ApplicationContent Hi, We are currently on Release 13 Oracle Cloud … -
Position hierarchy based on logged in person position in OTBISummary Position hierarchy based on logged in person position in OTBIContent Hi All, We are trying to get position hierarchy based on logged in person position. Suppose …
-
Reports Filtered by Action Approval/Completion Date?Content Hi All, Has anyone found a way to filter a term report or employee changes report by date the corresponding action was approved? For example; we send a term repo…
-
Tables to track employee activity to HCMContent Hi All, Can anyone tell us if there is a report,tables...or fields that we can use to create a report...to track if an employee has: 1) Attempted to login to HCM…User_2025-02-04-18-22-33-673 79 views 3 comments 0 points Most recent by User_2025-01-28-00-10-14-788