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
-
Employee change address reportContent Hello, we are looking to create a report that show changes to an employee address for that month, and to see there old address on the report as well. We want to … -
Hire Date/Enterprise Start Date for Global TransferSummary How to best track original FTE hire date in the system and pull accurately on reportsContent Hi everyone, My question is around the Hire Date field and/or Enterp… -
Goal report not working for managersSummary Created a Goal Details report. Admin can view. Manager gets an error.Content I have created a Goal Details report using the "Workforce Goals - Goal Status Overvi…User_2025-01-28-20-43-56-568 43 views 6 comments 0 points Most recent by User_2025-01-28-20-43-56-568
-
New Hires Missing from OTBI ReportContent Hello - I am trying to pull a report each morning that shows the new hires and rehires for the previous day. I noticed that the numbers seemed low, so I went bac…User_2025-01-31-00-06-53-133 58 views 2 comments 0 points Most recent by User_2025-01-29-23-59-58-976
-
Business Objects can't delete using HDLSummary Business Objects can't delete using HDLContent Hello Experts, After loading data via HCM Data Loader into the systems, what are the objects we can't delete via H… -
Prewritten Performance ReportsSummary Prewritten Peeformance ReportsContent Hi. I am brand new to this site. Can someone direct me to any free or preloaded performance reports to help get me started.…
-
OTBI Cross Functional Subject Area Reporting Error!Summary OTBI Cross Functional Subject Area Reporting Error!Content Hi All, I am trying to report against the following Cross Functional Subject Areas, Compensation - Sal…
-
OTBI Report Limited to Excel SheetSummary How do I report on person numbers from an Excel SheetContent Hi all - I have a list of 2K+ Person Numbers in an Excel Sheet. I need additional data about these e… -
How to retrieve dependent information of an associateSummary trying to get the information on dependent but it is empty.Content Hello everyone I am trying to do a report to show the dependent of an associate in OTBI, using…
-
Merged ColumnsSummary How to prevent merged columns in reports?Content Hi Everyone, I noticed that some of our reports come out with merged columns, which always throw off our sorting…
-
Issue viewing Payroll DataSummary Payroll Data not showing up due to a Role issueContent Hi All, I am unable to see any Payroll related data while trying to report against OOTB Payroll Subject Ar…User_2025-07-18-02-05-33-261 86 views 3 comments 0 points Most recent by User_2025-07-18-02-05-33-261
-
BI Folder: limit visibility only to specific application roleContent Hi all, I'm trying to understand how to limit the access to the 'Custom' folder under Shared folders -> Custom to only 1 specific Application role. We have enabl… -
UNION promptsSummary Want to add to a report that is built on UNION a AsOfDateContent We have a report built on a UNION. We want to add the option to enter a prompted As of date and …User_2025-01-30-04-37-05-780 106 views 3 comments 0 points Most recent by User_2025-01-30-04-37-05-780
-
Can we download the attachments from BPM tables wfattachment?Summary Create hyperlink to download the attachments from BPM table wfattachmentContent Hello Experts, I am trying to generate a report with the approval transactions an… -
MAX formula with CONCAT calculated measureSummary Difficulty getting the formula to workContent The way our Talent Review Meeting's were created we were forced to use flexfields to store the data. So to include …User_2025-01-28-08-47-04-905 58 views 12 comments 0 points Most recent by User_2025-01-28-08-47-04-905
-
success criteria with html balise in bi publisherSummary How can I delete the html code in success criteria column in bi publihserContent Hello, I want to delete the html balise for the column success_criteria from the… -
calcul division , result wrong OTBISummary result of Division of sum (measure ) /sum(measure ) is not goodContent Hello , I want to calculate the percentage of headcount by competency So I have the number…
-
BI Publisher Reports Time zone IssueContent Hi, I developed a report in BI Publisher, however, we found that the 'Date' information such as Termination date, Hire Date, etc. on the report were not consiste…User_2025-01-29-01-38-21-058 441 views 5 comments 0 points Most recent by User_2025-01-29-01-38-21-058
-
Historical assignment changes tracked in OTBI reportContent Hi Looking for some help regarding the issue below: When reporting on an employees’ record, we cannot see time tracked data in an OTBI report when we make the fo…
-
Need to count by hierarchy level only the managersSummary Need to create an OTBI analytic which will count from level to level only the manager not the ICsContent Hi all, I was able to create an analytic which shows alr…User_2025-01-23-22-38-50-675 71 views 4 comments 0 points Most recent by User_2025-01-28-20-24-47-566
-
Duty Roles Required to Access OTBI Subject AreasSummary Looking for the Document that lists Duty Roles Required for each Subject AreaContent I thought I had this document saved, but now I can't put my finger on it. Pl…
-
Donuts instead of PiesSummary Is it possible to output Donut charts instead of pie charts?Content Most modern dashboards contain at least one donut / doughnut chart. Few contain pie charts an…
-
Duplicate Rows; Multiple lines of dataSummary My report is spitting out multiple lines of the same data; trying to find a way to consolidateContent I'm building a report that will serve as a validation/audit…User_2025-01-28-20-40-07-753 161 views 8 comments 0 points Most recent by User_2025-01-28-20-40-07-753
-
Top N querySummary Filter top 5 leaving reasonContent Hi, I want to create a report that shows the top 5 reasons of leaving (e.g. 'found another job", "Low salary" etc.). I know wh…
-
Assignment Audit ReportSummary Looking for a report that includes Updated, Corrected, and Deleted AssignmentsContent Hello, I am searching for an existing report or a way to report an audit of…User_2025-01-28-17-24-53-863 204 views 4 comments 0 points Most recent by User_2025-01-28-17-24-53-863
-
OTBI - Double to string conversionContent I am creating a report having a column for "Initialized Balance". I need to show '-' if value is null otherwise show the value. When I use like this IFNULL(CAST(…
-
HCM Extract Delivery Options - WebCenter ContentSummary HCM Extract Delivery Options - WebCenter ContentContent Hello Experts, I am working on HCM Extract delivery options - WebCenter Content! Does anyone aware of the…
-
Salary basis for future hireSummary Using the Compensation - Salary details real time don't see salary basis for future hireContent We need to get the salary basis for new hires, rehires, etc. For …
-
How to Calculate Annualized TurnoverSummary How to Annualize TO %Content Hi We are interested in adding annualized TO % to our current TO reporting. I have written a formula that returns the correct annual… -
Active Employees in a QuarterSummary How can I find Active Employees in a particular Quarter.Content Hi, Current I am using Assignment event real time subject area. I can pass 2 dates one start date…