BI Publisher
Discussion List
-
RFT with 82 column but word has limit of 63 columnsContent I need to develop a report with these 4 requirements: -column number 82 -Output format XLSX, -2 header rows -specific sheet name in the Excel with RFT template I…Nicola Petri 42 views 7 comments 0 points Most recent by Nicola Petri Reporting and Analytics for HCM -
Filter Job Names in BI Publisher reportSummary I need to remove some Job Names from reportContent Hi, How do I go about removing the job name: CLEANER from the report attached? There will no doubt be others t…User_2025-02-05-22-44-35-842 21 views 4 comments 0 points Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM -
Subject Area to determine the Minority/Non Minority Status of a personContent Hi , I want to use a Subject Area which determines the Minority/Non Minority Status of a person. Can anyone please suggest. Thanks, - ManishaManisha Chakraborty 25 views 3 comments 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM
-
Tuning SQL queriesSummary Does anyone have any hints or tips they can share on techniques to tune SQL queries in BI Data Models?Content I have a BI Report which contains a single data mod…Jon Taylor 73 views 2 comments 1 point Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM
-
OTBI: Need to display ratio between 2 analysis in a dashboard page.Summary OTBI: Need to display ratio between 2 analysis in a dashboard page.Content Hi, We have analysis 1: All Employees Head Count Analysis 2: HR Employees Head Count W…User_MC37Q 66 views 2 comments 0 points Most recent by User_2025-03-07-20-55-01-859 Reporting and Analytics for HCM -
How to meet that requirement for a report?Summary Output format XLSX, 2 header rows and specific sheet nameContent Hi community, I need to develop a report with these 3 requirements: -Output format XLSX, -2 head…Nicola Petri 27 views 3 comments 0 points Most recent by Sricharan Monigari Reporting and Analytics for HCM
-
HCM - Actual working hour and hourly wageContent Hello, I'd need to create a query (data model) for part-time employees in our organization for their actual working hour and hourly wage for a particular period …
-
Standard Working Hours and Standard Working Hours Frequency of Legal Employer or Legal Entity thru OSummary How to get the Standard Working Hours and Standard Working Hours Frequency of Legal Employer or Legal Entity thru OBIEEMark kristan De los Reyes 24 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Current and Proposed Values in a pending BPM workflowSummary Getting the Current and Proposed Values in a BPM workflow notification in BI reportContent We have a requirement to build a report where the HR Specialist can vi…Akash Kiran Jana 56 views 5 comments 0 points Most recent by Akash Kiran Jana Reporting and Analytics for HCM
-
BI Publisher Report - Prompt IssueSummary The drop down list for selecting criteria will not wipe cleanContent Hi, Everytime someone opens this report the Business Unit, Package Type, Legal Entity and Lo…User_2025-02-05-22-44-35-842 26 views 6 comments 0 points Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM
-
What Role or Privilege should a user get to be able to archive and OTBI reports?Content What Role or Privilege should a user get to be able to archive and OTBI reports? is archive button is not displayed for a user?Walid Hamdy 37 views 2 comments 1 point Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM
-
Add Date to Report OutputContent Hi all - I am really hoping you can help me solve this oddity with our BIP report export to Excel. A user reached out to me asking to turn back on the option of …Prudence K 29 views 7 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Subqueries in Logical SQLSummary I've probably failed at some simple syntax..Content Attempting to build some fairly complex queries using Logical SQL Analysis in OTBI. This query: SELECT "Worke…User_2025-01-28-21-32-42-630 51 views 4 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Response UI : Workflow Notification Report parameter valueSummary How to get the parameter value of TimeCardApprovalNotificationBulkReportContent Hi All, We are trying to customize TimeCardApprovalNotificationBulkReport workflo…Badresh Pottabathini-248836 26 views 1 comment 0 points Most recent by Karen Costakes Reporting and Analytics for HCM
-
Busting subject line is appending withContent Hi, We have a bursting query to send a password protected file to employee's email. Now the subject line of email is coming as "[Not Virus Scanned] Your monthly …Nivya Mathire 24 views 1 comment 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
need to generate BI publisher report in text format comma delimitedSummary need to generate BI publisher report in text format comma delimitedContent Hi, I have a requirement where I need to generate BI publisher report in text format c…
-
How to create a Report with trend and costing dff details?Summary How to create a Report with trend and costing dff details?Content Hello , In reports OTBI type , the purpose was to get the cost trend details and also the cost …Revital Mefano 22 views 7 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Need help on Employee Personal Contribution report buildSummary Need help on Employee Personal Contribution report buildContent Hi Team, We are in the process of developing a report that report will be used to identify employ…Mahendra 27 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
OTBI Analysis error - ODBC driver returned errorSummary I developed an analysis and it works for one user and error for anotherContent Hi All, I created one analysis and it runs find for one user and error to other on…Peoplesoft 51 views 3 comments 1 point Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
How to create XPT templateSummary How to create XPT templateContent How can we create XPT template outside Oracle BI Publisher tool and then upload it to a report? Without using the online templa…Abhishek Nigam 388 views 4 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
HR Executive Dashboards not available in Fusion HCM Rel 13 patch 20D.Summary HR Executive Dashboards not available in Fusion HCM Rel 13 patch 20D. BI version is Oracle Business Intelligence Product Version 11.1.1.9 (Build 11.1.1.9.0BIFNDN…Mohd Shahnawaz Mohd Merajuddin-Oracle 55 views 12 comments 0 points Most recent by Mohd Shahnawaz Mohd Merajuddin-Oracle Reporting and Analytics for HCM
-
How Do I Expand the Width of a BI Publisher ReportSummary How Do I Expand the Width of a BI Publisher ReportContent Hello Everyone, I created a BI Publisher Data Model for a new report. Then, I Viewed Data and Saved as …Daniel McMillian 238 views 4 comments 2 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
How can I get assignment manager list details when subject area doesn't have themSummary Subject area doesn't contain assignment manager listContent Hi I am trying to adapt a report for direct reports to a line manager only. However I've noticed some…LTalbott2 19 views 3 comments 0 points Most recent by Virginia M. Calvi Reporting and Analytics for HCM -
Absence Booked in future date with complete detailsSummary Absence Booked in future date with complete detailsContent Hi Team, We wanted to fetch all the employees who booked their absences in future-date (for example be…Mahendra 41 views 9 comments 0 points Most recent by User_2025-02-04-23-40-44-792 Reporting and Analytics for HCM
-
Controlling BIP icons options(Home,Catalog etc.) while adding BIP link on infolet ViewSummary Controlling BIP icons options(Home,Catalog etc.) while adding BIP link on infolet view.Content Hi All, I am working on one requirement of infolet there is a requ…User_2025-02-06-23-45-30-095 30 views 3 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
How to populate to date field based on from date in BI reportSummary How to populate to date field based on from date in BI reportContent Hi All, We have a custom BI report and there are two parameters "Date from" and "Date To". h…Pradvin Prabhakar 20 views 6 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM
-
Union Dues reportContent Hello, I am looking for a Union Dues report that is created in BI publisher. Please advise if anyone knows if it exists in the forum. ThanksUser_WHB5J 33 views 5 comments 0 points Most recent by User_2025-02-06-12-47-14-341 Reporting and Analytics for HCM
-
Can't unarchive catalog from Prod to DevSummary Get error message Compression - inflate Error -3 OK when trying to unarchive from Prod to DevContent Hi Apologies if this has been covered before but I couldn't …
-
Too much SQL!Summary Prompt not limiting by another field - Support have advised too much SQLContent Hi I'm getting an "unexpected token" error message when trying to limit one field…
-
Audit and Performance Monitoring for OTBISummary We want to track how many people are using OTBI analyses - looking for audit information similar to that available for BI PublisherContent We have recently set u…Sian S 100 views 6 comments 6 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM