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
-
Salary and Assignment Changes ReportContent Hi all - I am working on a few changes reports, and the next one we are working on is assignment changes AND salary changes. I am very comfortable with doing an … -
Report on Benefit Elections during enrollment periodSummary report on those who select an option before enrollment is completeContent Is there a way we can report on newly hired employees who have selected a certain benef… -
Need to find the Owner of the BI ReportSummary Need to find the Owner of the BI ReportContent I need to know the owner(who has created) the report for almost 85 reports.is there an easy way to do that. Or do …User_2025-02-05-02-11-29-794 29 views 5 comments 0 points Most recent by User_2025-02-05-02-11-29-794 -
Salary History As of Year EndSummary Salary History As of Year EndContent I have a requirement to display salary as of 31-Dec-YYYY (YYYY is the Year end date) . Am able to get the value based on Cal… -
Time Card Cost Center in OTBIContent I'm trying to fetch All Approved Time Cards where the Employee hours are charged to a different cost center than the employee home cost center in OTBI. Which Sub…
-
OTBI Union ALL Sort OrderSummary Need to sort the first union query using UNION ALLContent Hello, Just wanted to ask if there was a way to sort the first query created that is then UNION'd ALL w…User_2025-02-05-12-12-38-615 77 views 4 comments 0 points Most recent by User_2025-02-05-12-12-38-615
-
How to compare EE and Manager DetailsSummary OTBI report neededContent We are auditing some of our HCM data. We would like to compare an employee's department against their manager's department. Most of the…
-
Excel Template maximum row issueSummary Excel template maximum row issueContent Hi Team , We have created Excel template for one of our report but the number of lines getting exceeded 65536 , so the ou…User_2025-02-05-04-35-46-440 37 views 6 comments 0 points Most recent by User_2025-02-05-04-35-46-440
-
Calculating Hours for Salaried EmployeesSummary Requirement to calculate hours for salaried employeesContent We have a report requirement that fetches Earnings and Hours for all employees for each pay period. …
-
OTBI CASE Statement across Subject AreasSummary Attempting to write CASE IF statement for data across subject areas in OTBI and receive errorContent Business requirement is to write a CASE IF statement to popu…
-
Age BinsSummary Invalid Alias FormatContent Hi, I've copied a formula that calculates the age of an employee from the following Oracle video: https://www.youtube.com/watch?v=QpG…User_2025-02-05-22-44-35-842 26 views 5 comments 0 points Most recent by User_2025-02-05-22-44-35-842
-
How to get the classroom for an Activity learning item?Content Hi everybody, I should report the classroom for Activities but I am not able to get it. I don't find the link between the activity id and the classroom id (this … -
OTBI - How to download Archive file via web serviceSummary OTBI - How to download archive file via web serviceContent Hi, I'm considering to automate below archive process through web service. 1. Navigate to report path …
-
Unable to Export HTML Narrative View for OLC Learning CertificateContent Hello, I followed this post to create an Oracle Learning Cloud certificate in OTBI using HTML with the attached report and Narrate View code. It is displaying pr…User_2025-01-31-00-25-12-234 39 views 4 comments 0 points Most recent by User_2025-01-31-00-25-12-234
-
List of values as direct reportsContent Hi all, I am building a SQL repprt for the manager and it has a filter to show only direct reports in the list of values. How can I build to security to only dir… -
How to delete duplicated records in OTBI AnalysisContent Hello experts, I have just created a custom OTBI Anaysis by using Compensation - Workforce Compensation Real Time subject area only. However, the analysis return… -
Infolet Repository Icon not visibleSummary Infolet Repository Icon not visibleContent I have many infolets set to visible on the Home configuration page but I am still unable to view the infolet repositor…
-
Understand SQL Query for Talent profile data modelContent Hi Everyone, I have created the data model for talent profile print action with the help of delivered data by oracle. In delivered data model oracle has used a s…
-
Accrual Balance by DateSummary We need to create a report which allows us to report on accrual balances for previous years - Oracle have said this isn't possible in OTBI and to use BI - does a…
-
"Department Name" Attribute Missing from "Workforce Management - Person Real Time"Summary "Department Name" Attribute Missing from "Workforce Management - Person Real Time"Content Hi Experts, While trying to build a custom OTBI Analysis on "Workforce … -
Creating Data Model - Issue Loading PageSummary When attempting to create a Data Model, page only partially loads.Content Hi All, I've been trying to crack my brain at this. I am trying to create a New Data Mo…
-
Reports (and Dashboard) SharingSummary Request for best Practice for Reports (and Dashboard) SharingContent Hello all! We have newly implemented HCM Fusion and received little guidance concerning Repo…
-
How to get UI value on SQL outputContent Hello Experts, How we can pull or put some conditions to get the result. Eg. There are few fields with drop value like Yes, No but when I am pulling the data thr…
-
Empty fields are not displayed when exporting XML from Data ModelSummary Empty fields are not displayed when exporting XML from Data ModelContent Hello, I am building a Data Model to get one row with several columns, and I need to exp…
-
Unable to view Full-Time Equivalent value from OTBIContent Hi All, We created OTBI report based on "Workforce Management - Worker Assignment Real Time" subject area but unable to view "Full-Time Equivalent" data from OTB…
-
Union Analysis Needed for SecuritySummary need assistance with a union analysisContent I am in need of assistance with an analysis. I need to capture all hourly employees who do not have the 'Employee Ho…
-
BI Publisher condition : display if is not nullContent Hello, I create my job offer letter via BI Publisher plug in on Word. I create a conditional region in order to display a sentence If ATTRIBUTE_NUMBER5 is not nu…
-
Reporting on Questionnaire ResponsesContent Hi All, We're getting ready to deploy an onboarding questionnaire as a task in our enterprise onboarding checklist. Does anyone know which subject area can be us…
-
Changing the report header logo based on the legal entity in rtfSummary If legal entity is x then it should show x logo , else if legal entity is y then it should show y logo.User_2025-02-07-09-10-02-492 43 views 5 comments 0 points Most recent by User_2025-02-07-09-10-02-492
-
Adding security to position report to limit resultsSummary Limiting the results of a position report according to the logged in userContent We have put position hierarchies in place so each position now has a parent posi…