Understanding Item Price List and Item Master EIPs

The Item Price List EIP enables you to receive item price data from third-party sources. The third-party source sends the item price data using a flat file or an XML based service operation to load data into the item price list staging tables. A third-party system can send item price information using the ITEM_PRICELIST_LOAD service operation in the ITEM_CATALOG_PRICE queue.

The Item_PriceList_Load service operation is specific to loading supplier items. You cannot create an item without providing a supplier using this feature. If the price that is sent by the supplier is for the same unit of measure (UOM), currency code, and date as the one that exists in the system, the price will be updated. If any of these attributes are different, the price will be inserted as a new effective-dated row. In the event that the supplier does not provide the date, the Item_PriceList_Load service operation will use the system date.

The Item Master EIPs enable you to send and receive item master data to and from third-party sources. The third-party system sends the item master data using an XML based service operation to load data into the item loader staging tables. You can send item master data to a third-party system using the ITEM_SYNC, ITEM_SYNC_EFF, ITEM_FULLSYNC, or ITEM_FULLSYNC_EFF service operation in the ITEM_MAINTENANCE queue. A third-party system can send item master information using the ITEM_SYNC or ITEM_FULLSYNC service operation in the ITEM_MAINTENANCE queue.

Item records that are received through the item master EIPs are staged directly in the Item Loader staging tables. No intermediate staging or processing is required. Additionally, you can specify whether the Item Loader process should be launched automatically or manually as part of the item master EIP setup.

To set up the Item Loader process to start automatically as a part of the item master EIP setup:

  1. Access the Enterprise Components - Data Maintenance Utility Setup component.

  2. Select a transaction type of Item.

  3. Select the Flag 1 option to automatically start the Item Loader process for the item records in each item master service operation that is received.

    If the Flag 1 option is not selected, the new item records are inserted in the Item Loader staging tables, and you must start the Item Loader process manually to update the master data tables.

See the product documentation for PeopleTools: PeopleSoft Integration Broker.