Reports
Discussion List
-
In process Termination ReportContent Has anyone developed a report that shows terminations in process and who it is currently pending approval with? Ideally we'd like a report that includes date/tim…User_2025-01-28-07-43-27-066 43 views 3 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Can we hide Factory delivered folders from Reports and Analytics based on role?Summary We have a requirement to hide all the factory delivered folders except Human Capital Management from Reports and Analytics.Content Requirement is : When login as…Karishma Dhapola 86 views 4 comments 1 point Most recent by AshishERPCloud Reporting and Analytics for HCM -
Change ordering of values in horizontal axis of graphSummary Change ordering of values in horizontal axis of graphContent We have a simple graph from OTBI but want to change the display order of the values on the horizonta…Emily Robinson 29 views 8 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Master reports for Job, grade, location, department, position, active and ex-employee headcountContent Any Master reports available for Job, grade, location, department, position, active and ex-employee headcount?User_2025-02-06-14-37-05-233 74 views 4 comments 1 point Most recent by User_2025-02-06-14-37-05-233 Reporting and Analytics for HCM
-
HCM BI Report - table to extract value set data (table type)Summary HCM BI Report - table to extract value set definition (table type)Content Hi, I'm creating a BI report to show Value Set Definition (Table Type) and wonder which…
-
Need to have Bar code on Oracle Fusion HCM BIP ReportsSummary Need to have Bar code on Oracle Fusion HCM BIP Reports - methods used not workingContent Hi, We have tried 2 methods for displaying bar code in BIP report follow…User_MC37Q 69 views 5 comments 0 points Most recent by User_2025-02-04-19-25-35-076 Reporting and Analytics for HCM -
Table name for Comments in a Learning CommunityContent For every learning community, members can comment using the seeded Comments functionality. We have a requirement to report on the comments made by the users. We …Venkata Sumanam 22 views 1 comment 1 point Most recent by Akash Kiran Jana Reporting and Analytics for HCM -
Get the list of persons included in an Access Group for a Learning OfferingContent Hi everybody, for an Offering in the Learning Catalog I have created an Access Group. I would like to extract from HCM tables the list of persons that are includ… -
how to get read only access to reports and analyticsSummary how to get read only access to reports and analyticsContent Hi Team - I need to grant only read access to Reports and Analytics page...With this grant,the user s…C.R.Balaji 385 views 3 comments 1 point Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM -
Filter Formula to automatically fill in the Hiring Manager based on user logged inSummary Is there a formula that will auto-populate a filter based on the user logged in (running the report)Content I am developing an additional tab within Hiring to po…User_2025-02-06-12-05-09-447 44 views 9 comments 0 points Most recent by Prudence K Reporting and Analytics for HCM
-
Reporting on Active User Role EmailSummary Email address for non-employee active user.Content Hi, I am developing a BIP report for Non-Employee Active User. But cannot find the table email address that wa…User_2025-02-04-07-19-57-588 51 views 4 comments 1 point Most recent by User_2025-02-04-07-19-57-588 Reporting and Analytics for HCM
-
Employee Self Service Transaction reportContent Hi, I`m trying to find the subject area for self service transactions - we need to ensure that for a period of time some employees aren`t putting through self se…User_2025-02-06-11-18-47-896 51 views 3 comments 1 point Most recent by User_2025-02-06-11-18-47-896 Reporting and Analytics for HCM
-
Subject area for individual compensationContent Hi , I`m trying to build a report for bonus payments that we make to employees for various bonus plans we have - recognition, excellence etc. I can not find this…User_2025-02-06-11-18-47-896 70 views 3 comments 0 points Most recent by User_2025-02-06-11-18-47-896 Reporting and Analytics for HCM
-
How to ensure a Manager is not seeing their own data when viewing a dashboard reportSummary Is there a way to ensure a Manager can't see their own data when viewing a dashboard report?Content Is there a way to ensure a Manager can't see their own data w…User_2025-01-28-20-43-56-568 20 views 7 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Listagg Function on Business Intelligence Subject AreasSummary How to use Listagg Function on Subject areas on BI ReportsContent Hi Team, I have converted an OTBI an analysis to a BI Report. I would like to use Listagg funct…Kalyani Koylada 99 views 3 comments 0 points Most recent by Livia Popa-Oracle Reporting and Analytics for HCM
-
Password security for scheduled report outputSummary Password security for scheduled report outputContent HI Team, We have some sensitive HR BI reports and we are trying to schedule those reports to send the output…Pol Reddy 107 views 7 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM -
Pay Period Start & End Date IN BI ReportSummary Pay Period Start & End Date IN BI ReportContent Hi ALL, Can someone help me, I'm looking for Pay Period Start and END Date. Which table do i need to refer to get…User_2025-02-07-19-03-14-525 38 views 4 comments 1 point Most recent by User_2025-02-07-19-03-14-525 Reporting and Analytics for HCM
-
No fact table exists at the requested level of detail (Assignment and DoR SAs)Summary [nQSError: 14025] No fact table exists at the requested level of detail (Assignment and DoR SAs)Content Hello, Just wondering if anyone faced this type of issue …SantoshKumarBhairi 58 views 19 comments 1 point Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Table that stores the BI scheduleSummary Table that stores the BI scheduleContent Can any one help us with the table that stores the scheduled jobs/reports in BI Publisher? We would like to get a report…GTS Narayanen 79 views 16 comments 0 points Most recent by GTS Narayanen Reporting and Analytics for HCM
-
How to: Translate BI Publisher Report ParametersSummary I wish to know if it is possible to translate BI Reports parameters based on user environment language.Version Oracle BI 11.1.1.9Nalinee Uppiah 108 views 7 comments 0 points Most recent by Nalinee Uppiah Reporting and Analytics for HCM
-
Formatting Code appearing in some columnsSummary Success Criteria & Comments ColumnContent Hi, I've just ran a Goals reports from the Workforce Management - Goals Tasks Real Time and found lots of formatting co…User_2025-02-05-22-44-35-842 30 views 6 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Infolet for Personal InformationContent Good Day All, i have created numerous infolets in the new UI and all work fine. One of the infolets is for Length of Service. Now if you are a Line Manager you w…CB Trett 89 views 4 comments 2 points Most recent by Swati SinghVerma Reporting and Analytics for HCM -
Can we query the list of custom BI reports and OTBI analysis in our instanceSummary The requirement is to pull the report name,report path, parameters and other corresponding attributes of a reportContent Hi, The requirement is to pull the repor…User_2025-02-07-18-15-37-534 63 views 5 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
New Hires in last 90 daysSummary New Hres reportContent Hi, I've found some examples of new hires report where the TIMESTAMP formula is -1 to show hire in the last year. How do I modify it to sh…User_2025-02-05-22-44-35-842 56 views 4 comments 0 points Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM
-
COUNT of new hires and veteransSummary Calculate the count of 2 custom fieldsContent Hi Team, I am calculating the count of employees who are new hires and veterans. Below is the query used which is n…Kalyani Koylada 57 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Need Sample Query on Head Count BIP ReportSummary Need Sample Query on Head Count BIP ReportContent Hi All, I am trying to build a Headcount Summary Report in BIP to achieve the below results, Head Count Summary…
-
Conditional Formatting of Blank Cells not workingSummary I want Null / Blank Cells in RedContent Hi, I have a report (see XML attached) that has 17 columns, some of which have missing data (NULLS). All I am trying to d…User_2025-02-05-22-44-35-842 33 views 13 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Future Starters / Pending WorkersSummary Need a list of pending workersContent Hi I'm trying to build a simple report that shows all pending employees (yet to commence employment). Which subject area sh…User_2025-02-05-22-44-35-842 85 views 7 comments 0 points Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM
-
Manager name for the CEOSummary After promoting an associate to CEO, the former CEO is still seen as his managerContent When our previous CEO retired, he was replaced by an associate within the…User_2025-02-05-12-06-38-063 50 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
sql to use to find out if someone is a line a manager ?Summary sql to use to find out if someone is a line a manager ?Content What sql to use to find out if someone is a line a manager ? We dont use the manager flag at assig…Ruzwan Akram 53 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM