LOWER() + :xdo_user_name Creating user-aware BI Publisher reports with :xdo_user_name in Oracle Fusion Cloud means letting the report engine quietly inject the signed-in user into your SQL, then using that to drive row-level filtering. Why :xdo_user_name matters In Oracle Fusion Cloud BI Publisher, :xdo_user_name is a built‑in bind variable that resolves to the username of…
::NO_DATA_TO_PROCESS:: A schedule trigger in Oracle BI Publisher lets a report decide at runtime whether it should run, based entirely on whether a driving SQL query returns any rows. Using a simple EXISTS-based query, you can turn the trigger into a clear “yes/no” gate for your scheduled jobs. What a schedule trigger does A schedule…
Oracle Cloud Procurement leverages robust row-level security mechanisms to ensure users can view and manage only those requisitions and purchasing documents relevant to their authorised procurement Business Units (BUs).
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.