PeopleSoft Enterprise Pricer 9.1 PeopleBook

Using Pricing Data Enterprise Integration Points

This chapter provides an overview of pricing data Enterprise Integration Points (EIPs) and discusses how to:

Send pricing data.
Review and correct pricing data.
Load data into Enterprise Pricer.

Understanding Pricing EIPs

This section discusses:

Pricing EIPs.
Methods for sending pricing data.
Staging tables for loading pricing data.

Pricing EIPs

PeopleSoft Enterprise Supply Chain Management applications are delivered with many enterprise integration points (EIPs) for sending and receiving pricing data to and from a third-party system. These EIPs are service operations within PeopleSoft Integration Broker.

The service operations in PeopleSoft Integration Broker are delivered with a default status of Inactive. You must activate each service operation before attempting to send or receive data from a third-party source or another PeopleSoft application, such as PeopleSoft Enterprise Customer Relationship Management (CRM).

To set up your integration, use the information in the following table and refer setup instructions in the PeopleSoft Supply Chain Management Integrations 9.1 PeopleBook.

See Setting Up Service Operations.

Service Operation	Direction and Type	Handlers	Chunking Available?	Integrates With
ARBITRATION_PLAN_FULLSYNC ARBITRATION_PLAN_SYNC This EIP includes all of the data in the Arbitration Plan tables.	Inbound/Outbound Asynchronous	ProcessMessage	No	Third party
(PRICE_LIST_DETAIL_FULLSYNC, PRICE_LIST_DETAIL_SYNC) This EIP includes only the detail table of price lists. It is provided so that you can separate the header and detail in different messages. For example, when there are many detail records, you might want to separate the header and detail into separate messages to achieve better performance. Note. The Price List Header EIP must already exist in the system. We recommend that you run the Price List Header EIP first.	Inbound/Outbound Asynchronous	ProcessMessage	No	Third party
(PRICE_LIST_FULLSYNC, PRICE_LIST_SYNC) This EIP includes all the tables for price lists. It is suitable when the number of detail records for a price list is not enough to reduce performance.	Inbound/Outbound Asynchronous	ProcessMessage	No	Third party
(PRICE_LIST_HEADER_FULLSYNC, PRICE_LIST_HEADER_SYNC) This EIP includes only the header and price rule link tables. It is provided so that you can separate the header and detail in different messages. Use the Price List Detail message for the detail data.	Inbound/Outbound Asynchronous	ProcessMessage	No	Third party
(PRICE_RULE_DATA_FULLSYNC, PRICE_RULE_DATA_SYNC) This EIP includes all the tables for price rules.	Inbound/Outbound Asynchronous	ProcessMessage	No	Third party
(PRICE_RULE_KEYS_FULLSYNC) Enterprise Pricer uses a couple of tables to store information about rules to help the rule selection process during pricing. These tables are updated as price rules are updated or changed. The price loader program normally computes and updates these tables. However, in case of full table sync, you can provide existing data to avoid recomputation. If provided, data on this message is loaded when price rule data is loaded.	Inbound/Outbound Asynchronous	ProcessMessage	No	Third party

Methods for Sending Pricing Data

You can send pricing data in these ways:

Online in real time. This method is associated with online pages.

When data from the online pages is saved, the changed data is sent to the external systems. This result occurs only for active EIPs.
Using batch publish. Use the Pricing Data Publish page to select the pricing data to send to external systems.

To use this method, you must set up Batch Publish Rules (samples rules are provided).

Note. On the Pricing Data Publishing page, you must provide at least one value to select the data. All other fields are optional.
Using the Full Table Publish method. You can send all pricing data using this method.

The pricing data in the target system is replaced. To use this option, you must configure Full Data Publish Rules.
Using flat files. When setting up the Batch Publish Rule or Full Table Publish Rule, you can save the published data to flat files, and then load the flat files from the source system. You can use the Inbound File Publish utility to load the file from the source system.

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.

Sending Pricing Data

This section discusses how to submit background processes to send pricing data.

Page Used to Send Pricing Data

Page Name	Definition Name	Navigation	Usage
Pricing Data Publish	EOEP_PRICE_EXTRACT	Pricing Configuration, Pricing Data Exchange, Publish Pricing Data	Submit the background process to send pricing data.

Submitting Background Processes to Send Pricing Data

Access the Publish Pricing Data page (Pricing Configuration, Pricing Data Exchange, Publish Pricing Data).

Process Name

Select the name that you want to use to group EIPs that you want to publish together. All EIPs with this name are processed together. Set up process names using the Batch Publish Rules page: Batch Programs tab. To process the EIPs together, enter the same process name for each EIP on the Batch Programs tab.

Updated After Date

Select the data that you want published by the last update date.

Arbitration Plan, Price Plan and Price List

Select at least one value to send the EIPs. You can enter additional values as needed.

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.

Understanding the Error Correction Process

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.

Common Elements Used in This Section

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.
	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.

Pages Used to Review and Correct Pricing Data

