Categories
Triggers in OAX_User Schema
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
Answers
-
@FDI_USER - Creating triggers in the
OAX_USERschema 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_USERfrom your custom schema, allowing data interaction while keeping the core managed schema untouched.
0 -
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?
0 -
@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?
-5
