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.

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

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

Field or Control

Definition

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.

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

  1. Supplies generic default information.

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

Definition

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.