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
-
Sample Report: Workforce Compensation Budget Subject AreaSummary Workforce Compensation Budget Subject Area by levelContent Workforce Compensation Budget Subject AreaThis is part of a series of sample reports to use in your cl… -
Performance Tile and Change ViewSummary Performance Tile and Change ViewContent Is it possible to create a performance tile infolet - let's say for Employee Headcount and then include a Change View sel…User_2025-02-04-10-47-55-876 61 views 2 comments 2 points Most recent by User_2025-02-04-10-47-55-876 -
Embedded analytics in HCM Pages and the new responsive UISummary We have been using embedded OTBI reports in pages for employees and managers in self service but the new UI does not seem to allow for new boxes to be added to e…User_2025-02-04-05-34-39-836 174 views 10 comments 2 points Most recent by Prateek Parasar - GTUK, ACE Pro
-
Is it possible to insert SQL into OTBI reports to pull correct version of Enterprise Seniority Date?Summary Is there a way to pull in a small piece of custom SQL to pull the right version of Enterprise Seniority Date into our custom OTBI reports?Content We know we want…
-
Infolet for Personal InformationContent Good Day All, i have created numerous infolets in the new UI and all work fine. One of the infolets is for Length of Service. Now if you are a Line Manager you w… -
Person Address HistorySummary Need to pull all addresses for specific personsContent We are finding all sorts of errors with our addresses; no end dates, multiple addresses of same type I am …User_2025-01-23-21-24-21-434 293 views 5 comments 2 points Most recent by User_2025-01-23-21-24-21-434
-
How to get the manager's manager name in OTBIContent Hi, I got the employee manager name in OTBI subject area's and we need manager's manager name in OTBI. Please let me know the presentation table and column for t… -
Burst to Documents of RecordSummary BI publisher report bursting to DoR possible?Content Hey, We would like to create a BIP report (containing the approved notice period and other relevant data) in… -
Missing TimeCards ReportSummary Missing TimeCards ReportContent Hi Experts, Anybody developed Missing Timecards BI/OTBI Report. Could you please share the report. Thanks Thiru -
Data Model Validation ResultSummary SQL query contains non-equi joinsContent Hi Guys, I am in 18C and I am getting the following warning message in Data Model: WARNING Dataset:LOV_Emp_Name SQL quer… -
Reporting Questions (HCM data)Summary Reporting Questions (HCM data)Content Have 2 reporting related questions: 1. Which reporting tool (OTBI or BI Publisher) do you train your business users on? The… -
Integration or Report ScheduleSummary Integration or Report ScheduleContent Hi experts, please provide steps for canceling schedule of hcm extract integrations. And how do we check weather if BI Publ…
-
"Questionable" URL link from Absence DashboardContent Morning Experts, Really hoping someone can shed some light on this bizarre issue. We have the standard Oracle OTBI dashboards within our Production environment a…
-
Table name for department history of employeeSummary Table name for department history of employeeContent Hi All, May i know the any other table name which tracks the department history of employee except per_all_a… -
How to sort Payslip reprinting report?Summary Need to know how to add a sort order to a RTF templateContent It is suggested in the following Oracle support note to customize the payslip template to achieve a… -
Subject Area for Employee roleSummary Subject Area which Employee role has access, and employees can see their LE and LOCContent Subject Area which Employee role has access, and employees can see the…
-
Languages for a personContent In SQL, which table(s) would I need to look at to get the following data for a person? * Language * Speaking Level * Writing Level * Reading Level * Sign Level T… -
Termination date for Rehire employeesSummary Termination date for Rehire employeesContent How to display termination date for rehire employees in OTBI report. We want only the latest assignment record to be…
-
Current Leave Balances and impact of Future Leave BookingsContent Hi All The sample report attached is a visual representation of two interacting elements: Current leave balance (up to the balance calculation date) and Future B…User_2025-01-30-03-53-16-644 84 views 3 comments 2 points Most recent by Raghavendra Raghunath-Oracle
-
Employees with Work NumbersSummary Return report for all employees and just list work numberContent Trying to build a report that lists all employees and in the phone type column only return Work …
-
Count the number of employees per FTESummary Report which present the number of the employees per FTEContent Hi, We tried to create an analysis that count the number of the employees per FTE (Full-Time Equi…
-
Best Practice for reporting team to prepare for Oracle Monthly/Quarterly PatchesSummary Best Practice for reporting team to prepare for Oracle Monthly/Quarterly PatchesContent Hello! We are a team of OTBI and BI Publisher users, new to Oracle HCM. I…
-
Trying to create a custom role for BI Consumer (Read Only)Content Dear Community, We have a question regarding the OTBI security : we usually give a read-only role to the dashboard to our line managers (role details in attachme…
-
Connecting Fusion to TableauContent Hi all - Is it possible to connect our Fusion HCM & OTAC instances to Tableau to do more graphical reporting? I know that I've read it might be possible but no r… -
BI Report: usage of fnd_sessions table first_connect and last_connect to track login time of usersSummary BI Report: usage of fnd_sessions table first_connect and last_connect to track login time of usersContent Hi, We have a BI report developed to track the login ti… -
Email a Link to Report Output Instead of Using AttachmentsSummary Can a hyperlink be sent to a user which will take them to the report outputContent Is it possible to send a hyperlink to a report's output rather than sending th…User_2025-01-30-00-59-25-861 72 views 3 comments 2 points Most recent by User_2025-01-23-21-24-21-434
-
BI Folder Structure: R12 vs. R13Summary BI Folder Structure: R12 vs. R13Content We're testing our recently upgraded pod and noticed that the folder structure that shows in Reports and Analytics is very…User_2025-01-25-02-53-28-953 51 views 5 comments 2 points Most recent by User_2025-01-25-04-02-13-126
-
New Hire NotificationsSummary Daily notifications of new hires created the previous dayContent Hi everyone - We are trying to create notifications of new hires created daily using analysis an…
-
BIP Publisher BurstingSummary BIP Publisher BurstingContent Hi, Is it possible to give multiple email addresses in the TO parameter of bursting definition sql query in Oracle Fusion HCM BI pu…
-
Future Dated TerminationsSummary Future Dated TerminationsContent Hello, Does anyone know of a way to pull in action codes that are future dated? When I run the analysis, I can pull in people th…User_2025-01-30-00-38-09-143 74 views 3 comments 2 points Most recent by User_2025-01-25-02-35-56-629