Working with Product Load EIPs

To work with product EIPs, use the Product Messages component.

This section provides an overview of product load EIPs and discusses how to view product summary errors and run the product load process.

Page Name	Definition Name	Usage
Summary Errors Page	OM_EIP_PRODUCTS	Navigate to the individual error pages.
Error Detail	OM_EIP_PROD_ERR	View the nature of the product error violations.
Product Definition Errors - Product Errors	PROD_ITEM_MD	View and correct product definition errors.
Product Currency Errors - Product Item Currency	PRODITEMCURR_MD	View and correct product currency errors.
Product Competitor Errors - Product Competition	PRODCOMPTTRS_MD	View and correct product competitor errors.
Product Specification Type Errors - Product Specification Type	PRODSPECSTYP_MD	View and correct product specification type errors.
Product Specification Errors - Specification Error	PROD_SPECS_MD	View and correct product specification errors.
Product Group Errors - Product Group	PROD_PGRPLNK_MD	View and correct product group errors.
Product Kit Errors - Product Kit	PRODKITCOMPS_MD	View and correct product kit errors.
Kit Component Price Errors - Kit Comp Price	KIT_COMPSPRC_MD	View and correct product kit component price errors.
Product UOM Errors - Product UOM (product unit of measure errors - product unit of measure)	PROD_UOM_MD	View and correct product UOM errors.
Product UOM by Currency Errors - UOM by Currency (product unit of error by currency errors - unit of measure by currency)	PROD_UOMCURR_MD	View and correct product UOM currency errors.
Product Price by BU Errors - Price by BU	PROD_PRICEBU_MD	View and correct product price by business unit errors.
Product Price Errors - Product Price	PROD_PRICE_MD	View and correct product price errors.
Product Load Page	RUN_OM_LOAD_PROD	Load rows from staging tables to production tables after correcting the errors.

PeopleSoft software is delivered with many enterprise integration points (EIPs) to send and receive product and product group data with a third-party system or another PeopleSoft application, such as CRM. These EIPs are service operations within PeopleSoft Integration Broker.

Oracle delivers the service operations in PeopleSoft Integration Broker 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 system, such as CRM.

If both PeopleSoft CRM and SCM are installed, Oracle recommends that you:

Synchronize the product table by performing a Full Batch Publish to the subscribing system.

Note: If you are the master system of record, we do not recommend that you perform a full subscribe on the master files while they are in production.
Provide updates to the subscribing system with the incremental messages.
Maintain products on PeopleSoft SCM and publish them to CRM.
Before publishing the Product full sync message, enter matching values in the product brand table PROD_BRAND_TBL. If you do not enter the values in the product brand table, errors may occur in either the CRM or SCM databases.
Place effective-dated messages in a separate effective-dated message channel.

Use the information in the following table and refer to the setup instruction in the PeopleSoft Supply Chain Management Integrations Documentation, "Implementing Integrations" topic, Setting Up Service Operations section.

Service Operation	Direction and Type	Handlers	Chunking Available?	Integrates With
PRODUCT_FULLSYNC	Inbound/Outbound Asynchronous	ProductFullSync	No	CRM, Third-party
PRODUCT_SYNC	Inbound/Outbound Asynchronous	ProductSync ProductSyncEff	No	CRM, Third-party
PRODUCT_FULLSYNC_EFF	Outbound Asynchronous	NA	No	CRM, Third-party
PRODUCT_GROUP_FULLSYNC	Inbound/Outbound Asynchronous	ProductSync ProductSyncEff	No	CRM, Third-party
PRODUCT_GROUP_FULLSYNC_EFF	Outbound Asynchronous	NA	No	CRM, Third-party
PRODUCT_GROUP_SYNC_EFF	Outbound Asynchronous	NA	No	CRM, Third-party
PRODUCT_SYNC_EFF	Outbound Asynchronous	NA	No	CRM, Third-party

If errors occur while you are subscribing to product data coming in from another system, the faulty data remains in staging tables and you can correct it online from the Summary Errors page. Correct errors for these types of data:

Product Definition (PROD_DEFN).
Product Groups (PROD_GROUP).
Product Kit (PRODKIT).
Product Kit Component Price (PRODKIT_COMPS_PRC).
Product Attributes by UOM (PROD_UOM).
Product Price (PROD_PRICE).
Product Specifications (PROD_SPECS).

For each type of product error, two types of error pages are available.

The first error page type lists all the data errors that you need to correct; the fields in error are the only ones available for data entry.
The second error page type lists specific data errors and explains the nature of any violations in depth.

Many errors can occur when the business unit is incorrect. This is because many of the edits depend on SetID. When the business unit is not valid, the system cannot derive a SetID. Even though the data (other than business unit) appears correct, an error may occur because of an invalid business unit. Correcting the business unit often resolves other edit errors.

All edits are case-sensitive. Some fields are listed on the error pages as uppercase, even though the data in the database is lowercase. In this case, the data must be saved, and as long as the uppercase value is valid, the error should be resolved.

Perform these steps to correct product errors.

Use the Summary Errors page to view all the product-related errors for a particular EIP Control ID.
Navigate to individual pages to correct the errors. As errors are corrected, you no longer can view them from the Product Summary Errors page.
After correcting the errors, use the Product Load page to load the product data into production tables.

Note: The errors must be corrected before they can be loaded into the production tables.

See the product documentation for PeopleTools: Integration Broker Service Operations Monitor

Use the Summary Errors page (OM_EIP_PRODUCTS) to navigate to the individual error pages.

Navigation:

Products > Identify Product Details > Product Load Error Summary > Product Summary Errors

Field or Control	Description
Product Error Detail	Click to move to the error page for each error.
Data Maintenance	Click to move to the Data Definition Maintenance page to view the status of the transaction. When errors are corrected, the status changes from Error to Reprocess and they no longer appear on the Product Summary Errors page.

Use the Product Load page (RUN_OM_LOAD_PROD) to load rows from staging tables to production tables after correcting the errors.

Navigation:

Products > Process > Request Processes > Validate Product Load

This process validates data in the product staging table and then:

Supplies generic default information.
Loads validate product records into production tables.

Note: When you are using both PeopleSoft CRM and SCM, you do not have to send all product group types over during a product load. For CRM users, you can selectively prevent product group sync/fullsync messages for specific product groups such as claimbacks, reservations/backorder, and sourcing product groups. Additional steps would need to be established to prevent this.

Field or Control	Description
Transaction Type	Select the PRODUCTMST (product master) option.
Run	Click to run the OM Load Product (product load from stage) process (OM_LOAD_PROD) to load the row from a staging table to a production table to publish product information.

Working with Product Load EIPs

Pages Used to Correct Product Load EIPs

Understanding Product Load EIPs

Summary Errors Page

Product Load Page