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
-
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…
-
Joining Workforce Management & Expenses Subject AreasSummary Seeking to merge details from Expenses subject area in to Workforce Management reportContent I have multiple HR-centric reports the draw on the Absences, Compens…
-
Calculated Sum of Gross paySummary need a new calculated value say Semester 1 (Jan-May) and Semester 2 (Aug-Dec). It should return the sum of the gross pay for all the pay periods falling under Ja…
-
Definitive solution for Error 500Summary Forget Accounts toolContent Hi All, When a user id gets changed in Fusion Applications, the subsequent login for accessing of the BI application (Reports & Analy… -
Logical SQL - adding column selectorSummary Is it possible to add a "column Selector" to a Logical SQL report?Content Hi, I am trying to add a "column selector" to a logical SQL report. I would like to giv…
-
Values Based on custom SQLSummary Values Based on custom SQLContent I would like to display the Data for last 4 years based on data from initial setup. Eg : Need to display value 100 for each of …
-
Get a list of languages for people in the systemContent Hi, We have 10,000 people in our HCM instance. How do I bring back each individuals language skills So given a suffix or a person_id, I want to bring out the fol…