Understanding Pricing EIPs

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

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. It is recommended 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 the product documentation for PeopleTools: 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.

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.