Page Name	Definition Name	Navigation	Usage
Arbitration Plan Inquiry	EOEP_ARB_PLAN_INQ	Pricing Configurator, Pricing Data Exchange, Correct Staging Errors, Arbitration Plan, Arbitration Plan Inquiry	Search for arbitration plan data in the staging tables.
Price Arbitration Attributes	EOEP_ARB_SEQ_INQ	Select a row on the Arbitration Plan Inquiry page and click the Price Arbitration Attributes link.	Search for arbitration plan attribute data in the staging table.
Arbitration Plan Detail	EOEP_ARBPLN_EC_UPD	Click the Update button on the Arbitration Plan Inquiry page.	View and correct an error in the arbitration plan.
Attribute Detail	EOEP_ARBSEQ_EC_UPD	Click the Update button on the Arbitration Plan Attributes page.	View and correct errors in the arbitration plan attributes.
Price Rule Inquiry	EOEP_RULE_INQ	Pricing Configurator, Pricing Data Exchange, Correct Staging Errors, Price Rule, Price Rule Inquiry	Search for price rule data in the staging tables.
Price Rule Detail	EOEP_RULE_EC_UPD	Click the Update button on the Price Rule Inquiry page.	View and correct an error in the price rule.
Price Conditions	EOEP_COND_INQ	Select a row on the Price Rule Inquiry page and click the Price Conditions link.	View price condition data.
Price Condition Detail	EOEP_COND_EC_UPD	Click the Update button on the Price Conditions page.	View and correct an error in the price condition.
Price Condition Conjunctions	EOEP_CONJ_INQ	Select a row on the Price Rule Inquiry page and click the Price Condition Conjunctions link.	View condition conjunction data for the price rule.
Condition Conjunction Detail	EOEP_CONJ_EC_UPD	Click the Update button on the Price Condition Conjunctions page.	View and correct an error in the condition conjunction for the price rule.
Price Formulas	EOEP_FORM_INQ	Select a row on the Price Rule Inquiry page and click the Price Formulas link.	View price formula data for the price rule.
Price Formula Detail	EOEP_FORM_EC_UPD	Click the Update button on the Price Formulas page.	View and correct an error in the price formula for the price rule.
Price Rule Distributions	EOEP_RDST_INQ	Select a row on the Price Rule Inquiry page and click the Price Rule Distributions link.	View price rule distribution data for the price rule.
Price Rule Distribution Detail	EOEP_RDST_EC_UPD	Click the Update button on the Price Rule Distributions page.	View and correct an error in the price rule distribution for the price rule.
Price Date Ranges	EOEP_DRANGE_INQ	Select a row on the Price Rule Inquiry page and click the Price Date Ranges link.	View price date ranges.
Price Rule Date Ranges	EOEP_DRANGE_EC_UPD	Click the Pen button for the price rule on the Price Formula Ranges page.	View price rule date ranges.
Price Formula Ranges	EOEP_FRANGE_INQ	Select a row on the Price Rule Inquiry page and click the Price Formula Ranges link.	View price formula ranges.
Price Rule Formula Ranges	EOEP_FRANGE_EC_UPD	Click the Pen button for the price rule on the Price Formula Ranges page.	View price rule formula ranges.
Price List Inquiry	EOEP_PRCLST_H_INQ	Pricing Configurator, Pricing Data Exchange, Correct Staging Errors, Price List, Price List Inquiry	Search for price list data in the staging tables.
Price List	EOEP_PLHDR_EC_UPD	Click the Update button on the Price List Inquiry page.	View and correct an error in the price list header.
Price List Detail Inquiry	EOEP_PRCLST_D_INQ, EOEP_PRCLST_DH_INQ	Select a row on the Price List Inquiry page and click the Price List Detail Inquiry link.	Search and view price list details. Note. 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	EOEP_PLIST_EC_UPD	Click the Update button on the Price List Detail Inquiry page.	View and correct an error in the price list detail.
Price List - Price Rule Links	EOEP_RLLNK_INQ	Select a row on the Price List Inquiry page and click the Price List - Price Rule link.	Search and view price rules for the price list.
Price Rule Link Detail	EOEP_RLLNK_EC_UPD	Click the Update button on the Price List - Price Rule Links page.	View and correct an error in the price rule for the price list.

Loading Data into Enterprise Pricer

This section discusses how to load pricing data.

Page Used to Load Pricing Data

Page Name	Definition Name	Navigation	Usage
Price Loader	EOEP_PRICE_LOAD	Pricing Configuration, Pricing Data Exchange, Load Pricing Data, Price Loader	Load pricing data from the staging tables into the application tables.

Loading Pricing Data

Access the Load Pricing Data page (Pricing Configuration, Pricing Data Exchange, Load Pricing Data).

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. We recommend 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.

Process Name	Select the name that you want to use to group EIPs that you want to publish together. All EIPs with this name are processed together. Set up process names using the Batch Publish Rules page: Batch Programs tab. To process the EIPs together, enter the same process name for each EIP on the Batch Programs tab.
Updated After Date	Select the data that you want published by the last update date.
Arbitration Plan, Price Plan and Price List	Select at least one value to send the EIPs. You can enter additional values as needed.

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. We recommend 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.