1. Data Extraction Tool
  2. Map BICC Data to Business Object Data

6Map BICC Data to Business Object Data

This section explains how the generated Excel spreadsheet maps BICC data to business object data and how to use the spreadsheet to understand what data can be extracted and how it’s structured.

The spreadsheet serves as a reference to help you identify extractable BICC data and its corresponding mapping in business objects. Since each Oracle Fusion Applications release introduces new features, business objects, and BICC views, the mapping is updated regularly. Always download the latest version to stay aligned with recent changes.

Access the Mapping Spreadsheet

Download the BossBV_to_BICC_Database_Mapping spreadsheet. The spreadsheet is regenerated with each Oracle Fusion Applications release and posted on My Oracle Support (KA1401). Always download the latest version to ensure you’re using the most current mappings.

Spreadsheet Structure

The spreadsheet contains two worksheets, each serving a distinct purpose:
  • Release Information: Describes mapping changes introduced in each Oracle Fusion Applications release. Use this worksheet to track newly added views and changes to existing mappings.
  • BOSS BV to Database Tables: Provides the detailed mapping between BICC public view objects and business objects available in the read-optimized data store.

When a BICC public view object is a flat extract, it can be mapped directly to the corresponding business object available in read-optimized data store. The mapping is defined at two levels:

  • From the BICC public view object to the business object
  • From individual attributes in the BICC view and the business object view, highlighting commonalities and differences

Column Descriptions

These columns in the BOSS BV to Database Tables worksheet describe how BICC views map to business objects and database tables:
  • Column A – Display name of the business object view as shown in the tool
  • Column B – Internal name of the business object view
  • Column C – Path and name of the BICC public view object
  • Column F – Commonality indicator that identifies the database table shared by both the BICC public view object and the business object

Columns D, E, and G describe attribute-level mappings. After the underlying database table is identified, its columns are mapped to both the BICC view and the business object view.

In Column E, some attributes appear in dot notation, which indicates a navigation path. Business objects convert foreign key references into object references. For example, the database table INV_ABC_CLASSES contains the column ORGANIZATION_ID. In the BICC public view object, this appears as OrganizationId. In the business object, the value is retrieved through an object reference to the organization instance and is shown as organization.id.