BI Publisher
Discussion List
-
Format of Dates in Excel export shows date and timeSummary Excel Export shows date and time, skewing hire dates within reportContent I have an issue where when I export an analysis to Excel, when I look at the cell conte… -
Valid Job Grade reportingSummary We are trying to determine if we have muliple Valid Grades for Job CodesContent We found some Job Codes with multiple Valid Grades and I am having difficulty wri…User_2025-01-23-21-24-21-434 146 views 5 comments 2 points Most recent by Nitin.Goswami Reporting and Analytics for HCM -
TRU detail of an EmployeeSummary TRU detail of an EmployeeContent Hi While developing a report I have a road block to find Tax Reporting Unit detail of an employee. Can anyone please provide tab…User_2025-01-28-05-27-14-688 460 views 1 comment 2 points Most recent by Sricharan Monigari Reporting and Analytics for HCM -
Changes only data in BI ReportsContent Please consider the following scenario: The Department of an employee is updated from 'Department A' to 'Department B' on 15th December 2017. The report is run o…Amrit 326 views 9 comments 0 points Most recent by User_2025-01-25-06-20-12-259 Reporting and Analytics for HCM -
Report on Comments from Performance FormsSummary I'd like to report on the manager and employee comments from a performance docContent Managers and employees are asked to provide a rating and comment on each co…User_2025-01-25-00-37-41-739 243 views 2 comments 1 point Most recent by User_2025-01-25-00-37-41-739 Reporting and Analytics for HCM -
Table for getting the Scheduled HCM Extracts listSummary Need table names for getting the scheduled payroll flows listContent Hi All, I have a requirement to generate BIP report with all the scheduled payroll flows and…Sricharan Monigari 67 views 2 comments 0 points Most recent by Sricharan Monigari Reporting and Analytics for HCM -
OTBI Report giving No result from same subject areaSummary OTBI Report giving No result from same subject areaContent Hi Team, I am using ‘Workforce-Assignment Real time’ subject area. Our requirement like Division with …User_2025-01-30-05-05-05-573 59 views 8 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Retro ReportsSummary Retro ReportsContent EDIT: The newer version, after few bug fixes, can be found hereAllen D'Souza-Oracle 259 views 7 comments 3 points Most recent by Huda Husain Reporting and Analytics for HCM -
OTBI Head count report sorting by Division(Error: No Result Found)Summary OTBI Head count report sorting by Division(Error: No Result Found)Content Hi Team, I am looking for a report in OTBI with Division , Employee count and System pe…User_2025-01-30-05-05-05-573 82 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
OTBI Department Hierarchy Report giving No ResultsSummary OTBI Department Hierarchy Report giving No ResultsContent Hi Team, I am trying to run a OTBI report for Department/Organisation Hirarchy in my Client instance, h…User_2025-01-30-05-05-05-573 115 views 4 comments 0 points Most recent by User_2025-01-30-05-05-05-573 Reporting and Analytics for HCM -
BI publisher report for persons who ticked yes for an interview with their HR contact .Summary Tables where I can find question and responses for interview between salaries and their managerContent Hello, I want to create a report to display alls persons w… -
BIP Report: Show text values in column as clickable URLSSummary Is there any way to format BI Publisher data to show a true url that can be clicked using the interractive report viewer for Oracle FusionContent Hi all, We are …StuartHibbert 129 views 0 comments 0 points Most recent by StuartHibbert Reporting and Analytics for HCM -
Share information on how the security works with bi publisher example with PER_PERSON_SECURED_LIST_VContent Hello, I want to share with you some research we have done on this subject and how the security works. first the security is done with Virtual Private Database (…User_2025-01-25-01-33-46-269 440 views 2 comments 3 points Most recent by User_2025-01-25-01-33-46-269 Reporting and Analytics for HCM -
Reporting on a Additional Job FieldContent Morning All, If you see the document I have uploaded it will make more sense with Images. Wonder if you could help me to get the bottom of a reporting issue with…User_2025-01-28-18-35-09-769 33 views 4 comments 0 points Most recent by User_2025-01-28-18-35-09-769 Reporting and Analytics for HCM -
Seeking BIP report for Worker, Potential Life event and Processed Life EventSummary Seeking BIP report for Worker, Potential Life event and Processed Life EventContent I need a list of workers and their event information - Potential and Processe…User_2025-01-23-21-24-21-434 94 views 8 comments 0 points Most recent by User_2025-01-23-21-24-21-434 Reporting and Analytics for HCM -
Dynamic Image according to different legal employerSummary Dynamic Image according to different legal employerContent Hi, is it possible to create a report (rtf template trough Word BI Publisher add-on) with a dynamic im…User_2025-01-28-21-18-09-074 84 views 6 comments 0 points Most recent by Vikram Agarwal-43618 Reporting and Analytics for HCM -
Issue in SQL script to get Overall Summary section commentsContent Hi All, I have written a script to get comments entered by both Manager and Worker in the Overall Summary Section (OS) in the Performance Document. (See my scree…Achala Munasinghe 126 views 4 comments 1 point Most recent by Achala Munasinghe Reporting and Analytics for HCM -
Overall Manager CommentContent Hi all, can you kindly help me? I really need to export to report the comment inserted by the manager in the overall performance section (please, see image attac…User_2025-01-28-21-18-09-074 194 views 2 comments 0 points Most recent by Dr Surlina Yin-Oracle Reporting and Analytics for HCM -
BIP Report DashboardSummary Wanted to provide graphical view of BIP report in Manager DashboardContent Hi All, We have developed BIP Custom reports and we wanted to place it in Dashboard wi…Syed Badar 157 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
OTBI limitationsSummary What are the main OTBI limitations compared to BI Publisher?Content Hi Folks, Is there any place where I can find the list of restrictions on using OTBI? For exa…Alvaro Couto 180 views 12 comments 0 points Most recent by Alvaro Couto Reporting and Analytics for HCM -
Parameters resetting within BI reportSummary Parameters reset to default or All when refresh other parameters on change is selectedContent Has anyone encountered an issue in BI custom reports whereby a para…User_2025-01-22-19-40-50-705 204 views 2 comments 0 points Most recent by User_2025-01-22-19-40-50-705 Reporting and Analytics for HCM -
Problem when filtring on OTBI to take MAX(date) for many userSummary I want to filter for max(date) for many users , It works only for one user .Content Hello, I create a report to display person id with a item_text,but for each i…User_I6AXL 99 views 7 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Email BurstingSummary How to send BI report pdf output as attachmentContent There is a requirement to send the pdf output of a custom BI report to employees. I have added the bursting…Vivek Pathak-71652 94 views 9 comments 0 points Most recent by Mansur Khalil Reporting and Analytics for HCM -
Data PrivacySummary How do you share your reports with your users?Content Hi all - I submitted a post recently about how you share reports with users (through self-service and/or da…Prudence K 88 views 6 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
BIP Schedule ReportsSummary Need SQL query to get the information if anyone change the schedules of the reports.Content Hi All, We scheduled couple of BIP reports based on UTC (Ex: 09:00AM … -
Job Grade ReportSummary Report to connect Job Info to GradesContent I am looking for a way to pull on a single report Job Code, Job Name, Family, Function, Management Level, Job Level, …User_2025-01-23-23-44-45-599 169 views 6 comments 0 points Most recent by User_2025-01-23-23-44-45-599 Reporting and Analytics for HCM -
AutomailerSummary There is a requirement to create an automailer to employees with pdf outputs of two different BI reports as attachmentContent There is a requirement to create an…Vivek Pathak-71652 23 views 1 comment 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM -
How to display data in one row?Content I created a custom analysis to show performance ratings of employees but it shows manager ratings and employee ratings in two rows for the same performance docum…User_2025-01-28-21-18-43-496 80 views 2 comments 0 points Most recent by User_2025-01-29-23-59-58-976 Reporting and Analytics for HCM -
BIP Report for Absences Taken & Absences EligibleSummary How do I report on taken absences vs eligible absences?Content Hi all - I have a customer request for reporting on the vacation an employee is eligible to take f…Prudence K 152 views 5 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM -
Date format 'DD-Mon-YYYY' in OTBI Analysis PromptContent Can anyone please guide how to get the date format 'DD-Mon-YYYY' in the OTBI Analysis prompt. Please see the screen-shot attached, where I want to achieve it.Amrit 234 views 1 comment 3 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM