Reports
Discussion List
-
Looking for solution to "https://cloudcustomerconnect.oracle.com/posts/a3fe9e182c?commentId=407101#4Content Hi, I have a requirement exactly like "https://cloudcustomerconnect.oracle.com/posts/a3fe9e182c?commentId=407101#407101". I am not able to resolve it using MAX()…User_2025-02-06-14-37-05-233 37 views 2 comments 1 point Most recent by User_2025-02-06-14-37-05-233 Reporting and Analytics for HCM -
Recommend to RehireSummary Termination - Recommend to RehireContent Hi, Where can I find the 'Recommend to Rehire' flag value to report on? For context, when someone terminates a dropdown …User_2025-02-05-22-44-35-842 76 views 6 comments 2 points Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM -
Role related issue while running a BIP report via HR Dashboard in HCM CloudSummary Role related issue while running a BIP report via HR Dashboard in HCM CloudContent Hi, I have a BIP report developed which is working fine as is when checking da… -
Graphs in OTBISummary Can graph with data count be created in OTBIContent Can we create a graph close to how it is shown in the image in OTBI?pooja yelsangikar-Oracle 51 views 4 comments 0 points Most recent by pooja yelsangikar-Oracle Reporting and Analytics for HCM -
Unable To Export To CSVSummary Enable CSV is enabled in the data model, but am not able to export to CSV.Content We have an existing report that the business would like to be able to export to…Matt Isaacs 61 views 3 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
how to restrict an analysis to 1 assignmentContent In our HCM setup we can have people with multiple assignments which are active. What I want to do is get the most current/latest assignment. The primary flag doe… -
Shared mailing addressesSummary Require a report to show employees that have the same mailing addressContent Is it possible to generate a report that shows 2 employees residing at the same addr…User_2025-02-04-08-51-08-912 19 views 8 comments 0 points Most recent by User_2025-02-04-08-51-08-912 Reporting and Analytics for HCM -
No data in Human Capital Management - Approval Notification Real Time after Sep-2019Summary No data in Human Capital Management - Approval Notification Real Time after Sep-2019Content Hello I am trying to write a report to show the approval date for sic…Helen Thomas 38 views 13 comments 2 points Most recent by Linda Dunn Reporting and Analytics for HCM -
fields to use for employee bank account reportSummary what fields to use for employee bank account report?Content hi what are the correct fields and subject to use for getting a report of current employee bank accou…User_2025-01-29-02-09-34-137 146 views 11 comments 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM -
How to I achieve DD-MON-RRRR in output of BI publisher report for a dateSummary How to I achieve DD-MON-RRRR in output of BI publisher report for a dateContent Hi, I transform my date column in the required format using TO_CHAR(effective_sta… -
Can we limit the selection from the LOV in BI reports?Summary I want a functionality of my report to behave in a way where it should give me an error if I select more than 4 values from the LOV of 8 values.Content Hi, I wan…User_2025-02-07-18-15-37-534 46 views 2 comments 2 points Most recent by Sricharan Monigari Reporting and Analytics for HCM -
SQL Help required - pulling manager for rehiresSummary Query was built to pull in Areas of responsibility - Manager details but for rehires, it seems to be picking up their previous recordContent I have been trying t…User_2025-02-04-08-51-08-912 49 views 5 comments 1 point Most recent by User_2025-02-04-08-51-08-912 Reporting and Analytics for HCM -
Any way to restrict BIP output file either with Datamodel name or Template nameContent Hi All, When we click on OPEN on BIP report and enter required parameters and then click on apply button it will generate output in Excel format as DatamodelName… -
OTBI performance recommendations paper (2679006.1) is available on MOS PortalSummary OTBI performance recommendations V2 doc is intended for OTBI system integrators, BI report developers and admins. It covers advanced performance tuning technique…Pavel Buynitsky-Oracle 95 views 1 comment 11 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Need tables in fusion that store the Salary Details and Salary Component Breakup detailsSummary Need tables in fusion that store the Salary Details and Salary Component Breakup detailsContent Hi, Can anyone please provide me the table names that store the s…User_MC37Q 162 views 8 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Acting Up AllowanceSummary report showing old & new salaryContent Hi, I'm trying to build a report that shows employees that have or currently 'acting up' - I'd like the report to show the…User_2025-02-05-22-44-35-842 43 views 2 comments 1 point Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM -
Adding parameters for BIP Report built using OTBI AnalysisSummary How to add parameters within BIP Data Model built using for OTBI Analysis data set ?Content We have built a BI publisher report using a OTBI Analysis in the data… -
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 48 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 106 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 31 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 81 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 70 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 25 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… -
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 50 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 55 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 57 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 73 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 23 views 7 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM