Global HR
Discussion List
-
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). …User_2025-03-07-21-07-25-805 477 views 6 comments 1 point Most recent by User_2025-07-18-02-05-33-261 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…User_2025-01-23-23-50-04-709 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…User_2025-01-23-21-24-21-434 775 views 3 comments 2 points Most recent by User_2025-01-23-21-24-21-434 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…User_2025-01-29-01-27-20-754 67 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…User_2025-01-29-19-59-40-005 67 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…User_2025-01-30-03-54-32-528 68 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…User_2025-01-22-19-43-38-766 43 views 3 comments 0 points Most recent by User_2025-01-30-03-53-16-644 Reporting and Analytics for HCM
-
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 81 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…User_2025-01-28-05-39-23-766 117 views 2 comments 1 point Most recent by User_2025-01-28-05-39-23-766 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 …User_2025-01-30-03-39-56-442 1.6K 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 347 views 9 comments 0 points Most recent by User_2025-01-25-06-20-12-259 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