Reports
Discussion List
-
SQL query for Length of service in years and monthsSummary: Hi, I am trying to add formula in OTBI report on Service Date field to calculate duration in years and months. However, I don't know SQL, but was able to find b… -
SQL query to extract Candidates ResumeSummary: Content (required): Hello experts, we need to recover candidates resume URL. Is it possible to retrieve this information? Which table store resume URLs. Is ther…Valerio Curzi 444 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Not Able pull the Latest Location from "Workforce Management - Worker Assignment Real Time" subjectSummary: Hi, We created the new location and running the OTBI to get the data from subject area "Workforce Management - Worker Assignment Real Time" and has employee det…Kiran Kollamsetti 12 views 2 comments 0 points Most recent by Kiran Kollamsetti Reporting and Analytics for HCM -
Position details with transaction summarySummary: Hello Everyone, I have a requirement to create a position report with a real-time transactional summary. Columns are: I could fetch all the above eleven columns…Saher 51 views 11 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to know BI reports andOTBI Reports of scheduled report jobs and Agents list through query or anySummary: Hi Team, we have sceduled reports and OTBI reports through Agents how to get the list of reports scheduled from system any query or OTBI for ? we have report jo…AjayKumar Maddipati 72 views 2 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Payslip Reprinting Report flow does not Produce Output and cannot be opened because it has no pagesSummary: Payslip Reprinting Report flow is completed successfully and does not Produce Output and cannot be opened because it has no PDF (Blank) pages ####[2023-07-11T16…Janardhan ACS-Oracle 41 views 3 comments 0 points Most recent by Janardhan ACS-Oracle Reporting and Analytics for HCM
-
Timeout while using ESS to manage BI submissionSummary: Our ESS job keeps failing with an odd error but if we manually submit the BI it succeeds Content (required): We have a long-running BI query which has been gran…Scott Paulin 321 views 2 comments 0 points Most recent by Scott Paulin Reporting and Analytics for HCM
-
We have below EFF fields in per_person_eit_eff table but unable to find this table in Oracle DocsSummary: Hi Team, We have below EFF fields in per_person_eit_eff table but unable to find this table in Oracle Docs. Any one help me on ? Thanks, Ajay Content (required)…AjayKumar Maddipati 795 views 11 comments 1 point Most recent by Sudheer Patel Reporting and Analytics for HCM
-
Mouseover on Performance TileDears, is it possible to change somehow the mouseover on performance title? I've been trying to add an html "title" within the cell header but that did not work. Thanks …Domenico P. 41 views 3 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
Hierarchy not availble in BIWe have created an Organzaiotn Hierachy as per 1th of january 2023. The tree version is active, but noy (yet) avaliable in BI. Same for a Department Hierarchy. Is there …Wouter.Schaap 21 views 4 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Custom Performance Management Audit BI ReportSummary: Build a custom BI report that contains audit for performance document Content (required): Would like to know if there's an oracle hcm table to capture the previ…
-
Creating a My Reporting tab in HCMSummary: Anyone created a My Reporting tab in HCM with links to dashboards? Content (required): I was recently on a demo using the Vision environment and spotted that a …
-
Standard OTBI report displaySummary: Content (required): Hello everyone, We are experiencing problems with the visualization of a standard OTBI made available by Oracle that allows the 'department …Gerardo Peluso 33 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Form output created in BI PublisherI prepared a absence form using BI Publisher, when I add the relevant fields, it does not change according to the person, the only date is fixed. What could be the cause…Cansel Karasoy 61 views 15 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
BIP Report QuerySummary: Hi All, We created one BIP report where we can run by the Department name that shows all Position in the Department (both filled and vacant) and their Parent Po…Sakthi Priya S 41 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Executing seeded data model to display report - TalentProfileDMSummary: How can I run the seeded data model, TalentProfileDM, to review the data that I have input into the talent profile? Content (required): This is a massive data m…User_2025-02-05-22-55-58-511 31 views 1 comment 0 points Most recent by Welsey Reporting and Analytics for HCM -
I'm looking BI Report from skills and qualifcations page skills,cerifcations and languages cloumnsSummary: Hi Team, I have below code but unable to find the below cloumns in Bi report. Navigation of UI- ME>Performance>Skills and Qualifications In that we have section…AjayKumar Maddipati 42 views 1 comment 0 points Most recent by Preethi-Oracle Reporting and Analytics for HCM
-
In OTBI Report,we are used Worker assignement Event Real time but "State" column not available ?Summary: Hi Team, In OTBI Report, we are used most of the employee address columns from ( Worker assignement Event Real time) subject area but "State" column not availab…AjayKumar Maddipati 31 views 3 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
OTBI Union Query - R12 - Career StatementsSummary Report working in R11 but union no longer working in R12Content Hello I have an analysis in R11 that we use to identify the % of staff who have a career statemen…Andrew Braid 100 views 7 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Is there query to get Audited performance management rows?Summary: Is there already a default query on the system that retrieves audit values for performance management? We have already turned the performance management object … -
Can the Performance Review, Comments section font be made uniform when using custom font?Summary: When creating a custom version of the employee and manager printed performance review document in BI, we are unable to force the font in an open text comment se…Kelly Soos-Fell 22 views 3 comments 0 points Most recent by Kelly Soos-Fell Reporting and Analytics for HCM
-
Excel BIP report: Comment field split over several rows and columnsSummary: BIP report: How can we make sure that comment field is not split up over several rows and columns when exporting report to Excel? Content (required): Hi, we hav…Franziska Reichel 776 views 6 comments 1 point Most recent by Lucian_Plamada Reporting and Analytics for HCM
-
Scheduled OTBI Report to provide output as on previous dateSummary: Want to schedule OTBI report which triggers output as on previous date as effective date Content (required): When OTBI report is scheduled, we have a requiremen…
-
Duplicated records on OTBI Report linked to different assignments on Person dataSummary Duplicated records on OTBI Report linked to different assignments on Person dataContent Duplicated records on OTBI Report linked to different assignments on Pers… -
The most data that we can get about an OTBI Agent that was shotSummary: Content (required): Hi there, i see that there are a few posts about getting detailed data about if OTBI agent shot successfully and getting more details. I saw…Bobby Jourdan 11 views 2 comments 0 points Most recent by Bobby Jourdan Reporting and Analytics for HCM -
we ae getting multipule dublicate records in BI report with out any changeSummary: HI Team, we have absence reports but in recent we observed multiple dublicae records for each employee how can we sorted out this issue ? example: one employee …AjayKumar Maddipati 32 views 7 comments 0 points Most recent by Riyaz Ali-Oracle Reporting and Analytics for HCM
-
How to calculate cost of sickness in UKSummary: Calculate the cost of sickness using salary from element entry Content (required): I have been asked to calculate the quarterly cost of sickness. I was wonderin…Isabela Radivoi 21 views 2 comments 0 points Most recent by Isabela Radivoi Reporting and Analytics for HCM -
Prompt for Assigned on Date and Completion Date are not filtered based on the security of user (OLC)Dears, I've created a prompt with two filters: YEAR(Learning Record Details.Assigned on Date) YEAR(Learning Record Details.Completion Date) I don't understand the reason…
-
Need help with SQL query (OBIEE Dataset)Summary Building a report showing a persons information on 2 different dates - need help with some sql design (if possible)Content Hi All, I am trying to build a report …User_2025-02-04-08-51-08-912 40 views 6 comments 0 points Most recent by Roma Pandey Reporting and Analytics for HCM
-
Time Entry report to get updates and deletion of time entrySummary: Need a report for time entry to pull all new creation, updated and deleted records. Content (required): We have a requirement for integration where we need to g…Raghavendra M 72 views 9 comments 0 points Most recent by John Finnegan-Oracle Reporting and Analytics for HCM