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
-
Displaying images in BI Publisher RTF TemplatesSummary Displaying images in BI Publisher RTF TemplatesContent Hi, I'm fetching employee images from PER_IMAGES to display in the report. I have provided size restrictio… -
Custom Subject Area Content in Analysis / DashboardsSummary Receives errors when sharing an analysisContent So I built some analysis by using some custom subject content areas, i.e. Regions built from multiple locations. … -
Push Weekly Email Notifications to a particular group of Line Managers and EmployeesSummary Push Weekly Email Notifications to a particular group of Line Managers and EmployeesContent Hi Friends I need to send couple of weekly notifications to a group o… -
Need to capture the details under Mobility in "Skills & Qualifications " pageSummary Need to capture the details under Mobility in "Skills & Qualifications " pageContent Hi Experts, Need a help. Need to retrieve the following data for a person. N…
-
Unable to query data in PER_ACCRUAL_PLANS_B and PER_ACCRUAL_PLANS_TL tablesContent Hi All, We entered Accrual data in the application. When we tries to query in BIP side we are not getting data from the tables (PER_ACCRUAL_PLANS_B and PER_ACCRU… -
Creating reports with multiple subject areasSummary Creating report with columns from multiple subject areasContent Hi We are trying to create a report containing employee bank account details & National Identifie… -
Reports not running since R13 18A appliedContent We upgraded to R13 and all Reports were running as expected, with no problems. Maintenance Pack 18A was then applied, and some reports are now experiencing issue…
-
Report Job HistorySummary How to export all Report Job HistoryContent Hi Everyone, Could one of you help me with the following questions? 1. How can I export to an Excel all the Report Jo… -
Hiding or reordering Fusion Reports and Analytics folder in REL13Summary Hiding or reordering Fusion Reports and Analytics folder in REL13Content Can we hide or reorder the fusion seeded folders in REL13? Did anyone faced this issue t… -
EText Template: Count of rows not resetting at each LevelSummary Count the number of rows generated for each EmployeeContent Hi, We are trying to get a count of the rows generated for each Employee, but the count keeps increas… -
Sample BI report to extract accrual balances of previous and current enrollments of a global transfeSummary Sample report requiredContent Hello experts, Can you please share if any sample report created for extracting Absence accrual balances of previous and current en…
-
Oracle Cloud Reports and AnalyticsSummary Need scheduled New Hire Report with effective date for prior weekContent Hi. I am new to Oracle Reports & Analytics. I have a New Hire report that I would like t… -
OTBI Report showing highest degree levelSummary Has anyone figured out how to create a report on degree information where the employee is listed under only their highest degree?Content I have a requirement for…
-
Temp to RegSummary Need a report for temp to reg employeesContent Hi, I need to create a report that returns employees that moved from Full-time Temporary to Full-time Regular.
-
After R13 Upgrade - Sample data are saved in xdm formatSummary After R13 Upgrade - Sample data are saved in xdm formatContent Hi, After uprading to R13, I am noticing when we try to save sample data by running a SQL in BI pu… -
Contact Person typeContent Hi, I am displaying the emp contact details using the "Workforce Management - Person Real Time". I want to exclude the contacts who is an existing employee , I c…
-
Unable to save XML in BI Publisher.Summary Unable to save XML in BI Publisher.Content Unable to save XML in BI Publisher. We are getting an error: Upload file size exceeds the maximum size limit defined b…
-
Reporting on KPI's of HR teams including metadataContent Hi Guys, I'm sourcing ideas on how tor report on KPI's that we need to report on around our HR team. Does anyone have any templates or ideas on how to create the… -
Report Usage Metrics OTBIContent Does anyone know how I can pull usage metrics of reports run by users in OTBI. I've searched for some time on this online, both here and Google. I see there was …
-
Set Operations trouble with visualizationsSummary Set Operations Cause graphs and visualizations not to workContent I've tried using set operations a few times for various reasons without much success. In today'… -
Goal Counts Report by Goal PlanSummary Employee Goal CountContent I've been trying to create this very basic and most commonly asked for report for well over a year to no scalable avail. I've tried nu… -
Logic Behind Calculated FieldsSummary Trying to find the actual logic behind calculated fields in OTBIContent We are trying to find the actual logic for calculated fields in OTBI. Some are self-expla…
-
Scheduling or Sharing a DashboardSummary Would like to schedule a dashboard and/or shareContent I have a dashboard with many tabs, would LOVE to schedule so I don't have to teach navigation, however, th…
-
Max assignment logic not working as expected in OTBI Analysis in Workforce Management Subject AreaContent We have several requests to bring in an employee’s max effective row in OTBI. We could use the Workforce Management Worker Assignment Real Time, but the issue wi… -
Pulling All Rows of Data (All Effective Dates)Summary Has anyone found a way to easily pull all rows of data for an employee in an OTBI report?Content Has anyone found a way to easily pull all rows of data in an OTB…
-
SUBSTRING function to separate multiple Valid GradesSummary We are trying to separate each valid grade into a separate columnContent When pulling job codes and valid grades, all valid grades are in one cell. We would like… -
Can we access the file contents of UCM file in BIP Report?Content I have a requirement to read the contents of the file placed on UCM in BI Report and am struggling to find the right table for this purpose. In EBS there was a t… -
Mapping of OBI Subject area to HCM ExtractsSummary Document for mapping OBI Subject area to HCM ExtractsContent Hi We have been using OBI Subject areas to extract data dump from HCM fusion. Now that our databse h…
-
Security Roles - Country Role vs AoR RoleContent Hi experts - I am trying to understand how we can limit our view to reports based on the Area of Responsibility (AoR). Current State: We have a security role cal… -
Workforce Succession Management - Talent Pools Real Time Subject AreaSummary Reporting on Talent Pools through OTBIContent Has anyone had any luck reporting on Talent Pools through this subject area? I have been unable to get any results.…