Category: BICC

Creating BICC extracts from Oracle Fusion Application Products for data extraction

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. • 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. • 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. • The other PVOs seeded within Oracle HCM offering will extract data from a different group of tables. • 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. • Once the extract has been configured, you need to schedule using the ‘Manage Extract Schedules’ option. • The file created by the Fusion BI Cloud Connector tool can […]

Read More +