As the cloud account administrator with the Functional Administrator or System Administrator application role, you specify the data load and reporting configuration details, and create data pipelines for functional areas that determine how the source data from Oracle Fusion Cloud Applications is loaded and displayed in the data warehouse.

Any data you load into the autonomous data warehouse in Oracle Fusion Data Intelligence is subject to the data access controls that may not always match those in the source system. For example, if User1 doesn't have the rights to access some data in your source system, then when you bring that data over to the autonomous data warehouse in Oracle Fusion Data Intelligence, this User1 can access that particular data. If you want to have the same controls on the data, then you must ensure that this particular User1 has the same data access rights as your source system in your Oracle Fusion Data Intelligence user setup.

After every data pipeline load, the system clears the cache in the back-end as a standard step. You don't have to take any action.