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 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 36 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 237 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 97 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 47 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. … -
Adding Prompts to BI Publisher Data Models that are based on OTBI ReportsContent Hello, We are implementing OLC and are making certificates in BI Publisher. To make it a little easier we've build the data model off an OTBI report, but we are …User_2025-01-31-00-25-12-234 104 views 2 comments 0 points Most recent by User_2025-01-31-00-25-12-234
-
OTBI : non-Fusion data sourceSummary Adding non-Fusion data source connection is not supported and will be deprecated in a future release.Content Got this message on the Admin page for data sources.…User_2025-02-05-23-02-10-916 35 views 10 comments 1 point Most recent by User_2025-02-05-23-02-10-916
-
Course training hoursSummary Learning DashboardContent Hi I am trying to pull through the training hours for the course against each of the offerings under the course, but nothing is pulling…User_2025-02-06-11-18-47-896 33 views 8 comments 0 points Most recent by User_2025-02-06-11-18-47-896
-
![Arun Kumar Krishnan [AK]](https://us.v-cdn.net/6034893/uploads/userpics/L8BUJDYF94E7/nTLGWFBWW678P.jpg)
OTBI Report for OTL - Subject Areas with Dimensions and NavigationsContent Dear Team, Kindly share the documentation / useful link for below details. 1. OTL - OTBI report with Subject Areas and Dimensions with Navigations. Thanks, Arun -
Question in the behavior of scheduled BI jobs.Summary How the scheduled BI jobs will behave during the Oracle monthly and Quarterly maintenanceContent During the Oracle monthly patch or Quarterly updates, how the sc…