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. The source file returns all values in string format and it is enclosed in double quotes whether the data has null or empty value.
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.
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:
|
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:
|
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.