Loading Items and Prices Using the Item Price List EIP

This topic discusses how to load item price list data from a message or flat file to the item loader staging tables by using the Item Price List Load (RUN_PO_ITMLOAD) process. The new item records are inserted in the Item Loader staging tables with a Hold status.

To load item price list data, you complete these steps:

  1. Process the XML message (Item_PriceList_Load) or a flat file (PRICELIST).

  2. Run the Item Price List Load application engine process (PO_ITMLOAD).

  3. Run the Item Loader process (IN_ITMLOAD).

  4. Review errors.

Page Name

Definition Name

Usage

Inbound File Publish Page

EO_FILETOMSG

Run the Inbound File Publish process to transfer data that is in a flat file into the item price list load staging tables.

Item Price List Page

RUN_PO_ITMLOAD

Run the item price list load application engine process to specify the parameters for the PO Item Price List Load (purchase order item price list load) process.

Use the Inbound File Publish page (EO_FILETOMSG) to run the Inbound File Publish process to transfer data that is in a flat file into the item price list load staging tables.

Navigation:

Enterprise Components > Integration Definitions > Initiate Processes > Inbound File Publish

This example illustrates the fields and controls on the Inbound File Publish process page. You can find definitions for the fields and controls later on this page.

 Inbound File Publish process page

Transactions are processed automatically. You must load flat files using the Inbound File Publish page. Item data is placed into the item price list staging tables (ITM_LOAD_MST_EC, ITM_LOAD_INV_EC, ITM_LOAD_PUR_EC, and ITM_LOAD_VND_EC).

Use the Item Price List page (RUN_PO_ITMLOAD) to run the item price list load application engine process to specify the parameters for the PO Item Price List Load (purchase order item price list load) process.

Navigation:

SCM Integrations > Process Transactions > Items > Item Price List Batch Load > Item Price List Load

This example illustrates the fields and controls on the Item Price List page. You can find definitions for the fields and controls later on this page.

 Item Price List page

Use the Item Price List Load process (PO_ITMLOAD) to add system default values to the item definitions and to move items from the item price list staging tables to the item loader staging tables. The new item records are inserted in the item loader staging tables with a status of New.

Process Request Parameters

Field or Control

Description

All SetIDs

Select to load item records with any SetID attribute. If you do not select this check box, enter a value in the SetID field to restrict the loading process to a specific SetID.

All Suppliers

Select to load item records with any supplier attributes. If you do not select this check box, enter values in the Supplier SetID and Supplier ID fields to restrict the loading process to a specific supplier SetID or supplier.

All Manufacturers

Select to load items with any manufacturer attribute. If you do not select this check box, enter a value in the Manufacturer ID field to restrict the loading process to a specific manufacturer ID.

Note: If the system does not find the manufacturer attributes that are associated with imported item data in the Manufacturer table (MANUFACTURER), it creates a new manufacturer.

Run Options

Field or Control

Description

Purchasing Dflts From Category (purchasing defaults from category)

Select to use the item category defaults that you established in the Item Categories (CATEGORY_TBL) component when creating the Purchasing Item Attributes segment of the item.

Delete Loaded Items

Select to delete item records from the item price list staging tables as they are copied to the item loader staging tables. This setting enables you to work with smaller batches of item information by running the Item Price List Load process several times against the same item price list load staging tables until all records in the tables have processed. To keep the data in the staging tables for audit purposes, do not select this check box.

Auto Assign ID (automatically assign ID)

Select the method by which the process assigns item IDs: For All New Items or When Item ID is not specified.

Default Item Setid

Select the SetID that you want assigned to the loaded items if the item SetID is not provided.

Default Supplier Setid

Select the SetID that you want assigned to the loaded items if the item supplier SetID is not provided.

Run the item loader process (IN_ITMLOAD) to validate and transfer the item data into the PeopleSoft master data tables.

Use the Data Definition Maintenance page to review any errors that did not pass the validation portion of the Item Loader process.