Get Started with Redwood for Oracle Cloud HCM Begin Now
Reporting and Analytics for HCM
Discussion List
-
PeopleSoft Human Resource tables to HCM Cloud tables conversionSummary What to expect for reporting power usersContent Can anyone provide some insight into briefly what becomes of the main Human Resource tables that PeopleSoft 9.1 Q…
-
Retrieving OIM DataSummary Retrieving OIM DataContent Would like to know how to run a query to extract information from OIM? select usr_login,usr_key,USR_UPDATE,USR_UPDATEBY,usr_status fro…
-
Workforce Goals - Goals Status Overview Real Time showing incorrect hierarchySummary Manager Hierarchy in the Assignment Manager (Unsecured) folder shows incorrect hierarchy in the Goals Status Overview Real Time Subject Area but shows correct hi…
-
Report Structure after R12 upgradeSummary Report Structure after R12 upgradeContent We notice after R12 upgrade, BIP catalog folders are changed. I can find folders suffixed with '_customized_'. what is …
-
Manage Costing by Department / Cost Center ReportingSummary How to report on Cost Centre in Cost Accounts section of Manage Costing of DepartmentContent All - I originally posted about how to report on Cost Center out of …
-
Searchable Prompt in OTBI Analysis without creating DashboardSummary Please help me to have the searchable prompt in OTBI analysis itself rather than having it as prompt in dashboardContent Hi Team, Please help me to accomplish th…
-
Manager Hierarchy Org Chart VisualizationSummary Manager Hierarchy Org Chart Visualization for Performance and Talent onlyContent Manager Hierarchy Org Chart Visualization for Performance and Talent only I am a…
-
Publishing reports created in Data Visualizer to Cloud HCMSummary Not able publish the reports created using Data Visualizer to Cloud HCMContent When I try to publish the report/project created in Data Visualizer to our instanc…
-
OTBI Active Assignment between date rangeSummary OTBI Active Assignment between date rangeContent I am attempting to isolate a population based on date range. Anyone who had an active assignment between date x …
-
Why can't salary be pulled into a terminated report?Summary Need to pull salary in for inactive employeesContent This has been an issue since we implemented HCM. I don't understand why Oracle wipes out an employee's salar…
-
OTBI Report to show the internal promotions and external hires for the same positionContent Hi All, We have a requirement in OTBI to display No. of employees who are promoted to "Director" internally vs No. of employees who got hired as a "Director" (By…
-
Manager Hierarchy Drill Down ReportSummary Need an OTBI Report to Drill down based on the Manager Selection. The detailed table should be dynamic to increase the columns data based on selection promt mana…
-
Location Headcount analytics is not working while hiring an employee.Summary Location Headcount analytics is not showing any data analysis while hiring an employee.Content Hello There, We have two analytics on New Hire - > Employment Info…
-
BI Publisher Date PromptContent Hi All I'm struggling to get a Date prompt working in BI Publisher. I can get the prompt to show but it doesn't work (seems more complex than the easy prompts in…
-
OTBI Analysis from Top to Bottom Mgr HiearchySummary Need an OTBI Analysis for the Mgr Hierarchy from Top to Mottom based on the selected ManagerContent Hi Team. We have requirement to print the below Manager Hiear…
-
A new Dashboard publishing with SecuritySummary Hi, I have created a new dashboard which we want to publish as an HR dashboard.Content Hi, I have created a new dashboard which we want to publish as an HR dashb…
-
A solution for exporting reports from one environment to another when versions are differentContent Hi, I've been trying to transfer reports and dashboards across environments recently, but have come into this error: Incompatible version when reading object "Ca…
-
As of Date Presentation VariableContent Hi Is it possible to create a presentation variable for a date to get a report from the past? For instance, I need a report to show what the data was on the 1st …
-
Flexfields are not working (after the upgrade to R12) any longerSummary Flexfields are not working (after the upgrade to R12) any longerContent Hi All, Since we are on R12, my flexfields for cost center and company code are not worki…
-
performance and Talent - Goal Management goal plan createdSummary I am attempting create a report to show me those assigned to a goal plan. I am not having any luck. any idea?Content i am using the field count of distinct worke…
-
How to skip mailing/bursting extract output if there is no data captured post process completion..Content Dear Techies, We are looking for solution to skip mailing the output on particular mail id, if there is no data getting captured in output of the process we run …
-
Unable to view OTBI Report Parameters/Prompts from CWB PlanContent Hi All, I have created custom Compensation OTBI Report as per the requirement. I uploaded report in "/Custom/Human Capital Management/Compensation" folder and at…
-
Employment History Report - Manager, Job, Business UnitContent Does anyone have an example of an employment history report that shows what the values for manager, job and business unit for old and new values? There is a samp…
-
Report to Run with Lookback PeriodContent I'm trying to create a report with a filter (not a prompt) that looks back a specific number of days from the current run date. I'm using the SQL Expression of C…
-
Cloud OUM DocumentationContent Hi Guys, Is there any availability of deliverable templates with respect to Cloud OUM implementation methodology?
-
Salary Basis vs FLSA vs Payroll Name AuditSummary We need to audit when there is a mismatch on these fieldsContent Hi - we have an ask to provide an audit on employees that have a mismatch in their data: * FLSA …
-
Common Alignment for both RTF and PDF not working in LettersSummary Common Alignment for both RTF and PDF not working in LettersContent Hi, I have developed one appointment letter, when i run this report the alignment of RTF Temp…
-
SQL Function to allow more than 4000 charactersSummary Need SQL Function to allow more than 4000 charactersContent Hi, I have built sql custom report and my requirement is to bring employee overall comments using BI …
-
Pivot Table Issues with Position NamesContent Hi all, We have a position in an organisation analysis which works perfectly but when we try and pivot the table to show a higher level view, the position names …
-
Showing Percentages in a Bar PivotSummary Is there a trick to show percentages on a scroll over of a bar pivot with actual values?Content Hello all, I am using OTBI to develop some reports and the user p…