Webi to obiee
Creating BICC extracts from oracle fusion application products for data extraction
17 October 2023

To extract data from a Fusion Applications Cloud data source, you use the BI Cloud Connector (BICC) Console to schedule a once-only or regular data load, known as a Cloud Extract.BI Cloud Connector provides the option to extract Fusion Data to both Universal Content Management (UCM) and Cloud Storage Service.

Cloud Data Extraction with Fusion Connector
webi to obiee

This content explains the process of extracting data from Fusion Applications Cloud using the BI Cloud Connector (BICC) Console. It covers scheduling Cloud Extracts, PVO associations, and DataTerrain's expertise in this domain.

Data extraction from Fusion Cloud using BICC for Cloud Extracts, PVO associations, and DataTerrain's expert assistance.

Extracting data from Fusion Cloud with BICC, managing PVO associations, and leveraging DataTerrain's expertise for seamless integration and optimization.

  1. Within BICC the public view object(PVO) is associated with the Oracle BI Applications (OBIA) offering. Each offering (Finance, HCM, SCM, etc.) contains multiple seeded PVOs. Each PVO within an offering extracts data from a group of tables.
  2. For example, if you select HCM offering for the extract, it includes a view object named ‘oracle.apps.hcm.action.publicView.analytics.ActionReasonsPVO’ as one of its PVOs. This view object extracts data from tables PER_ACTION_REASONS_TL and PER_ACTION_REASONS_B.
  3. The other PVOs seeded within Oracle HCM offering will extract data from a different group of tables.
  4. To add more data sources to seeded PVOs, you can use Cloud Extract Configuration and Extraction UI. There are two options when adding a data store; Fact Group or Dimension Group.
  5. Once the extract has been configured, you need to schedule using the ‘Manage Extract Schedules’ option.
  6. The file created by the Fusion BI Cloud Connector tool can be consumed and loaded into the target database by Oracle Data Sync tool.

DataTerrain with years of experience and reliable experts is ready to assist. We have served more than 200 plus customers in the US and an additional 60 plus customers worldwide. We are flexible in working hours and do not need any long term binding contracts.