Global HR
Discussion List
-
Standard report to capture position changes for employeesSummary Position Change ReportContent Hi folks, Is there a standard Oracle report available now to capture an employee's position title changes, which occurs to Promotio…User_J6YRM 278 views 3 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Self-Service & DashboardsSummary How do you share your reports with your users?Content Hello experts - I am hoping to find out best practices as to how you do reporting for your company (or how …Prudence K 112 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Can we download the attachments from BPM tables wfattachment?Summary Create hyperlink to download the attachments from BPM table wfattachmentContent Hello Experts, I am trying to generate a report with the approval transactions an…Sricharan Monigari 180 views 3 comments 0 points Most recent by Sricharan Monigari Reporting and Analytics for HCM -
Is there a way to catch the No Results message with a user-friendly message?Summary Is there a way to catch the No Results message with a user-friendly message?Content A way to catch the No Results error message with a user-friendly messageI hav…Kimberly_Nguyen 68 views 7 comments 1 point Most recent by Kimberly_Nguyen Reporting and Analytics for HCM
-
Assignment Audit ReportSummary Looking for a report that includes Updated, Corrected, and Deleted AssignmentsContent Hello, I am searching for an existing report or a way to report an audit of…Brenda Jacks-49721 195 views 4 comments 0 points Most recent by Brenda Jacks-49721 Reporting and Analytics for HCM
-
Unreadable content when reporting on GoalsSummary Excel generated error when using Export to ExcelContent Hi, when I'm reporting off the 'Workforce Goals - Goal Status overview real time' subject area, the analy…Alex Andreadis-70445 49 views 5 comments 1 point Most recent by Alex Andreadis-70445 Reporting and Analytics for HCM -
What does DATA_DS G_1 mean in BIP?Summary What does DATA_DS G_1 mean in BIP?Content Hello All, I am running a SQL in BIP and it is returning DATA_DS G_1 (see attached SQL and screenshot of DATA_DS G_1). …Pamela Batts-Brown 303 views 6 comments 1 point Most recent by Nikhil Nelluri-71478 Reporting and Analytics for HCM
-
Donuts instead of PiesSummary Is it possible to output Donut charts instead of pie charts?Content Most modern dashboards contain at least one donut / doughnut chart. Few contain pie charts an…Duncan Davies-16311 102 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Top N querySummary Filter top 5 leaving reasonContent Hi, I want to create a report that shows the top 5 reasons of leaving (e.g. 'found another job", "Low salary" etc.). I know wh…
-
Job Function NameSummary Need Function Name in BI Publisher reportContent Hello, I am building a BI Publisher report and need to pull in the Job Function Name I found the JOB_FUNCTION_CO…Shawn McDonald 475 views 3 comments 2 points Most recent by Shawn McDonald Reporting and Analytics for HCM -
How to Obtain "People Group" Field through BI PublisherSummary How to obtain "People Group" field through BI PublisherContent Hello All, I am unable to obtain "People Group" and "Legal Employer Name" fields through querying …Aahiri_Sarma 65 views 7 comments 0 points Most recent by Aahiri_Sarma Reporting and Analytics for HCM -
Manager Types in reports - HELP NEEDEDContent Hi All, I want to create a report that will show the manager type + manager name for each employee. i.e. Person Name Manager Type Manager Name Dudi Levi Line Man…Dudi Levi 97 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Table name to find the approved date and approve by columnSummary Table name to find the approved date and approve by columnContent Hi, I have a requirement to create a report with approved date and approved by column. My custo…Nirmal Kumar L 61 views 3 comments 1 point Most recent by Dr Surlina Yin-Oracle Reporting and Analytics for HCM
-
Phones and emails make duplication rowsSummary I'm trying to add columns for emails and phones but instead of one line it's duplicating itContent Hi, I created an analysis in OTBI that shows employees phones …
-
Search a date un value of columns that containts multiple date (DD/MM/YYYY ~DD/MM/YYYY ~DD/MM/YYYY )Summary How to search for date of birth in the actual year from value which contains many datesContent Hello, I want to find persons which their date of birth is in the …User_I6AXL 29 views 3 comments 0 points Most recent by Aaron Leggett Reporting and Analytics for HCM -
Error on InfoletsSummary I've created two simple infolets for employees to see HC and FTEContent I've created two simple infolets for employees to see HC and FTE - but when then go to th…Peter Johnson-61682 68 views 2 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Possiblity of creating a Report which has a combination of data column from two different source oneSummary Possiblity of creating a Report which has a combination of data column from two different source one SQL and other static data (say excel Spreadhseet, XML, CSV..…AshishERPCloud 65 views 3 comments 0 points Most recent by Atish Chandra Supakar Reporting and Analytics for HCM -
Grouping monthly figures to create YTDSummary Grouping monthly figures to create YTDContent Hello, I am trying to create an OTBI report within the Subject Area called 'Payroll - Payroll Run Results Real Time…Barry Stamp-73691 65 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Static Data ColumnsSummary Is there a way to 'repurpose' a column from an OTBI subject area with a static data value, conditionally?Content Hello Customer Connect Community! Is there a way… -
What job role gives access to Human Capital Management – Approval Notification Archival Real Time suSummary What job role gives access to Human Capital Management – Approval Notification Archival Real Time subject area ?Content What job role gives access to Human Capit…Ruzwan Akram 83 views 2 comments 2 points Most recent by Sricharan Monigari Reporting and Analytics for HCM
-
Fusion Field - OTBI Subject / Folder MatrixContent Afternoon all, Is there a master matrix anywhere that lists fields in Fusion and cross-references them to their location subject area / folder / sub folder in OT…Evan Jenkins 117 views 2 comments 1 point Most recent by Evan Jenkins Reporting and Analytics for HCM -
Table Name for Scheduled ProcessesSummary Am looking for the Database TABLE name for querying all scheduled/processes with their PROCESS_IDContent Hi, Am looking for the Database TABLE name for querying …Shailendra Singh-73567 846 views 2 comments 1 point Most recent by Sricharan Monigari Reporting and Analytics for HCM
-
Changes only data in BI ReportsContent Please consider the following scenario: The Department of an employee is updated from 'Department A' to 'Department B' on 15th December 2017. The report is run o…Amrit 197 views 9 comments 0 points Most recent by Puja Bharati-27866 Reporting and Analytics for HCM -
Table for getting the Scheduled HCM Extracts listSummary Need table names for getting the scheduled payroll flows listContent Hi All, I have a requirement to generate BIP report with all the scheduled payroll flows and…Sricharan Monigari 67 views 2 comments 0 points Most recent by Sricharan Monigari Reporting and Analytics for HCM
-
Max Custom BIP Reports that can be run as a scheduled jobContent Hi, My customer has a custom BI Report. It is similar to a Compensation Statement. Each report run has 2 pages per worker as output, in PDF. If a Line Manager wi…Shailendra Singh-73567 24 views 4 comments 0 points Most recent by Shailendra Singh-73567 Reporting and Analytics for HCM
-
OTBI Report giving No result from same subject areaSummary OTBI Report giving No result from same subject areaContent Hi Team, I am using ‘Workforce-Assignment Real time’ subject area. Our requirement like Division with …Murali Mohan Peddini-75592 59 views 8 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
OTBI Department Hierarchy Report giving No ResultsSummary OTBI Department Hierarchy Report giving No ResultsContent Hi Team, I am trying to run a OTBI report for Department/Organisation Hirarchy in my Client instance, h…Murali Mohan Peddini-75592 114 views 4 comments 0 points Most recent by Murali Mohan Peddini-75592 Reporting and Analytics for HCM
-
Year End BalancingSummary Looking for Report IdeasContent I am looking for good reporting ideas to balance YTD amounts with my Tax Provider. I would like to start balancing this numbers o…Trish George 58 views 0 comments 0 points Most recent by Trish George Reporting and Analytics for HCM
-
Reporting on a Additional Job FieldContent Morning All, If you see the document I have uploaded it will make more sense with Images. Wonder if you could help me to get the bottom of a reporting issue with… -
Seeking BIP report for Worker, Potential Life event and Processed Life EventSummary Seeking BIP report for Worker, Potential Life event and Processed Life EventContent I need a list of workers and their event information - Potential and Processe…Shawn McDonald 94 views 8 comments 0 points Most recent by Shawn McDonald Reporting and Analytics for HCM