When creating a List of Values (LOV) in Oracle Fusion Cloud ERP’s BI Publisher and displaying a concatenated string (e.g., PERSON_NUMBER-DISPLAY_NAME), the search functionality does not work unless you add an alias to the concatenated column in your SQL query.
Multilingual reporting is essential for global organisations. Leveraging BI Publisher and XLIFF files streamlines the translation process, allowing you to maintain a single report layout while supporting multiple languages.
Using for-each@section: with Microsoft Word’s native page numbering fields is a best practice for multi-section BI Publisher reports requiring accurate, reusable page counters.
This post discusses the use of conditional statements in Oracle BI Publisher. We will discuss IF Statements and also the Extended Functions: Choose, When, Otherwise
Using Default Date Parameters in Oracle BI Publisher Oracle BI Publisher allows you to set default date parameters dynamically in your report data models, making reports adaptive and eliminating the need for manual date input each time the report is run. These dynamic defaults empower automated scheduling and streamline user experience. Common Default Date Functions Here are…
Date handling is a cornerstone for accurate, timely analytics. Utilise OOTB repository and session variables to dynamically reflect data against calendar periods
Setting variables in OTBI empowers report developers to tailor report execution by dynamically controlling a report or simply producing finer logging for debug purposes.
The TIMESTAMPADD function is an indispensable tool for Oracle OTBI developers working with dynamic date calculations.
This blog post provides a comprehensive guide for OTBI users looking to leverage advanced filtering techniques with the FILTER() function.
Monitor your custom reports and their folder structure and incorporate this into your regular maintenance tasks to keep your reporting environment organised.