Oracle Fusion Data Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Fusion Data Intelligence› Oracle Fusion Data Intelligence

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Triggers in OAX_User Schema

Received Response
25
Views
3
Comments
FDI_USER
FDI_USER Rank 4 - Community Specialist
edited April 23 in Oracle Fusion Data Intelligence

Hi Team,

Is it advisable to create triggers on OAX_User schema. If yes, what privileges are required. We have granted Create any Trigger to OAX_User but still getting Insufficient privileges.

We are loading a table from external source to ADW and creating a trigger to load data into other table in same schema with some other conditions.

Thanks

Tagged:

Answers

  • Sumanth V -Oracle
    Sumanth V -Oracle Rank 8 - Analytics Strategist

    @FDI_USER - Creating triggers in the OAX_USER schema within ADW of Fusion Data Intelligence (FDI) is discouraged due to:

    • Managed schema restrictions enforced by Oracle.
    • Potential conflicts with upgrade processes that may overwrite or break custom objects.

    Recommended Approach

    • Create a custom schema within ADW where you have full control and necessary privileges.
    • Grant required access to OAX_USER from your custom schema, allowing data interaction while keeping the core managed schema untouched.

    Oracle Documentation – Reset Password for Custom Schemas

  • PRATHEEK
    PRATHEEK Rank 4 - Community Specialist

    Can anyone recommend the best approach to pull Power BI data into Fusion Data Intelligence (FDI)?

    Currently, a customer has implemented Fusion ERP and is keen to start using FDI ERP Analytics. They have previously built several Power BI dashboards based on financial data.


    Is it possible to build any supporting data warehouse tables using Autonomous Data Warehouse (ADW)?

    Also, what is the benefit or purpose of connecting from existing Power BI datasets into FDI?

  • PRATHEEK
    PRATHEEK Rank 4 - Community Specialist

    @Sumanth V -Oracle @John Hung-Oracle @FDI_USER @Benjamin Arnulf-Oracle @Darryn Hinett-Oracle

    Can anyone recommend the best approach to pull Power BI data into Fusion Data Intelligence (FDI)?

    Currently, a customer has implemented Oracle Cloud Fusion ERP and is keen to start using FDI ERP Analytics. They have previously built several Power BI dashboards based on financial data.

    Is it possible to build any supporting data warehouse tables using Autonomous Data Warehouse (ADW)?

    Ideally aiming for single data lake for Power BI & FDI-ERP Analytics.

    Also, what is the benefit or purpose of connecting from existing Power BI datasets into FDI?