Reports
Discussion List
-
Dashboard Prompt Not Working on Logical SQL AnalysisSummary Dashboard Prompt Not Working on Logical SQL AnalysisContent Hi experts, - I have created a report using Logical SQL. Please see attached. - I created a dashboard…Raymund Jerome 24 views 15 comments 0 points Most recent by Shail Parekh Reporting and Analytics for HCM -
Use of dynamic URL to run the report on Home page linkWe have created a BIP report and used that URL to create a page link on the Fusion Home page. At present, configured using Static URL on the link and it works fine. The …Vijay Ramani VJ 33 views 2 comments 0 points Most recent by Vijay Ramani VJ Reporting and Analytics for HCM -
Reporting on ICD/Manage Personal Contribution Requests that have been SavedSummary: Content (required): We use Individual Compensation Distributions for our employees to claim for irregular payments (overtime worked etc.) as we are not yet usin…Leanne W 9 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Need query to get the list of all privileges for a given roleSummary: Need query to get the list of all privileges for a given role Content (required): Navigation: Tools > SecurityConsole > Roles If I query a role name, I am getti…Jaeyshree Kumaran Kalpana 34 views 7 comments 1 point Most recent by Jaeyshree Kumaran Kalpana Reporting and Analytics for HCM
-
Understanding Actual Termination Date and Per_Periods_Of_ServiceSummary: Looking for SQL to pull in an accurate termination date given a point in time. And if that point in time is BEFORE the termination, then the business is wanting…SeanWesche 22 views 4 comments 0 points Most recent by Mandeep Gupta Reporting and Analytics for HCM
-
How to generate EEO-4 report in HCM?Summary: Generate EEO-4 report as per federal requirements Content (required): What are the set steps required to generate EEO-4 report from HCM? Version (include the ve…Akhil Pillai 12 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Need query to get scheduled process details such as process name, scheduled time, parameters.Summary: Need query to get scheduled process details such as process name, scheduled time, parameters. Content (required): I need query where I can get count of active s…
-
Tile visual errors when The Table Visual is not added to ViewSummary: Hi, can anyone please help with the error message that appears when Table visual is removed from the view leaving the Tile visual in view. Content (required): T…
-
report of all list of ESS jobs which are Running more than 24 hrsSummary: report of all list of ESS jobs which are Running more than 24 hrs Content (required): report of all list of ESS jobs which are Running more than 24 hrs Version …Swati U 20 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Is it Possible to remove Dashboard creation option from the RoleSummary: Is it Possible to remove Dashboard creation option from the Role Version (include the version you are using, if applicable): 22DHarishVummidi 11 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
How to report on Date Paid in last 12 monthsSummary: I have a report using the Payroll Balances Real Time subject area. The requirement is that when the report runs on the first day of every month, the output is f…JHaden3 11 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Audit report For Tax Withholding Calculation cards and table for Association, Federal & RegionalSummary: Need to develop a report that captures any changes made to the employee’s Tax Withholding cards such as Association,Federal, Regional. This report will be run u…
-
how to remove these BI reports shared over app within SaaSSummary: We currently have our talent reports exposed within SaaS as an app per the below screenshot. We would like them to be disabled/hidden/delete from the UI. Can so… -
Unable to see xls export option for BIP report after 22DSummary: Unable to see xls export option for BIP report after 22D Content (required): Hi , we are unable to see xls export option for BIP report after 22D and xlsx gives…PriyankaM 25 views 2 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
Need A Dynamic way of setting Date Parameters to begin with the 01st AprilSummary: Hi, I need to schedule an OTBI report that looks at changes made to a salary from the 01st April to the last day of the previous month. For example the report s…
-
Organization logo not showing up when exported (MHTML format)Summary: Organization logo not showing up when exported (MHTML format) Content (required): Hi , We have added organization logo in RTF header, and it shows up correctly …
-
An OTBI report in Workforce Management-Work Relationship subject area doesn't work for some rolesSummary: We have an OTBI Report with 4 columns, all under Workforce Management - Work Relationship Real Time category (Display Name, Person Number, Worker Payroll Name, …Justin Hurley 13 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Query to get ESS job details which are running more than 24 hoursSummary: Query to get ESS job details which are running more than 24 hours Content (required): Query to get ESS job details which are running more than 24 hours, I need …Swati U 29 views 2 comments 0 points Most recent by Shravan S Kumar-Oracle Reporting and Analytics for HCM
-
The promt does not affect the analysis report on the Dashboard screen.I have an analysis report that I use on the dashboard screen and parameters that I expect to affect this report, and one of these parameters does not affect the report, …Cansel Karasoy 38 views 6 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM
-
Using 2 different subject areas (Salary and Performance Rating) - Getting split/merged cellsSummary: Hi Experts, I'm pretty much a beginner with reporting. My client wants an OTBI report that can pull salary details as well as latest performance ratings (overal…Shubham Shree 27 views 3 comments 0 points Most recent by Sovitendu Jalli-Oracle Reporting and Analytics for HCM
-
How can I add the manager information of the employees to the Analysis report?I want to add the managers of the employees such as 'head,c-suite,sr.head' to the report I prepared from the analysis report. When I get this information from the "Matri…Cansel Karasoy 33 views 4 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Which table holds the HR Representative Data for a particular employee?Summary Which table holds the HR Representative Data for a particular employee?Content Hi, Can anyone please let me know, which table holds the HR Representative Data fo…User_MC37Q 83 views 20 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Ability to scan all reports for specific fieldsSummary: Hi - We recently introduced a second Organization tree where we have only had 1 tree since our initial go-live in 2018. With the addition of this new tree, anyw…
-
Level 02 Organization Name (Business Area) Not Showing UpSummary: We are currently in the process of implementing ORC and we are trying to create some dashboards that we can use for requisition/candidate data. When we run the …Kyle Norris 56 views 15 comments 1 point Most recent by Sovitendu Jalli-Oracle Reporting and Analytics for HCM
-
Termination report for multiple work relationshipsSummary: I need a true termination report for when someone leaves an organization with multiple legal employers, and they have multiple work relationships. I know there …Jessica D 42 views 13 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Dashboard with BI report linkContent Dear All, I have a requirement to create a dashboard with the direct links of BIP reports. Whenever user clicks on the link, it should directly generate the repo…JYOTI MAURYA 91 views 9 comments 1 point Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Course Completion ReportSummary: Looking for something similar to what we see in the Learners section of a course/transcript. I'm able to build off of completed activities, but when an offering…Jessica D 15 views 2 comments 0 points Most recent by Abdul Rauf Mohammad-Oracle Reporting and Analytics for HCM
-
Function to replace accent characters with respective characterSummary: Function to replace accent characters with respective character ex: O'Brian to O Brian, Noël to be Noel I need something like ascii using which it will directly…
-
Unable to resolve " ORA-01427: single-row subquery returns more than one row"Summary: Hi Experts, When I open a BI report, I am getting, "ORA-01427: single-row subquery returns more than one row" Error. I checked each subquery and all subquery re…