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
-
HCM DeeplinkSummary Deeplink to view absence recordContent Has anyone created a deep link in a report to view an absence record? -
Splitting BI Report in multiple TabsSummary Splitting BI Report in multiple TabsContent Hi ALL, I want to split BI Report based on Person_type in Excel's 2 tabs. Employee will be in first tab and Others wi…User_2025-02-07-19-03-14-525 148 views 11 comments 1 point Most recent by User_2025-02-07-19-03-14-525 -
Payroll run Costing Results informationSummary We are trying to display Costing results information after Payroll ran.Content Hi All, We are able to get the Payroll run costing results through "Payroll – Payr… -
Custome Talent Profile Printing Sections that Employees Don't Have AccessContent We have created custom Skills and Qualification Print. First we have taken a copy of delivered RTF template and a copy of delivered data model and have created a… -
R13 20A - How to fetch the error messages from HRC_TXN_ERROR tableSummary Unable to get the failed error message reportContent We are creating a report to pull all the transactions that failed on a given day based on the issue date. We… -
How to report on 20A approval data comparison featureContent I am trying to report on the new data comparison feature that was released with 20A. I want to be able to capture all of the approvals that are open along with t… -
Turnover Reporting - Do you use Actual Termination Date or Termination Start Date (+1 day)?Summary Went live a few months back and have always used actual termination date for turnover metrics. Trying to gauge if companies are using that date and how they are … -
Difference between Workforce Management - Worker Assignment Event Real-Time and Workforce ManagementSummary Difference between Workforce Management - Worker Assignment Event Real-Time and Workforce Management - Worker Assignment Real-Time subject areas in Fusion HCMCon… -
Fusion Table to get % compatibility on Career PlanningSummary Fusion Table to get % compatibility on Career PlanningContent Hi Gurus, Is anyone knows if there is a SQL table we can use to get the Percent compatibility under… -
BI Report to fetch List of Scheduled Processes in Oracle HCM CloudSummary BI Report to fetch List of Scheduled Processes in Oracle HCM CloudContent As most of us might be aware by now that we cannot accommodate custom code (pl/sql prog… -
Fiscal CalendarSummary Has anyone built a fiscal calendar in OTBI? A 5-4-4 fiscal calendar.Content Has anyone built a fiscal calendar in OTBI? A 5-4-4 fiscal calendar. Our fiscal year … -
Calculated item for % assigned to courseSummary Learning DashboardContent I`m using a new calculated measure to work out the 'Capacity % Filled' for each of the courses but it won't calculate correctly. Any id… -
Subject area for last log-in by user reportSummary Is there a subject area where I can pull the last time a user logged in?Content There's been a request by a department in my organization to see what employees h… -
Cost Center Manager SQLSummary I require the table/link for the cost center manager fieldContent Hi I am currently creating a report that requires the cost center manager field for a departmen… -
BI Publisher Report not workingSummary Absence ReportContent Hi, One of our BI Publisher repots has stopped working, it hasn't been touched since last month when it successfully ran. Could it be that … -
User Sign In InformationContent We are looking to create some reports to extract user sign in information, ie. when and how often employee sign in. I've seen some old post that have some tables… -
Can you find what fields are used in reportsSummary With upgrade to talent, how can i find the reports that the using the old fields? -
Error when Editing Reports: Panel Div 'idView' not found in document oracleContent I've started receiving the error below when I'm editing reports. Has anyone seen this before? Panel Div 'idView' not found in document oracle Version 20AUser_2025-01-31-00-25-12-234 42 views 1 comment 0 points Most recent by User_2025-01-31-00-25-12-234 -
How to use FILTER USING function in edit formula in oracle otbiContent Hi All, Can anyone explain how this function FILTER(Column name USING() works in oracle OTBI. Regards, Shrey -
Checklist Configurable Form ReportingSummary Pulling data from configurable form in checklistContent What is the best way to pull dff's that make up the configurable form within a checklist? After the 19B r… -
Extract Month name in Oracle OTBIContent Hi All, Can we extract month name from any date by using any function in oracle OTBI. Except function monthname because it gives the month number not name. I wan… -
Email Trigger through OTBISummary Need Email to be triggered to IT department if any name changes happens in the 'Last Name' or 'First Name' through OTBI agentsContent Hi Team, we have a requirem…User_2025-01-23-22-36-48-692 242 views 6 comments 0 points Most recent by User_2025-01-31-00-25-12-234 -
Get AOR Type and Scope in OTBIContent Hi All, I want the Area of Responsibility Type name and Scope( Wheter it is Business Unit,Grade or Department) in the oracle OTBI Analysis. Please let me know th… -
Create Infolet icon is not available on homepageContent Hello Experts, I have enabled HCM Infolets tab in analytics section on homepage. However, I am not able to see Create infolet icon. I have seen couple of posts r… -
How to get list of past 25 years from current year in OTBI ParameterContent Hi All, We want to display the list of past 25 Financial years in the oracle OTBI analysis parameter which will be dependent on another parameter. We have 3 para…User_2025-02-07-13-49-29-960 108 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle -
Scheduling BI Publisher Reports With Parameter(s)Summary Scheduling BI Publisher Reports With Parameter(s)Content Hi, I want to schedule a report with Parameters. Ex. New Hire Report with "As of Hire Date" as parameter…User_2025-02-07-19-03-14-525 52 views 16 comments 0 points Most recent by User_2025-02-07-19-03-14-525 -
Printable Department Hierarchy chartContent Hi All, Can someone share a sample for department hierarchy printable chart? I tried with the link https://cloudcustomerconnect.oracle.com/posts/9510552320 ,But … -
All worker - active and terminated employeesContent Hi, i need to implement a OTBI report with all the employees, active and terminated. I started to work on it, but, as outcome the report havs also the old lines.… -
OTBI HCM Employee ReportSummary Required HCM OTBI database mapping with UI screensContent Dear All, I'm new to OTBI reporting. I need to create a employee report using OTBI and I'm unable to fi… -
Recruiting OTBI Report: Job requisition completed: phase and status of candidate selected brigs an eSummary I´m creating a report listing all job requisition in phase open with state complete, cancel or closed and we need to show the name of selected candidate if are. …