Staging Tables for Loading Pricing Data

When loading or updating data to Enterprise Pricer, pricing data is loaded into pricing staging tables.

This table lists the pricing enterprise staging tables and mapping to application tables in Enterprise Pricer:

EIP Staging Table	Enterprise Pricer Application Table	Description
EOEP_ARBPLN_EC	EOEP_ARB_PLAN	Price Arbitration Plan
EOEP_ARBSEQ_EC	EOEP_ARB_SEQ	Price Arbitration Attributes
EOEP_RULE_EC	EOEP_RULE	Price Rule
EOEP_COND_EC	EOEP_CONDITION	Price Condition
EOEP_CONJ_EC	EOEP_COND_CONJ	Price Condition Conjunction
EOEP_FORM_EC	EOEP_FORMULA	Price Formula
EOEP_RDST_EC	EOEP_RULE_DST	Price Rule Distribution
EOEP_DRANGE_EC	EOEP_DATE_RANGE	Pricing Date Range Record
EOEP_FRANGE_EC	EOEP_FORM_RANGE	Pricing Formula Range Record
EOEP_KVCNT_EC	EOEP_KEYVAL_CNT	Pricing Key Value Count
EOEP_RKVAL_EC	EOEP_RULEKEYVAL	Pricing Rule Key Values
EOEP_PLHDR_EC	EOEP_PRCLST_HDR	Price List Header
EOEP_PLIST_EC	EOEP_PRICE_LIST	Price List Detail
EOEP_RLLNK_EC	EOEP_RULLST_LNKk	Price List - Price Rule Link

The Load Pricing Data process (EOEP_PRICE_LOAD) moves data into Enterprise Pricer. This process validates the data, sets defaults, and loads valid data into the application tables.

Note:

If incoming data fails to validate during a real-time update, it is left in the staging tables. You can review it there and correct it using the error correction pages. You might need to run the Load Pricing Data process more then one time to ensure that the data is corrected and moved from the staging tables.

The Load Pricing Data process performs validations such as these:

• If the price rule changes, the price rule must already exist in the target system.

• If a price rule is added, a price rule with the same keys must not already exist in the target system.

• The price condition must have valid product, customer, and business units and a valid price rule.

• Required fields must have values.

Note:

If you are processing large volumes of pricing data and you know that the data is correct, then you can bypass the validation by deselecting the Perform Data Validation option on the Price Loader run control page.

In case of real-time EIPs (EIPs that are sent from the online pricing pages), the Load Pricing Data process runs automatically. If pricing is received as flat files from external systems, use the Flat Files Utility to load data into the target system. Data is stored in the staging tables, and then the Load Pricing Data process is run to load the data into the application tables.