Reports
Discussion List
-
Feedback on Useful Seeded Manager Dashboards or Reports AvailableSummary Keen to learn from others of some basic reports that might be useful for managers to self-serveContent Cornwall Council went live with Oracle HCM, for HR and Pay…Abby Cockings 34 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Join Transaction Data with Assignment DataSummary How do I find hire transaction completion dates for certain assignment categories?Content Hello - I am trying to create an analysis in OTBI that compares the dat…User_2025-02-08-04-27-03-855 41 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Performance Document data odd in analysisContent When creating any simple analysis to find out the status of the performance document assigned to employees for some reason the analysis shows blank for the perfo… -
Report to extract approval rules configuration for HCM from FusionSummary Report to extract approval rules configuration for HCM from FusionContent Hi Team, I am looking for an option to extract the approval rules configured for HCM in…MandeepKGupta 439 views 1 comment 3 points Most recent by MandeepKGupta Reporting and Analytics for HCM
-
manager phone number details in OTBI reportSummary Is there a way to get manager phone number details in OTBI reportContent Hi All, We have a requirement to capture manager phone number in the report. trying to b…User_XT9HW 87 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to get a list of all languages from HRT_CONTENT_ITEMS_TLContent Hi, Under talent profile and language skills - how do I just get a list of all available languages? See they are hiding in HRT_CONTENT_ITEMS_TL but not sure how …King Jack 45 views 1 comment 2 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Default Package creaation for Event Trigger usageSummary Default Package creaation for Event Trigger usageContent Hi Experts, We have a requirement where we want to restrict a report access only a specific country empl…User_2025-02-06-09-41-56-955 56 views 3 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM
-
BIP report on Reverse terminationContent I have a requirement to build BIP report on Reverse Termination. Please let me know if someone has already built this report. Thanks in advance.User_2025-02-06-14-37-05-233 42 views 3 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM
-
Future-dated department showing up in report instead of current dataContent Department attribute in 'Workforce Performance - Performance Task Status Real Time' subject area is fetching future-dated assignment information for employee ins…User_2025-02-05-23-59-37-171 33 views 9 comments 0 points Most recent by User_2025-02-05-23-59-37-171 Reporting and Analytics for HCM
-
Is there a way to model different Department hierarchiesContent I am looking to essentially create a different Org/Dept reporting hierarchy and run an existing report using this hierarchy. The idea is to essentially do some c…Mario B 14 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Looking for Quadrant view of dashboard for BSCContent Hi, I have a requirement to build Quadrant view of dashboard for BSC. Please let me know if anyone can help me on this. Thanks. JyotiUser_2025-02-06-14-37-05-233 23 views 3 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Reporting on when someone became a line managerContent Has anyone developed a report that allows us to see when someone first has a direct report assigned to them or knows of anyway to do this? Version 20BUser_2025-01-31-00-25-12-234 18 views 2 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM
-
Linking Work Relationship Real Time and Worker Assignment Event Subject AreasSummary Trying to link subject areas for a reportContent We have a request to add a rehire recommendation field to a termination report that is using the worker assignme…
-
Looking for Position ReportSummary Would like number of unfilled positions, organization chartsContent Hi everyone - we are underway with preparing to implement Position Management. We currently u…Ashley Cossey 98 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI Workforce Trends - Time Column Values Are not Accurate or are BlankSummary Calendar Quarter and Calendar Month do not render correctly in the reportContent We have a requirement to show period active start and end headcount by different…Karen B 24 views 3 comments 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Calendar PromptSummary I would like to add a calendar promptContent Hi, I have added AsOf date prompts to various reports and here I would like to include a between date prompt using t…User_2025-02-05-22-44-35-842 72 views 5 comments 1 point Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM
-
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 34 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 74 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 49 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 59 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 17 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 34 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 140 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 39 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 46 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 93 views 1 comment 10 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM