BI Publisher
Discussion List
-
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 25 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 55 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 28 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 36 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 24 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 52 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 27 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 26 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 21 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 50 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 426 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 56 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 258 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 21 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 40 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 22 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 32 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
-
Empty spaces in RTF if there is condition not to show a sectionContent We are working on Talent Profile print and it has multiple section so we are creating an RTF template and having a condition to display section conditionally to …User_2025-02-08-10-09-54-910 337 views 1 comment 0 points Most recent by Lucky Sharma Reporting and Analytics for HCM
-
Development Goals (individual) approval StatusContent How can I get the Approval Status and time approved into Development Goals Status Report. Saw a few recommendations but some seem to be for goal plan for perform…Mike Borghoff 35 views 2 comments 0 points Most recent by Mike Borghoff Reporting and Analytics for HCM
-
BI report based on questionnaireContent Hello, We need to create a BI report using following tables. HRQ_QSTN_ANSWERS_TL HRQ_QSTNR_PARTICIPANTS per_persons Appreciate if some one can let us know how to…User_2025-01-28-21-18-43-496 72 views 4 comments 1 point Most recent by User_X612P Reporting and Analytics for HCM
-
Survey ReportSummary survey report subject areaContent I am trying to build a report on the on-boarding survey responses. I have tried building the report in Workforce Management-Che…
-
Need sample query to check if employee has location as on hire dateContent Hi All, I'm in need of a sample SQL query to check if employee has location as on hire date.Please share if you have the same. Thanks, Ravichandran Version R13