BI Publisher
Discussion List
-
Reporting ESS and MSS transactionsSummary Reporting ESS and MSS transactionsContent Is it possible to report on Employee Self Service (ESS) and Manager Self Service (MSS) transactions? What defines a ESS…Andrew_Schmitz 91 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Value Conversion through Mapping sheetSummary Value Conversion through Mapping sheet in OTBI reportContent Hello, I have created a new column in report with the values coming from another column using "Case …Urvashi Jain-160544 22 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Duplicate RowsSummary duplicate rows with left outer joinContent Hello. I need to build a report that returns benefit information for everyone with a column indicating if someone is o…User_F1ZIP 55 views 2 comments 0 points Most recent by Sricharan Monigari Reporting and Analytics for HCM -
Rating ColumnsSummary Unable to find last four columns related to ratingContent Hi All, I'm facing difficult in BI Report while fetching the values of rating columns related to Perfor…User_MC37Q 66 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Benefit Leave of AbsenceSummary BI Publisher table for Benefit Leave of AbsenceContent Hello. I am building a benefits/absence report and was wondering which table holds the field Benefit Leave…
-
BIP Report giving errorSummary BIP Publisher report giving error : Report data size exceeds maximum limitContent Hello, I created a BIP report with 30 columns and ~50k rows but report is showi…Urvashi Jain-160544 46 views 11 comments 0 points Most recent by Urvashi Jain-160544 Reporting and Analytics for HCM
-
Oracle HCM Client ToolSummary Can we install and configure BI client tools? if we are on cloud platform to generate a Metadata DictionaryContent Hello Everyone, We are researching on how to g…
-
Password Protecting BI Publisher Reports - Password ChangingSummary BIP Scheduled reports password changingContent Hi all, I've created a few BI Publisher reports with passwords and they've worked fine on the first part of the sc…Matthew Voss 62 views 4 comments 2 points Most recent by Lisa Whittleworth Reporting and Analytics for HCM -
Monitor an approval process:Content Hello, We need to build a report to help monitor approval processes within the system. Currently it seems there is no way to monitor the approvals … Is there any…Gal Shani-5131 216 views 17 comments 2 points Most recent by Safdar Hassan Reporting and Analytics for HCM -
Divya Joy 53 views 3 comments 0 points Most recent by Valeriy Gorbunov-80491 Reporting and Analytics for HCM -
Is it possible to get the dynamic file in BI Publisher?Summary Is it possible to get the dynamic file in BI Publisher?Content Hello Experts, In BIP, is it possible to show the run date including timestamp for the file name? …Harish Kumar Kovi 54 views 6 comments 0 points Most recent by Sricharan Monigari Reporting and Analytics for HCM
-
Need SQL to get Email Addresses for all Managers in Supervisor HierarchySummary SQL to get Email Addresses for all Managers in Supervisor HierarchyContent Hi Experts I am looking for a query which can get me a list of all supervisor's email …Mansur Khalil 217 views 3 comments 1 point Most recent by Jagdish Varadraj Reporting and Analytics for HCM -
IT: Looking for analytic/report versioning best practices and tipsSummary I'm looking for advice and best practices on versioning reports, analytics, and dashboards in a repository.Content Hi everyone, I'm looking for advice and best p… -
Email attachements are not getting generating for larger data files in BI Publisher schedulingSummary Emails attachments are not getting generating for larger data files in BI Publisher schedulingContent Hi Experts, We are facing one issue in BIP scheduling, we o…Harish Kumar Kovi 36 views 5 comments 0 points Most recent by Harish Kumar Kovi Reporting and Analytics for HCM
-
In Depth Report Building GuideSummary I'm looking for a guide or free resource on report building and editing.Content I've been building SQL reports for a few weeks now and am looking for resources t…David Rabalais 57 views 4 comments 0 points Most recent by David Rabalais Reporting and Analytics for HCM -
BI Publisher Query - Send Bursted Email (HTML) with separate PDF AttachmentSummary Is it possible to have two outputs in a BI Publisher Report?Content Hello, We have a BI Publisher report which sends an email (HTML) output, split and delivered …RebeccaAult1799 92 views 2 comments 15 points Most recent by RebeccaAult1799 Reporting and Analytics for HCM
-
Person Address HistorySummary Need to pull all addresses for specific personsContent We are finding all sorts of errors with our addresses; no end dates, multiple addresses of same type I am …Shawn McDonald 160 views 5 comments 2 points Most recent by Shawn McDonald Reporting and Analytics for HCM -
OTBI Customer SurveyContent p.p1 {margin: 0.0px 0.0px 14.0px 0.0px; line-height: 46.0px; font: 13.0px 'Helvetica Neue'; color: #000000; -webkit-text-stroke: #000000; background-color: #ffff…User720640-Oracle 42 views 0 comments 2 points Started by User720640-Oracle Reporting and Analytics for HCM -
Possibility of creating a report with Card Association ID'sSummary Has anybody got a report displaying Card Association ID'sContent Hi, We are looking to create a report identifying Calculation Card ID's We have looked at the fo…Brad Hughes 77 views 4 comments 0 points Most recent by VijayaBaskar Ranganathan Reporting and Analytics for HCM -
Is there any seeded Time Audit report available using BIP/OTBI?Summary Is there any seeded Time Audit report available using BIP/OTBI?Content Hi Team, I am trying to build a report, where we will show the Time audit details like Tim…Harish Kumar Kovi 58 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Report Job HistorySummary How to export all Report Job HistoryContent Hi Everyone, Could one of you help me with the following questions? 1. How can I export to an Excel all the Report Jo…Alvaro Couto 163 views 10 comments 3 points Most recent by Andrew_Schmitz Reporting and Analytics for HCM -
Employee Audit - Eliminated in 20AContent Hi all As many will know there was some Oracle communication surrounding the elimination of some reports when update 20A arrives. One of our reports that will be…
-
Report on Report permissions in BI catalogContent Hi, We define permissions under each report in custom folder. I wanted to know which all roles have permission on each report. Which tables can give me the data?…Nivya Mathire 82 views 1 comment 0 points Most recent by Sricharan Monigari Reporting and Analytics for HCM -
Employee Information Listed Report RequiredContent Hi Experts, Is there a report that provides the below information in a list? Attached Most of this information is pulled from the below areas: 1) Person Manageme…Tony Roff 30 views 1 comment 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Need to create an multi-tab excel output from an HCM extract XMLSummary Need to create an multi-tab excel output from an HCM extract XMLContent Hi Experts, I have an extract on Tax cards. My requirement is to have an excel output whi…Aloka Bhattacharya 80 views 8 comments 2 points Most recent by Valeriy Gorbunov-80491 Reporting and Analytics for HCM -
How to find how many times a report has been ran?Summary We wanted to identify how many times a report has been ran along with person numbers.
-
Need to pass the person name in the report URL parameters from the MSS pageContent We have a requirement where we are embedding a report URL in the Manager Self Service (MSS) page where he terminates an employee. Client requires that the report…Amrit 73 views 11 comments 0 points Most recent by Kalyan Amaravathi Reporting and Analytics for HCM -
Compare null value of label in OTBI reportSummary Evaluate if the return value is nullContent Hi everyone, I have a report to show certain information of an employee by organization that report works correctly b…Cesar Tepetla Corte 51 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Person Name Change and Primary Email ChangeSummary Need report to show if a name or email changed (can be in separate reports) from prior dayContent How can I get a report that shows if someone had a name change …Mike Borghoff 53 views 7 comments 0 points Most recent by Jagdish Varadraj Reporting and Analytics for HCM
-
How to fetch Cost Center Details which are mapped at Department LevelContent Hi Team, In our organisation we mapped Cost Center at Department level. How to fetch those cost center details. If anyone have SQL query please help me. I tried …Raviteja Sompalli 1.2K views 1 comment 0 points Most recent by Jagdish Varadraj Reporting and Analytics for HCM