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.
This section discusses:
Pricing EIPs.
Methods for sending pricing data.
Staging tables for loading pricing data.
PeopleSoft 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 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 |
See Also
PeopleTools PeopleBook: Integration Broker
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.
See Also
Understanding PeopleSoft Supply Chain Management Enterprise Integration Points
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.
This section discusses how to submit background processes to send pricing data.
Page Name |
Definition Name |
Navigation |
Usage |
EOEP_PRICE_EXTRACT |
Pricing Configuration, Pricing Data Exchange, Publish Pricing Data |
Submit the background process 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. |
This section provides an overview of the error correction process, lists common elements, and lists the pages used to review and correct pricing data.
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:
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.
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. |
Page Name |
Definition Name |
Navigation |
Usage |
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. |
|
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. |
|
EOEP_ARBPLN_EC_UPD |
Click the Update button on the Arbitration Plan Inquiry page. |
View and correct an error in the arbitration plan. |
|
EOEP_ARBSEQ_EC_UPD |
Click the Update button on the Arbitration Plan Attributes page. |
View and correct errors in the arbitration plan attributes. |
|
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. |
|
EOEP_RULE_EC_UPD |
Click the Update button on the Price Rule Inquiry page. |
View and correct an error in the price rule. |
|
EOEP_COND_INQ |
Select a row on the Price Rule Inquiry page and click the Price Conditions link. |
View price condition data. |
|
EOEP_COND_EC_UPD |
Click the Update button on the Price Conditions page. |
View and correct an error in the price condition. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
EOEP_DRANGE_INQ |
Select a row on the Price Rule Inquiry page and click the Price Date Ranges link. |
View price 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. |
|
EOEP_FRANGE_INQ |
Select a row on the Price Rule Inquiry page and click the Price Formula Ranges link. |
View price 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. |
|
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. |
|
EOEP_PLHDR_EC_UPD |
Click the Update button on the Price List Inquiry page. |
View and correct an error in the price list header. |
|
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. |
|
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. |
|
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. |
|
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. |
This section discusses how to load pricing data.
Page Name |
Definition Name |
Navigation |
Usage |
EOEP_PRICE_LOAD |
Pricing Configuration, Pricing Data Exchange, Load Pricing Data, Price Loader |
Load pricing data from the staging tables into the application tables. |
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. |
This option is available only if the Load Full Sync Data option is selected. If the process encounters errors with the data, select either:
|