If you are looking to build a data pipeline from Oracle Fusion to your data warehouse or database and would like to extract data from Fusion base tables or custom views, please take a look at BI Connector. It solves the problems posed by BICC and BIP-based extract approaches.