Public Sector
Discussion List
-
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 51 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 31 views 5 comments 1 point Most recent by Rebekah Moore Reporting and Analytics for HCM
-
Export Element RatesSummary Need to pull element rates out of HCM/PayrollContent Has anyone been successful in pulling element rates out of HCM/Payroll? By Element Rates, I am not referring…Brittani Roltgen 23 views 7 comments 0 points Most recent by Venkateswara Rao Vadlamani 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 53 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 …
-
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 27 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 36 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…
-
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 21 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 213 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 …King Jack 13 views 1 comment 1 point Most recent by Ravichandran Raju-80607 Reporting and Analytics for HCM
-
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 … -
Bring back Headcount Data from 12 months agoSummary I want headcount data from 12 months agoContent I have a simple report that sums headcount up and gives me numbers for today however I want to return the numbers…Richard Talbot 95 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Find Out a Person's Grade at a Particular DateContent Hi, I've been fiddling around with SQL but getting nowhere quick due to a number of factors. I'd like to keep it to SQL as my OTBI related permissions aren't 100…
-
BI Publisher and Person FTESummary Having issues with FTE in work measures and UNITContent Hi All, I am writing a report and i need to bring back person FTE so i am bring back value and unit from …
-
Error generating document in Excel when Exporting From OTBISummary Getting an error producing document in error in excel spread sheetContent Hi All, We have had an upgrade to OTBI over the weekend and now reports we run which is…Richard Talbot 28 views 2 comments 0 points Most recent by Karen Waddell Reporting and Analytics for HCM
-
Sql query is not workinkgContent Hi, trying to excute the following sql via BI publisher per support document: Doc ID 2187087.1 Select * from per_assignment_supervisors_f sup, per_all_people_f p… -
Special caracter not displaying as expectedSummary In standard reports of notifications, the special caracter are not well displaying.Content Hello, Any ideas please how to display the caracter correctly in the s…User_I6AXL 22 views 2 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Persons without data in organization level are missing in OTBI reportSummary if one person don't have data in the 5 level of organization will not appear in the reportsContent Hello, I hava some GID that are missing in my reports. When I …
-
Error advanced sql request using two subject areasSummary avanced sql query errorContent Hello , Attached the request I did to display competeny proficiency and target for the job profile. I have an error message . Any …User_I6AXL 34 views 4 comments 0 points Most recent by Anil Pillaresetty Reporting and Analytics for HCM