Configure Offerings to Extract

You can select offerings that you want to extract, specify VOs from which to extract data, and set up once-only or regular data extracts in the Offerings dialog box.

Click the Manage Offerings and Data Stores button in the panel tab and select the Manage Offerings and Data Stores link to open the Offerings dialog box.

Offerings

Field Name or Option	How to Use
Offerings list	View the offerings that are available for extraction. Click an offering to view and configure its data stores.
Search	Enter an offering name and click Search to locate it in the list.
Actions > Create Offering	Create a new offering and specify its VOs.
Actions > Reset Last Extract Date	Specify the last extract date from which extraction should begin for incremental loads.
Actions > Configure Flex Label Languages	Specify a language for flexfield labels.
Actions > Extract Preferences	Specify extract parameters, including: job timeout; CSV file size to split files by; retry parameters in case of intermittent BI Server connection or query failures; and extract schedule email notification frequency and recipients.
List View	View the Offerings list as a list with Actions icon for each offering.
Grid View	View the Offerings list as a grid with Actions icon for each offering.
Offering Action > Delete	Delete the currently selected offering and its corresponding VO association. Available only for user-defined offerings.
Offering Action > Edit	Change the Offering Name and VO association of the currently selected offering.
Offering Action > Reset to Shipped Content	Reset the offering to shipped content, removing any changes made.
Offering Action > Reset to Full Extract	Reset the last extract date so that a full data load is performed for the offering, instead of an incremental load. You typically use this option if your business requirements have changed or when fact data has been corrupted.
Offering Action > Reset All Data Stores To Shipped Content	Reset all the mapped data stores to the shipped content, removing all changes made until that point.

Click the Manage Offerings and Data Stores button in the panel tab and select the Export Modification link to collect modification information from the source environment and export it as compressed CSV files.

Export or Import Customization is used to export or import all user customized metadata from one environment to another of the same version. You can export all jobs or a specific job. To export a specific job, click Manage Offerings and Data Store button and select Export Modification. On the Export Modification dialog box, click the Jobs checkbox, select the specific job from the list, and click OK.

Select the Import Modification link to apply modifications to the destination environment using the exported compressed CSV files. On the Import Modification dialog box, click Browse and select the exported files, and click Import.

Note: If you reset all data stores at the offering level before performing the import, the PVOs attain the schema definition of the imported files.

Data Store for Offering: Offering name

Click an offering in the Offerings list open the Data Store for Offering: Offering Name page, where you can specify View Objects VOs from which to extract data.

Field Name or Option	How to Use
Data Stores list	View the data areas that are available for extraction for the offering you clicked.
View > Columns	Select columns to be displayed in the Offerings list.
View > Detach	Pop out the section of the dialog box so you can see more data.
View > Reorder Columns	Change the display order of the columns in the Data Stores list.
View > Query By Example	Filter the displayed results by entering the first few letters of a name.
Add	Specify a new Data Store for an offering. For example, you might want to add a view object (VO) for extraction. To add a VO, in the wizard’s Datastore details page, provide the VO name, then specify whether you want to disable effective data filter, which allows for extraction of all historical records, if required. Enter any required query filter, using column references following the format __DATASTORE__.<BI VO Column Name>. In the wizard’s Select Columns page, select the column types for the select query from the Column Filter list, then uncheck the columns you don’t want included in the SELECT list. If the VO is defined as Effective Date Disabled, you can select the Natural Key option for a Primary Key Column to define a natural key. To add a user-defined data store, enter the name of the VO and provide the name of its Available Offering. When you select the columns, select the primary key for the VO. It will now appear with the predefined VO's.
Remove	Delete the currently selected Data Store.
Refresh	Refreshes the Data Store list.
Query by Example	Filter the displayed results by entering the first few letters of a name.
Detach	Pop out the section of the dialog box so you can see more data.
Actions > Reset to Full Extract	Reset the last extract date so that a full data load is performed at the next load for the data store/VO, instead of an incremental load. You typically use this option if your business requirements have changed or if fact data has been corrupted.
Actions > Reset to Shipped Content	Reset the VO to shipped content, removing any changes made.
Actions > Export Metadata Definition (MDCSV)	Export metadata definition for the data store in the MDCSV format. The selected data store content is exported into a zip file that you can download. Here's some additional information about this format: File extension: .mdcsv Delimiter: ||| (three vertical pipes) Includes Primary Key columns: Yes Includes Incremental columns: No Includes Select List columns: No You can extract the metadata definition in this format when you run the data extracts.
Actions > Export Metadata Definition (CSV)	Export metadata definition for the data store in the CSV format. The selected data store content is exported into a zip file that you can download. Here's some additional information about this format: File extension: .csv Delimiter: , (comma) Includes Primary Key columns: Yes Includes Incremental columns: Yes Includes Select List columns: Yes You can't extract the metadata definition in this format when you run the data extracts.
Actions > Export UI Label	Export user interface labels for the VO. A zip file is generated with files for each configured language.
Actions > Download Sample CSV File	Verify the sample extract from the selected data store.
Actions > Advanced Extract Configuration	Specify initial extract date and chunking for creation date and primary key for full loads.
Actions > Manage Extract Mode	Specify the extract mode. When BI Broker extract mode is enabled, extract jobs don't use the BI Server. They interact directly with data stores and the Cloud Applications source database. To enable it, select BI Broker extract mode in the Manage Extract Mode dialog and click OK. A check is then performed to verify that BI Broker mode is supported for the data store, and if not an error is displayed.
Last Extract Date	View the date and time when the Data Store was last extracted.

Click the Configure Cloud Extract button in the panel tab and select the Review Cloud Extract Configuration link to return to the Enabled Data Stores dialog box.

Broker Extract Mode

BI Broker extract mode is supported for some data stores, and can be set at the data store, schedule, and job levels. When you set the mode, any affected data stores are verified for Broker mode support. If there's no error, the included data stores using the mode are extracted independently of the BI Server metadata, with extract queries running directly against the data stores in the Oracle Applications Cloud database, which can help extract performance.

New and Deprecated Data Stores

After an update, new and deprecated VOs are documented so that you can add new VOs and columns to your extracts and remove any that aren't available. For more information, see R13.x Deprecated and New BI View Objects.