I’m fairly new to working with Oracle Fusion and want to learn from others who have had to integrate it with their data warehouse environment.
If you’ve extracted Fusion data (via OTBI, BIP, APIs, or other methods) into a data warehouse
What are the biggest problems you’ve faced?
1 On the reporting side (gaps in OTBI/BIP subject areas, slow queries, performance bottlenecks, limited historical data).
2 On the ETL side (data volume/API limits, refresh windows, data quality issues, maintaining incremental loads, schema changes).
I’d love to hear what you’d do differently if you were setting up the pipeline again.
