Reviewing and Correcting Pricing Data

This section provides an overview of the error correction process, lists common elements, and lists the pages used to review and correct pricing data.

Page Name

Definition Name

Usage

Arbitration Plan Inquiry Page

EOEP_ARB_PLAN_INQ

Search for arbitration plan data in the staging tables.

Price Arbitration Attributes Page

EOEP_ARB_SEQ_INQ

Search for arbitration plan attribute data in the staging table.

Arbitration Plan Detail Page

EOEP_ARBPLN_EC_UPD

View and correct an error in the arbitration plan.

Attribute Detail Page

EOEP_ARBSEQ_EC_UPD

View and correct errors in the arbitration plan attributes.

Price Rule Inquiry Page

EOEP_RULE_INQ

Search for price rule data in the staging tables.

Price Rule Detail Page

EOEP_RULE_EC_UPD

View and correct an error in the price rule.

Price Conditions Page

EOEP_COND_INQ

View price condition data.

Price Condition Detail Page

EOEP_COND_EC_UPD

View and correct an error in the price condition.

Price Condition Conjunctions Page

EOEP_CONJ_INQ

View condition conjunction data for the price rule.

Condition Conjunction Detail Page

EOEP_CONJ_EC_UPD

View and correct an error in the condition conjunction for the price rule.

Price Formulas Page

EOEP_FORM_INQ

View price formula data for the price rule.

Price Formula Detail Page

EOEP_FORM_EC_UPD

View and correct an error in the price formula for the price rule.

Price Rule Distributions Page

EOEP_RDST_INQ

View price rule distribution data for the price rule.

Price Rule Distribution Detail Page

EOEP_RDST_EC_UPD

View and correct an error in the price rule distribution for the price rule.

Price Date Ranges Page

EOEP_DRANGE_INQ

View price date ranges.

Price Rule Date Ranges Page

EOEP_DRANGE_EC_UPD

View price rule date ranges.

Price Formula Ranges Page

EOEP_FRANGE_INQ

View price formula ranges.

Price Rule Formula Ranges Page

EOEP_FRANGE_EC_UPD

View price rule formula ranges.

Price List Inquiry Page

EOEP_PRCLST_H_INQ

Search for price list data in the staging tables.

Price List Page

EOEP_PLHDR_EC_UPD

View and correct an error in the price list header.

Price List Detail Inquiry Page

EOEP_PRCLST_D_INQ, EOEP_PRCLST_DH_INQ

Search and view price list details.

For price list details that do not have corresponding headers, for example, data from Price List Detail only messages, click the Search Price List Details Without Headers link.

Price List Detail Page

EOEP_PLIST_EC_UPD

View and correct an error in the price list detail.

Price List - Price Rule Links Page

EOEP_RLLNK_INQ

Search and view price rules for the price list.

Price Rule Link Detail Page

EOEP_RLLNK_EC_UPD

View and correct an error in the price rule for the price list.

When the Load Pricing Data process encounters data that might stop pricing or cause incorrect pricing, this data is not loaded to the pricing tables but remains in the staging tables. You can use inquiry pages to search for errors in these items:

  • Arbitration plans and arbitration plan attributes.

  • Price rules

    • Price conditions

    • Price condition conjunctions

    • Price formulas

    • Price rule distributions

    • Price date ranges

    • Price formula ranges

  • Price lists

    • Price list details

    • Price list-price rule links

    • Price list details without headers

Inquiry pages have a similar format and similar fields. From each inquiry page, you can navigate to the detail page to review and correct the error. After you correct the errors, run the Load Pricing Data process again to move the data into the application tables.

Field or Control

Description

Full Sync

Select Y (yes) to select full sync EIPs or N (no) to not select full sync EIPs.

Status

Select to narrow the search criteria.

Search

Click this button to search after entering search criteria.

Clear

Click this button to clear the search results.

Update

Click the Update button to view and update the errors.

Delete

Click this button to delete the selected row from the staging tables. All related data (child data) is also deleted. You receive a warning message before the delete is processed.

Select this row

Select this option to select a row. Then, click the links at the bottom of the page to navigate to the details about the data.