Using Configurable Item Templates with the Item Loader Process

The Item Loader process can use configurable item templates. When an item template list ID is provided to the Item Loader process, then the default values from the configurable template are used to define the items in the PeopleSoft item tables. The template list ID can be entered on:

  • The inbound Item_Sync EIP. The item template list ID is included in the message of the Item_Sync service operation at the master and business unit item segments. This service operation is asynchronous and is both inbound and outbound.

  • The IN_MST_ITM_XLS component interface and the accompanying PeopleTools-delivered Microsoft Excel spreadsheet when using the Excel to Component Interface utility.

  • The Item Loader process page.

Both the Item_Sync EIP and the IN_MST_ITM_XLS component interface can load item data with item template list IDs into the Item Loader staging tables. The template list IDs within the staging tables are used by the Item Loader process when creating the items in the PeopleSoft item tables. In addition, you can enter the item template list ID on the process page of the Item Loader. This template list is used when the item data in the staging table does not contain a template list ID. This template list enables you to use configurable item templates with item data that is staged from other sources, such as the Item Price List EIP.

In addition, the item template list ID field was added to the Data Definition Maintenance - Item Definition - General: Common page within the Maintain Data Definitions component (SCM Integrations, Transaction Error Handling, Maintain Data Definitions) for the ITEM transaction type, to enable you to correct the value.

The Cost Element field is also available on the Item_Sync EIP and IN_MST_ITM_XLS component interface.

The Item Loader process cannot use substitutes from the configurable item template.

For more information about the Item_Sync service operation, the IN_MST_ITM_XLS component interface, and the Item Loader process, see the "Loading Items" section of this product documentation.

For more information about the Excel to Component Interface Utility, see PeopleTools: PeopleSoft Component Interfaces, "Using the Excel to Component Interface Utility" topic.