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
-
Manager Flag - all employees returning no valuesSummary Manager Flag - all employees returning no valuesContent Workforce Manager - Worker Assignment Real Time > Worker Assignment Details > Manager Flag I was expectin… -
Recruiting - Hires Listing no pulling offer detail for allSummary Recruiting - Hires Listing no pulling offer detail for allContent Trying to use seeded report of Hires Listing to create our own version and for some candidates … -
BI Publisher Report filter with multiple criteriaSummary Needing to add multiple criteria to an OTBI report filter e.g. multiple business unitsContent When adding a filter to a report created in OTBI I need to add mult… -
Scheduled Absences FieldSummary How do I get scheduled absences for this plan year only?Content Hi I need to run an accrual report for Finance and they need the absences booked but not taken in… -
Union Field in Employee screenSummary Union Field in Employee screenContent Hello All , Can you please let us know where we can find "UNION" in which Oracle table. NAvigation is :- My Client Groups >… -
OTBI Report with Employee names in the 9 Box instead of countContent We are trying to build a OTBI report that can show employee names in the 9Box instead of counts/ performance tiles. Attaching picture for reference. Is this poss…User_2025-02-10-08-27-16-805 39 views 4 comments 0 points Most recent by User_2025-02-10-08-27-16-805 -
OTBI- Filter is based on results of another analysisContent I am writing a report 1 that take all of our companies invoices and shrink them down to a population of only specific invoices. Then in report 2 I want to be bas… -
How to Include an url in the BI Publisher Bursting Email BodySummary How to Include an url in the BI Publisher Bursting Email BodyContent I have a link which needs be sent to the recipients going through the busting email. Here is… -
Function FILTER requires at least one measure column in its first argument.Summary Function FILTER requires at least one measure column in its first argument.Content I would like to use the filter function on a non numeric column but I run into…User_2025-02-10-08-27-16-805 326 views 4 comments 1 point Most recent by User_2025-02-10-08-27-16-805 -
Report using Contract DFFSummary How to build a report to include Contract DFFContent Hi, I have built a report joining the following subject areas Workforce Management - Employment Contract Rea… -
Subject area for Positions which has missing segments in Costing of PositionContent Hi Experts, I am new to OTBI analysis, I have a requirement to List all Positions which has missing segments in Costing of Position. Can anyone tell me which sub… -
Monitoring License Metrics - Transactional Business Intelligence Cloud ServiceSummary What drives the license usage for Oracle Fusion Transactional Business Intelligence Cloud Service?Content Hi all, Many of the subscriptions are driven by a speci… -
Single output row for Course and Offering dataSummary Reduce duplicate rows in Learn Reporting of Course and Offering dataContent We have legacy course completion data that was loaded via HDL. Unfortunately we did n… -
Individual compensation plans subject areasContent Hello experts, I should create a payroll report in order to extract for each employee Individual Compensation Plans information. As a result, I need the followin… -
Head count by department for every month reportContent Hi, I'm looking for headcount report for each month by department. Can someone help me please. Thanks, Vijay -
Performance Rating With Compensation Data causing duplicate rowsContent Using Performance Rating from Compensation - Workforce Compensation Real Time subject area causes rows to duplicate for individual employee. I have tried to use …User_2025-02-10-08-27-16-805 36 views 5 comments 0 points Most recent by User_2025-02-10-08-27-16-805 -
OTBI - get language which user is connected withContent Hello, we need to detect the language which the user is connect with. How it is possible? (OTBI) Thanks Nicola -
OTBI filter cross subject areas problemContent Hi Guys, I created a report with elements from 4 subject areas, It work well, but when I add some filters it give me no results even if before the filter the val… -
Display Parent Manager First Name and Last Name in 2 separate columnsContent Hello, I have an analysis I am creating that the end user has requested manager first name and last name to be in 2 separate columns. I have referenced this post… -
Report for Duplicate DependentsSummary Report for Duplicate DependentsContent Hi , Any one can help is their any report to find the duplicate dependents for each employee Regards, Reddykrishna -
Metrics for News and Announcements?Content Is there anywhere we can see metrics for how many times people have clicked on News and Announcement articles? Many Thanks Amanda -
Report for MFA Multi factor authenticationSummary Report to identify which employees have activated Multi factor authenticationContent Hi Do you know if there is any subject area or database table where I can se… -
Oracle Learning Planning Prices -> Any alternates to get previous history from 'wlf_plan_records_f'Summary wlf_plan_records_f - does not keep date-tracked rowsContent Hello, Can anyone please help? At the moment, the OLC table 'wlf_plan_records_f' does not keep date-t…
-
In need of an AAP Promotion report (FROM and TO details on job)Summary In need of an AAP Promotion report (FROM and TO details on job)Content We have AAP promotion report due in which they are asking FROM and TO of a job in a promot… -
OBTI Formula for January 1st of Current YearContent I need to get the age of the worker for the start of the year in an OBTI analysis. I have Oracle's formula to calculate age: TimeStampDiff(SQL_TSI_YEAR, "Worker"… -
Expenses Employee Number to Worker - Person NumberSummary Cannot connect 2 subject areas to merge data in OTBIContent Using OTBI I am attempting to merge subject areas Workforce Management -accruals real time with Expen… -
Transaction Approvals and Person NumberContent Hi, I have created logical SQL to return 'Rejected' Document Records from the following subject areas: * Human Capital Management - Approval Notification Archive…
-
Passing parameter from Dashboard Prompt to BI ReportSummary Passing parameter from Dashboard Prompt to BI ReportContent Hi, I know we can pass parameter from Dashboard Prompt to Analysis. I wonder if we can do it from Das… -
How to Remove the HTML tag from the goal comments in BI ReportSummary How to Remove the HTML tag from the goal comments in BI ReportContent Hi Expert, How to Remove the HTML tag from the goal comments in BI Report Note: OTBI Report…User_2025-02-05-01-04-36-989 51 views 2 comments 1 point Most recent by User_2025-01-25-01-10-42-578 -
Duplicate rows returned for some Employees in Production OnlySummary Duplicate rows returned for some Employees in Production OnlyContent Hi, When I run the attached analysis which is developed using logical SQL it returns duplica…