Oracle Fusion’s Data Extraction Tool: A Modern, Secure Way to Get Data Out Oracle Fusion’s new Data Extraction tool is a Redwood‑based, self‑service utility for securely extracting large volumes of application data from a Read‑Optimised Data Store, designed as the long‑term successor to BICC. It emphasises performance, simplicity, and governance, making it a strong fit…
Details
Using the GET_VALUE_SET function in an Oracle BI Publisher Data Model lets you reuse secured, table‑validated value sets to drive report logic. It is especially useful when your report must respect the same business rules and filters already modelled in the application.
DetailsChoosing between Oracle Transactional Business Intelligence (OTBI) and Oracle Fusion AI Data Platform (FAIDP, formerly FDI) can make or break your reporting strategy. Like weighing Fusion AI Data Platform against Power BI, it’s about matching tools to real-world needs—operational speed versus strategic depth. What They Are OTBI provides embedded, real-time reporting straight from Fusion Applications…
Details
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