Loading Data into Enterprise Pricer

This section discusses how to load pricing data.

Page Name

Definition Name

Usage

Load Pricing Data Page

EOEP_PRICE_LOAD

Load pricing data from the staging tables into the application tables.

Use the Load Pricing Data page (EOEP_PRICE_LOAD) to load pricing data from the staging tables into the application tables.

Navigation:

Pricing Configuration > Pricing Data Exchange > Load Pricing Data

This example illustrates the fields and controls on the Load Pricing Data page. You can find definitions for the fields and controls later on this page.

 Load Pricing Data page

Field or Control

Description

Pricing Data to Load

Select Arbitration Plan, Price List, or Price Rule to load the pricing data individually. You can also select All to load all the pricing data.

Perform Data Validation

Select this option to validate the data during the loading process.

Load Full Sync Data

Select this option if you want to process data from full sync EIPs. Data received after the last full sync EIP is not processed, and data received before the full sync EIP is discarded. If this option is not selected, then only incremental sync data received before any full sync EIP is processed.

For example, EIPs are received in this order: Price Rule incremental sync and Price Rule full sync, and Price Rule incremental sync. If the Load Full Sync Data option is not selected, the first Price Rule incremental sync EIP is processed. If the option is selected, the Price Rule full sync EIP is processed. Because the first Price Rule incremental sync was received before the full sync EIP, it is discarded. Also, because the last Price Rule incremental sync EIP is received after the full sync EIP, it is not selected for process. After the Price Rule full sync EIP is processed, the last Price Rule incremental sync EIP is processed from this page.

Note: Oracle recommends that you process EIPs as soon as you receive them.

Full Sync Error Option

This option is available only if the Load Full Sync Data option is selected.

If the process encounters errors with the data, select either:

  • No Data Will Be Loaded.

    All of the data is left in the staging tables. Existing data in the application tables will not change.

  • Valid Rows Will Be Loaded.

    If selected, the application table is replaced with valid data from the full sync EIP. Any invalid full sync data is left in the staging table with the full sync flag deselected so that you can correct them and load them later as incremental sync data.