BI Publisher
Discussion List
-
BI Folder: limit visibility only to specific application roleContent Hi all, I'm trying to understand how to limit the access to the 'Custom' folder under Shared folders -> Custom to only 1 specific Application role. We have enabl…Daniela Spaseska-Oracle 104 views 4 comments 0 points Most recent by User_2025-01-30-01-56-27-828 Reporting and Analytics for HCM -
Legacy Learning Detail Report (OLC) - BI Publisher ReportSummary Legacy Learning Detail Report (Oracle Learning Cloud)Content "Employee Legacy Learning Detail Report" is a report for Learning administrators to view all the Lea…Manoj.Gupta 149 views 5 comments 12 points Most recent by Manoj.Gupta Reporting and Analytics for HCM -
Error advanced sql request using two subject areasSummary avanced sql query errorContent Hello , Attached the request I did to display competeny proficiency and target for the job profile. I have an error message . Any …User_I6AXL 44 views 4 comments 0 points Most recent by Anil Pillaresetty Reporting and Analytics for HCM -
Report on PermissionsSummary I need a report on permissions for reports and other elementsContent Hi all - is there a way to audit what reports (prompts, dashboards, etc.) have what permissi… -
Day Name from DateSummary Function for DAYNAME in Sales OTBI not workingContent Hello, I am using this function: DAYNAME("Service Request"."Creation Date") and it is not returnning the da…User_2025-01-22-20-09-02-352 100 views 2 comments 2 points Most recent by Rupak Chowdhury-Oracle Reporting & Analytics for Sales -
BIP - Merging rows using an eText Template based on a conditionSummary The XML returned contains multiple rows for an employee, the requirement is to merge them all into one row using an eText TemplateContent Hi, We have a requireme…Brendon Charles-24581 35 views 1 comment 2 points Most recent by Sricharan Monigari Reporting and Analytics for HCM -
Competencies : target level and mine level in OTBISummary Competencies by target level and mine levelContent Hello, I cannot find in OTBI the mine level and target level . For example for the competency ITM_Architecture…
-
How to set up JNDI connection (BI Publisher)Summary We are not able to configure JNDI connection since we do not know what data source information to populate, more specifically for field 'JNDI Name'User_2025-01-29-22-32-56-118 47 views 1 comment 0 points Most recent by Shakher Sharma Reporting and Analytics for SCM
-
Report capturing BPM workflow configurationSummary Can we create a report to capture workflow configuration rules for validation?Content Hi All - We have almost 100 rules configured for *VariableAllocation task.I…User_2025-01-25-04-02-13-126 100 views 4 comments 1 point Most recent by Piyush Mohapatra -OC Reporting and Analytics for HCM
-
Position Change Report templateContent Hi folks, Could anyone share any position change report template? The report captures an employee's position title changes, which occurs to Promotion/Reorganizat…User_2025-01-29-23-35-12-713 271 views 3 comments 1 point Most recent by User_2025-01-29-23-35-12-713 Reporting and Analytics for HCM
-
Standard report to capture position changes for employeesSummary Position Change ReportContent Hi folks, Is there a standard Oracle report available now to capture an employee's position title changes, which occurs to Promotio…User_2025-01-29-23-35-12-713 288 views 3 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Self-Service & DashboardsSummary How do you share your reports with your users?Content Hello experts - I am hoping to find out best practices as to how you do reporting for your company (or how …Prudence K 113 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
BIP Report with OTBI PromptsSummary How do I create a dashboard that uses OTBI prompts for a BIP reportContent Hi all - we are experiencing an issue since our Rel12 upgrade, where the parameters fo…Prudence K 229 views 4 comments 0 points Most recent by User_2025-01-31-00-03-33-089 Reporting and Analytics for HCM
-
MAX formula with CONCAT calculated measureSummary Difficulty getting the formula to workContent The way our Talent Review Meeting's were created we were forced to use flexfields to store the data. So to include …User_2025-01-28-08-47-04-905 56 views 12 comments 0 points Most recent by User_2025-01-28-08-47-04-905 Reporting and Analytics for HCM
-
Is there a way to catch the No Results message with a user-friendly message?Summary Is there a way to catch the No Results message with a user-friendly message?Content A way to catch the No Results error message with a user-friendly messageI hav…Kimberly Nguyen 68 views 7 comments 1 point Most recent by Kimberly Nguyen Reporting and Analytics for HCM -
calcul division , result wrong OTBISummary result of Division of sum (measure ) /sum(measure ) is not goodContent Hello , I want to calculate the percentage of headcount by competency So I have the number…User_I6AXL 61 views 8 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Assignment Audit ReportSummary Looking for a report that includes Updated, Corrected, and Deleted AssignmentsContent Hello, I am searching for an existing report or a way to report an audit of…User_2025-01-28-17-24-53-863 204 views 4 comments 0 points Most recent by User_2025-01-28-17-24-53-863 Reporting and Analytics for HCM
-
Cloud HCM cannot enable writeback,,,Summary Unable to understand how to write back dataContent Hi All, I am attempting to write back to a dff that i created but have been unsuccessful so far. In OTBI the o…Nicolas Trojack-24006 28 views 8 comments 1 point Most recent by Anil Pillaresetty Reporting and Analytics for HCM -
High number of columnsSummary High number of columns in BIP reportContent Hello everyone, Could you please give some tips on what is the best layout output option in BIP for a report that has…Alvaro Couto 34 views 13 comments 0 points Most recent by User_2025-07-18-02-05-33-261 Reporting and Analytics for HCM -
What does DATA_DS G_1 mean in BIP?Summary What does DATA_DS G_1 mean in BIP?Content Hello All, I am running a SQL in BIP and it is returning DATA_DS G_1 (see attached SQL and screenshot of DATA_DS G_1). …User_2025-03-07-21-07-25-805 477 views 6 comments 1 point Most recent by User_2025-07-18-02-05-33-261 Reporting and Analytics for HCM