Public Sector
Discussion List
-
Who hasnt submitted a TimecardContent Hi all We have been live with HCM for a year and i have been tasked with providing a report that shows who has not submitted a time card. The seeded reports dont…Dawn Cawston - CPS 24 views 1 comment 0 points Most recent by SameerJain Reporting and Analytics for HCM -
New DFF Segment Not Appearing in OTBIContent Hello, I've added some new segments to the Document Record DFF. I ticked the box labelled "BI Enabled" for each segment, and both verified/deployed the DFF. Its …Edward Cowne 47 views 16 comments 2 points Most recent by Akshay Aiyer Reporting and Analytics for HCM -
Error in Report - Date not filtering properly with other variables in Oracle ReportSummary dates not filtering correctly with other variableContent I am trying to filter dates with step increases in a custom Oracle Report; the objective is to show how …Noël Frempter 9 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Length of Service calculation OTBISummary Calculation of LOS based on either Current Date or Termination Date for former employees.Content I am looking to calculate an individual's length of service base…Stephen Prentice 37 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
BIP Query to get only base elementsSummary BIP Query to get only base elementsContent While creating elements, there will be shadow elements that will get created automatically. Is there anyway to get onl…Sowdhaminya Murugan 37 views 2 comments 0 points Most recent by Sowdhaminya Murugan Reporting and Analytics for HCM -
Starters as at Start DateSummary Data must be returned as at the Start DateContent Hi all I have a starters report that provides me with all the starters between two points in time however the d…Dawn Cawston - CPS 17 views 26 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Reporting Folder StructureSummary People in the business keep dragging and dropping the folders by accidentContent Good afternoon all We have an ongoing problem with people within our wider busin…Dawn Cawston - CPS 32 views 3 comments 0 points Most recent by Lucky Sharma Reporting and Analytics for HCM
-
Day wise break up of absences in OTBIContent Hi Team We have a very basic requirement that absences for multiple days need to be broken down into individual days and be displayed on OTBI When i ran the Abse…
-
Report not showing own itemsSummary An report from timecards does not show own itemsContent We use time and labour to claim overtime as well as to record our flexi. With all our reports in OTBI, th…Dawn Cawston - CPS 24 views 4 comments 0 points Most recent by Dawn Cawston - CPS Reporting and Analytics for HCM
-
OTBI Worker Assignment Real time cannot report on Substantive ManagersSummary OTBI Worker Assignment Real time cannot report on Substantive ManagersContent Hi We need to report on all employees in a Managers chain of command and that inclu…Paresh Mulye-159565 28 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Report on Terminated Employees Sickness AbsenceSummary We cannot report on sickness absence data for terminated employeesContent Hello, We have a requirement to report on the average working days lost for all employe…Dawn Cawston - CPS 22 views 2 comments 0 points Most recent by Dawn Cawston - CPS Reporting and Analytics for HCM
-
Absence Days between DatesSummary Data must be returned where the absence is between two datesContent Hi all Can anyone help me with a problem where the Workforce Management - Absence Calendar De…Dawn Cawston - CPS 49 views 4 comments 0 points Most recent by Dawn Cawston - CPS Reporting and Analytics for HCM
-
Editable checkbox in BIP ReportSummary Need a checkbox in report where users can check/uncheckContent Hello - We have a requirement where the BIP report should display checkboxes with options and the …Sowdhaminya Murugan 17 views 1 comment 1 point Most recent by Priyesh Reporting and Analytics for HCM
-
Termination ActionSummary Where is Termination Action in OTBIContent Good afternoon We have created a leaving report in Work Relationship Real Time subject area however the Termination Ac…Dawn Cawston - CPS 42 views 16 comments 0 points Most recent by Dawn Cawston - CPS Reporting and Analytics for HCM
-
Feedback on Useful Seeded Manager Dashboards or Reports AvailableSummary Keen to learn from others of some basic reports that might be useful for managers to self-serveContent Cornwall Council went live with Oracle HCM, for HR and Pay…Abby Cockings 24 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to get a list of all languages from HRT_CONTENT_ITEMS_TLContent Hi, Under talent profile and language skills - how do I just get a list of all available languages? See they are hiding in HRT_CONTENT_ITEMS_TL but not sure how …King Jack 10 views 1 comment 2 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
00/00/0Summary Cannot filter on report returnContent Hi all I am looking at working pattern reporting. All our full time standard working hours peeps inherit their working patt…Dawn Cawston - CPS 26 views 7 comments 0 points Most recent by Dawn Cawston - CPS Reporting and Analytics for HCM
-
HCM DeeplinkSummary Deeplink to view absence recordContent Has anyone created a deep link in a report to view an absence record?User_939BK 48 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
OTBI HCM Employee ReportSummary Required HCM OTBI database mapping with UI screensContent Dear All, I'm new to OTBI reporting. I need to create a employee report using OTBI and I'm unable to fi…Suresh Veesam 89 views 6 comments 1 point Most recent by Tejaswini-Oracle Reporting and Analytics for HCM
-
Return the Line Manager at a Point in TimeSummary Return the line manager at a PITContent Hi all I am trying to build a report that displays the line manager against the person at a specific point in time howeve…Dawn Cawston - CPS 28 views 16 comments 0 points Most recent by Dawn Cawston - CPS Reporting and Analytics for HCM
-
Getting the P_DATE as a columnSummary Getting the prompted date to be the date in a column.Content Is there anyway of being able to get the P_DATE that you have set as a prompt to show in a column? I…Rebekah Moore 27 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
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 40 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 50 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 19 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 39 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 83 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.…