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…
DetailsWhen you are running Oracle Fusion Cloud Applications, Oracle Fusion AI Data Platform (FAIDP) and Microsoft Power BI occupy very different roles in your analytics stack: FAIDP is a curated, Oracle-managed analytics platform, whereas Power BI is a flexible, tool-agnostic BI front end that you must integrate and govern yourself. Despite these differences, organisations often…
Details
Celebrating Our Oracle Analytics Cloud 2025 Certification We’re proud to announce that our team at Advised Solutions has earned the Oracle Analytics Cloud 2025 Certified Professional credential. This milestone reflects our continued commitment to excellence in data analytics and our deep expertise across the Oracle Fusion Cloud platform. Building on years of delivering successful solutions…
Details
::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…
Details
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).
Details
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.
Details
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.
Details
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.
Details
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
Details
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…
Details