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
-
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 -
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
-
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… -
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 -
Issue with Views in HCM cloud Learning Management (WLF_LRNR_COMPLETION_DETAILS_V) in SpecializationSummary Joins are missing in the Specialization item type part in the Views WLF_LRNR_COMPLETION_DETAILS_V and WLF_LRNR_COMPLETION_SUMMARY_VContent In the code of the vie…
-
DFF Values Missing from OTBI ReportContent Hi, I had an Analysis report that looked at 2 different DFFs from the Workforce Management - Documents of Record Real Time Area and reported back on the values i… -
Gross Wage Report YTDSummary Detail Gross Wage Report YTDContent I am looking for a way or if there is already a predefined report for Gross Wages YTD broken down by each employee for exampl… -
Displaying an uploaded document stored as a blob in a BI Publisher report?Content We have a report request to display attachments that are uploaded by employees in a BI Publisher report. The uploaded attachments are stored as a blob and the ta… -
Column to be added with option 'Created by' which should give information of Employee Name - While cSummary Column to be added with option 'Created by' which should give information of Employee Name - While creation on new Analysis in reportsContent Hi, While creating …
-
HDL Error ReportingSummary HDL Error ReportingContent Hi Experts, Does anyone have user friendly error reports for HDL Loads. Because PBL is deprecated, we are looking for a good reporting…
-
Ways to securely send OTBI reports through agents?Summary What are the ways to securely send OTBI reports through agents?Content I think this has been asked a few times in the past, but just wondering what are the ways …
-
Organization Tree - Filter on active versionsSummary Provides you the process to filter out the inactive organization tree versions by defaultContent Issue: Organization Trees display all the versions in HCM OTBI s… -
Oracle BIP Report -> RTF Template page bordersSummary page bordersContent Hello, I am having an issue with achieving page borders in RTF templates. Attached a word document explaining my problem. Can anyone please a… -
Legal Employer Hire Date and Enterprise Hire Date on Work Relationship DetailsContent Hi All, Can someone help to find underline tables and fields for "Legal Employer Hire Date and Enterprise Hire Date on Work Relationship Details Tab" If you have…
-
How can I filter on column and not a measures in OTBISummary Filter in a sample column and not a measures how can i do it??????Content Hello, I want to transform a simple column in otbi into a measures to create a filter :… -
When I Run EEO-1 Component 2 Electronic Report, the Text results come back blankSummary When I Run EEO-1 Component 2 Electronic Report, the Text results come back blankContent Hi, When I run the When I Run EEO-1 Component 2 Electronic Report, there …
-
Page Composer -> How to pass pass parameters to embedded dashboard in Talent Profile pageSummary Bind Parameters to OTBI dashboard promptsContent Hello, Can anyone please help on this scenario? I have built a dashboard in OTBI, embedded that inside Talent Pr…
-
Change the language of the text in RTF template.Content Hi Experts, I am looking for a function for RTF template using which I can change the Language of the text. for eg: Orignal Data- English: One Thousand Two Hundr…
-
Set Column Filter Formula to 'Full Time' - Dashboard TileSummary I've created a headcount dashboard with tiles by employees, contingent worker, Full Time, Part Time, PRN. I've created a column filter formula for all of the til…
-
Point in Time - Home Address for EmployeesSummary Point in Time - Home Address for EmployeesContent Does anyone know if it is possible to create a report that returns employee's home address as of a specific dat…
-
OTBI report to show records ONLY if there was a change in a particular fieldSummary OTBI report to show records ONLY if there was a change in a particular fieldContent Hello, I need to pull a report on a weekly basis if any employee got their Ma…User_2025-02-04-15-06-22-759 348 views 8 comments 1 point Most recent by Raghavendra Raghunath-Oracle
-
Question marks in attributes causing filtering troubleContent Hello Experts, We've encountered a situation where a course has been setup in our learning module with a question mark at the end. We've found that when we try t… -
In OTBI - How can we restrict user to create and edit report only in My FolderSummary Need to restrict the users to have the right to create edit update the analysis only in My Folder.Content Need to restrict the users to have the right to create … -
Show Field Data in Column instead of in RowsSummary Working on this in OTBIContent Hi All, I am trying to pull in the last 2 dates an employee was paid. Currently the data appears as 2 separate rows. I am using ra…
-
Creating Reports and Extracts: How to map/link application front end fields to back end database tabSummary Looking for a simple way to map application pages/fields to cloud database tablesContent Good morning, I have been digging through the schema documentation while…
-
Compound sort in OTBIContent Hi All, Is it possible to do Sort on 2 columns in OTBI? Ex. First Sort on BU and second sort on LE in same report. Thanks, VijayUser_2025-02-07-19-03-14-525 39 views 2 comments 1 point Most recent by User_2025-02-07-19-03-14-525
-
Adding Manager Termination Comments to Pending Terms reportSummary Adding Manager Termination Comments to Pending Terms reportContent Hello, We have an analysis set up for our HRBPs to pull pending terminations. One of the busin…
-
Report AuditSummary Report showing when a report was last ran and by whoContent Hi All, I thought I saw this on a webinar, but I don't really recall. Is there a report in OTBI that …
-
Combining Fields into one Column / Field in OTBIContent Hi, I'm looking to see if its possible to combine multiple fields / columns into one field / column? I currently have a report that brings back 5 fields / column…
-
Multiple IF ELSE Conditions in BIP Excel TemplateSummary Multiple IF ELSE Conditions in BIP Excel TemplateContent Hi Experts, How to use multiple IF else condition BIP Excel Template. Example: IF Legislation_Code IN ('…