Public Sector
Discussion List
-
Reporting in Working days when absence UOM is hoursSummary I need to know how to convert a duration from hours into days using WPContent We are on 19D and our UOM is set to hours so when i report on absence, the duration…Dawn Cawston - CPS 68 views 2 comments 0 points Most recent by Dawn Cawston - CPS Reporting and Analytics for HCM
-
Looking for Subject Area to return terminated workers in AnalysisSummary Looking for assistance in locating subject area to create analysis for terminated workers in last twelve monthsContent I’m currently redeveloping our existing EB…Leanne Batsford 35 views 2 comments 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Returning data based on two columnsSummary Data must be returned if either of the criteria satisfiedContent HI all Any ideas how to do the above. I am working in Absence Calendar and have the start and en…Dawn Cawston - CPS 20 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
HCM Subject Areas - Field ListSummary List of fields within HCM Subject Areas - and DescriptionContent Hi, I am new to reporting within HCM OTBI so this may be a silly question and may or may not hav…Kevin Driscoll 70 views 3 comments 1 point Most recent by Michelle Juergens Reporting and Analytics for HCM
-
Retrieving more than 500 rowsContent I have an analysis that may return more than 500 rows, however it appears 500 is the max. Is there a setting in my report, or someplace else that will increase t…Annette M 59 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Department not in Payroll - Payroll Costing Setup Details Real Time Subject AreaSummary Department not in Payroll - Payroll Costing Setup Details Real Time Subject AreaContent Hi I wonder if you can help me. When I try to report the cost centre for …Andrew Collins-174647 172 views 2 comments 0 points Most recent by Andrew Collins-174647 Reporting and Analytics for HCM
-
OTBI - FTE doubles when adding line manager nameContent Hi, I have an OTBI report. Using the "Workforce Management - Worker Assignment Real Time" subject area. I am pulling back: "Worker Assignment > FTE" and am filte…
-
OTBI: enabling custom Working/Business Days calendars and/or reporting on Work Patterns in OTBI?Summary OTBI: enabling custom Working/Business Days calendars and/or reporting on Work Patterns in OTBI?Content Hi All, I have a couple of queries around reporting on Wo…Richard Beet 154 views 14 comments 2 points Most recent by Richard Bowron Reporting and Analytics for HCM
-
What are the various benefit plans to which the workers have enrolled, by various years?Content Looking at the Benefits - Enrollments Real Time subject area's business question it is noted that the subject area has attributes that will answer this question.…
-
Analysis giving female managers as a percentage of headcountSummary Analysis giving female managers as a percentage of headcountContent Hi I've written an analysis that returns the assignment headcount for female managers for my …Andrew Collins-174647 60 views 5 comments 0 points Most recent by Andrew Collins-174647 Reporting and Analytics for HCM
-
Setting an 'As at' prompt for assignment data in OTBISummary I would like to be able to set a prompt that will bring back all the assignment data at a given point in time.Content I have some reports of worker data (grades,…Rebekah Moore 71 views 5 comments 1 point Most recent by Rebekah Moore Reporting and Analytics for HCM
-
Data from analysis to be returned as CSV when issuing a SOAP requestContent Hi, I have a SOAP request in PHP as follows: /shared/Custom/Digital/MyResources/HCM_DATA…
-
SOAP Request for AnalysisContent Hi, So we have a working SOAP request for a XDO
-
Roles for Workforce Management - Worker Assignment Real Time Subject AreaContent Hi, We have a test and production environment where a user resides. I have an analysis that looks at the subject area: "Workforce Management - Worker Assignment …
-
Saving report outcomeSummary Canned Report - Terminations OverviewContent Does anyone know how to export the data from the Terminations Overview report found in Shared Folders\Human Capital …
-
One report to view them all - person reporting showing department, assignment status etcContent Hi, Is there a SQL based data model that shows everyone in HCM, their assignment status, department, name, suffix, email, location, manager details, role details…
-
Leave accruals and usage by absence typeContent In our legacy system we had a report that listed, by employee, all leaves that were accrued and all absences taken, by leave type, sorted by date. Is there a rep…Annette M 63 views 1 comment 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Add filter to analysisContent I created an analysis that prompts for a date paid. I would like to further filter the analysis using the prompted date paid and check that it is > then a start …Annette M 67 views 1 comment 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Productivity ReportSummary A Report from Oracle to provide site productivityContent Can i ask if a report like this is possible? They are looking to measure productivity in the sites, so t…Michael Cook-142104 47 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Active employees with no pay checkContent We have active, benefited employees that must meet a threshold of hours each pay period in order to maintain their benefits. Is there a way for me to report all …Annette M 56 views 1 comment 0 points Most recent by Adam Gates-Oracle Reporting and Analytics for HCM
-
Retain report prompt valuesContent Is there a way to retain the users filled in report prompt values? For example, we have a report that has about 5 fields a user can fill in to run the report. Th…Annette M 24 views 3 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Optionally display analysis filter at bottom of reportContent I have the filter appear at the bottom of my analysis. Is there a way for this to optionally show? For example, it appears on the bottom of the report but the us…Annette M 31 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Toggle to include/exclude a column on reportContent I have an analysis that I want to prompt the user to include or exclude the SSN. I would rather do this than to maintain two reports. How would I create a prompt…Annette M 28 views 3 comments 2 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Report to view status of every individualContent Hi, I have a need to list every person in the organisation and whether they are active or not. I can look at assignments but obviously someone could have multipl…
-
OTBI Goals Report for Managers - Questions about Role Security on Goals Subject AreasSummary Developing an OTBI Performance Tile showing number of staff with approved goals for a managerContent We have noticed that line managers are unable to see the goa…
-
BI Publisher - CASE WHEN returns correct value on Tree View OnlySummary CASE WHEN is returning the correct value when I view the data in tree view e.g. Home or Mobile etc on BI Publisher but when viewed on table view the database val…
-
Workforce Management - Absence Real TimeSummary Issue with Absence DashboardContent Hi, I am trying to create a OTBI report based on Subject Area - Workforce Management - Absence Real Time. Currently we have a…Shail Parekh 244 views 14 comments 1 point Most recent by Rambo Jacob Reporting and Analytics for HCM
-
Benefit Enrollment VS ActualContent We are finding that employees enrolled in a benefit and their actual element amounts from the payroll may be different. Is there a report or can someone give me …
-
Schedule Report to Service Cloud WebDavSummary Schedule Report to Service Cloud WebDavContent Hi, Quite simply, I am trying to schedule/run a report so it goes to Service Cloud WebDav As yet, zero success. I …
-
Workforce Trend Real Time Subject area not WorkingSummary Incorrect numbers in data and don't know how to correctContent Hi, I am using the subject area Workforce Management - Workforce Real Time as I want to produce a …