Managing Enterprise Integration for PeopleSoft Enterprise CRM

This chapter provides overviews of enterprise integration technology and data integrations and discusses how to:

• Set up defaults for integrating customer and contact information.

• Market-enable Company, Consumer, Site, and Contact EIPs.

• Establish master ID databases.

• Map message data to PeopleSoft Enterprise CRM records and fields.

Understanding Enterprise Integration Technology

This section discusses:

• Enterprise integration points (EIPs) in PeopleSoft Enterprise CRM

• PeopleSoft Enterprise CRM Foundation EIPs

• Application Messages

• Data Mapping for Application Messages

EIPs in PeopleSoft Enterprise CRM

PeopleSoft Enterprise CRM provides many ways of integrating with other PeopleSoft applications as well as third-party systems. PeopleSoft Enterprise CRM applications collaborate to manage and share data across your enterprise—from managing customers and workers to tracking inventory.

PeopleSoft Enterprise CRM uses EIPs to integrate with:

• PeopleSoft applications outside of CRM.

• Third-party applications.

This diagram illustrates how PeopleSoft Enterprise CRM works with other PeopleSoft applications to manage and share data across your enterprise:

Integration between PeopleSoft databases

PeopleSoft Enterprise CRM integrates with:

• PeopleSoft HCM, which publishes employee and workforce data to the CRM database.

• PeopleSoft Financial Management Solutions and PeopleSoft Supply Chain Management (PeopleSoft SCM) for customer, contact, and product information.

  This is a two-way integration.

• PeopleSoft Enterprise Performance Management (PeopleSoft EPM), which publishes the data mining results from Customer Behavior Modeling for use in PeopleSoft Enterprise CRM.

By taking advantage of the integration technology that PeopleSoft software provides and the existing integrations with PeopleSoft HCM, PeopleSoft Financial Management Solutions, and PeopleSoft SCM, you can integrate with other third-party systems. PeopleSoft Enterprise CRM achieves integration using Application Messaging, Business Interlinks, and the PeopleTools Integration Broker technology.

PeopleSoft Enterprise CRM offers many ways of integrating with third-party applications. For example, if you send or publish a message to a third-party system, the system structures the data into a message and automatically delivers it to the destination location. You can also accept or subscribe to messages from third-party systems. The system validates incoming data, checking for errors before updating the system of record.

You can also send a synchronous request or reply transaction to a third-party system for processing and receive a real-time response.

Note. There is no CRM LOCATION_SYNC_EFF, LOCATION_FULLSYNC_EFF, DEPT_SYNC_EFF and DEPT_FULLSYNC_EFF message in CRM. The LOCATION_SYNC, LOCATION_FULLSYNC, DEPT_SYNC, and DEPT_FULLSYNC messages contain both the SYNC and EFF message structures.

See Also

Enterprise PeopleTools 8.50 PeopleBook: Integration Broker

Enterprise PeopleTools 8.50 PeopleBook: Integration Broker Testing Utilities & Tools

PeopleSoft Enterprise CRM Foundation EIPs

This table lists the EIPs that are provided with PeopleSoft software for foundation PeopleSoft Enterprise CRM:

EIPs that support particular business processes and applications are documented in other PeopleSoft Enterprise CRM PeopleBooks. The online EIP Catalog database lists, with technical details, the EIPs that PeopleSoft Enterprise CRM uses.

See Also

Integrating with Fulfillment and Billing Systems

Integrating with PeopleSoft Applications

Application Messages

EIPs that publish data to another database are available as both FULLSYNC and SYNC messages. FULLSYNC messages are designed for use at implementation time for setup information. Once a table has been set up, the SYNC messages allow for updates to that data.

Important! Some FULLSYNC messages are designed to fully replace the data through the use of the header message. To avoid losing existing data, turn off the header—the message refreshes the data by updating the existing data and adding any missing data.

Application Message Setup

As delivered, PeopleSoft EIP application messages are inactive.

To set up a delivered application message:

1. Activate the application message.

2. For inbound messages, activate the message subscription PeopleCode.

3. Set the associated message channel to Run mode.

4. Configure an existing message node or define a new message node.

5. Define asynchronous or synchronous transactions on the message node.

6. Define relationships to reconcile transaction parameters for routing, transmission type, message structure, or message content, if necessary.

See Enterprise PeopleTools 8.50 PeopleBook: Integration Broker

Data Mapping for Application Messages

PeopleSoft Enterprise CRM has the capability of subscribing to other PeopleSoft-application or third-party-application messages. Before PeopleSoft Enterprise CRM can subscribe to a PeopleSoft EPM message or any third-party message, data mapping must occur between the source format and the destination format. To accommodate this data mapping, PeopleSoft Enterprise CRM created a Data Mapping component. Using this component, you can perform data mapping for any single-level hierarchical message.

The integration between PeopleSoft EPM and CRM is currently the one place that uses this data mapping component. Before PeopleSoft Enterprise CRM can receive key performance indicator (KPI) information through the KP_KPI_ASMT_FACTS application message from EPM, the application message data must be mapped to data fields that the CRM system recognizes. To assist with this integration, PeopleSoft provides a predefined data mapping structure sample.

Alternatively, data is inserted into RB_CLAF_EPM_KPI table via the KP_KPI_EPM terms subscription. This subscription creates terms for the Active Analytics Framework.

This table shows the predefined data mapping structure sample provided with PeopleSoft software to assist with integration between PeopleSoft Enterprise CRM and EPM:

See Also

Defining Company Information

Defining Person Information

Mapping Message Data to PeopleSoft Enterprise CRM Records and Fields

Data Integrations

This section discusses:

• Integration with PeopleSoft HRMS or third-party HRMS.

• Customer and contact data integration.

• Worker data integration.

• Product data integration.

• Bill and payment data integration.

• Other integration considerations.

Integration with PeopleSoft HRMS or Third-Party HR Data

You use four EIP groups to integrate PeopleSoft Enterprise CRM with a PeopleSoft HRMS system or another third-party HR system: Person Basic, Workforce, Person of Interest and Person Competencies. Each group requires that you run additional supporting EIPs, and must be processed in a particular sequence.

These EIPs, with the exception of the POI, are available as both FULLSYNC and SYNC messages. You should perform FULLSYNC messages at implementation time to set up your PeopleSoft Enterprise CRM database correctly.

To set up your database with FULLSYNC messages (recommended sequence):

1. Before you run the main EIPs, run these common EIPs:

   1. Country

   2. State

   3. Currency

   4. SetID Initialization

   5. Table Set Control Initialization

   6. Location

   7. Business Unit

2. Run the Person Basic EIP.

3. Run the Workforce EIP group.

   1. Department

   2. Job Code

   3. Workforce

4. Run the Person Competencies EIP group.

   1. CM_TYPE

   2. Rating Model

   3. Competency

   4. Person Competency

5. Inactivate the FULLSYNC messages and activate the corresponding SYNC messages.

SYNC messages always originate in PeopleSoft HRMS or a third-party system and publish to PeopleSoft Enterprise CRM. Thus, any field in PeopleSoft Enterprise CRM that an EIP populates must be maintained from the originating source database, whether it is PeopleSoft HRMS or a third-party system.

Note. If you create workers within PeopleSoft Enterprise CRM, you must maintain these workers in CRM until you create them in an HRMS or third-party database.

Personal Data

PeopleSoft Enterprise CRM subscribes only to this subset of personal data:

• Worker's and POI's physical address (addresses with the address type Mailing).

• Worker's and POI's email address (email addresses that do not have an email type of Home).

• Worker's and POI's phone number (phone numbers that do not have a phone type of Home).

Job Code Data

PeopleSoft Enterprise CRM subscribes to all job information for worker and for a POI. All fields (except for Physical Location) in the Worker component are updated from PeopleSoft HRMS.

Customer and Contact Data Integration

In PeopleSoft Enterprise CRM, a customer can be either a company, a partner company, a consumer, or a site that is associated with a company or consumer. A contact is any person who performs transactions on a customer's behalf.

Company, Consumer, Site, and Contact EIPs

Use the CUSTOMER_COMPANY, CUSTOMER_CONSUMER, and CUSTOMER_SITE EIPs to synchronize customer information with other systems. When you implement these EIPs, application messages are published whenever a company, partner company, consumer, or site record in the PeopleSoft Enterprise CRM system is added or modified. PeopleSoft Enterprise CRM can also subscribe to these EIP application messages that are published when these records are modified in another system.

Note. CRM cannot publish a company with grandparent companies to SCM, because SCM only supports a two-level customer hierarchy, whereas CRM can support multi-level customer hierarchies. If you have implemented the CUSTOMER_COMPANY EIP and a company with grandparent companies is added in the Company component, this online message is issued:

SCM doesn't allow multi-level customer hierarchy, No message will be published

The PARTNER_PROFILE EIP is triggered when you update data for a company that has the Partner role. It publishes an application message whenever a partner record is added or modified. The data in this EIP contains only information that is specific to the Partner role. The CUSTOMER_COMPANY EIP is also published to synchronize the basic company information.

The CUSTOMER_CONTACT EIP enables you to synchronize customer contact information with another system. When you implement the CUSTOMER_CONTACT EIP, application messages are published when a contact record in the PeopleSoft Enterprise CRM system is added or modified. CRM can also subscribe to CUSTOMER_CONTACT EIP application messages that are published when these records are modified in another system.

Important! You must market-enable the Company, Consumer, Site, Partner Profile, and Contact EIPs before PeopleSoft Enterprise CRM can send customer (company, partner profile, consumer, and site) and contact data to other databases. Market-enabling enables you to specify what data the PeopleSoft Enterprise CRM system sends to other systems for a specific market. For example, you might opt not to publish certain customer and contact data to an external system for the FSI market. At the minimum, you must specify a global market to interface all non-market specific data.

See Market-Enabling Company, Consumer, Site, and Contact EIPs.

Partner Profile EIP

This EIP is triggered when you update data for a company that has the Partner role.

See PeopleSoft Enterprise Partner Relationship Management 9.1 PeopleBook.

Site Considerations

Only CRM sites that are flagged with the bill-to or sold- to purchasing options are integrated as customers with PeopleSoft SCM. If a site is flagged as Ship To only then the site is integrated with PeopleSoft SCM as an address to the company with which the site is associated.

When you add the bill-to or sold-to flag to a ship-to site, the system publishes the site message to create a new customer in PeopleSoft SCM. However, if a customer already exists in PeopleSoft SCM, removing the bill-to and sold-to options from the site does not remove the customer information for that site in PeopleSoft SCM.

Specifying Customer ID and Contact ID Default Values

You must specify the system that owns the customer ID and contact ID and verify the automatic numbering for ID generation for each setID.

See Managing Enterprise Integration for PeopleSoft Enterprise CRM.

See Setting Up Automatic Numbering.

Customer and Contact Integration with Other PeopleSoft Applications

Unlike PeopleSoft Enterprise CRM, PeopleSoft Financial Management Solutions and PeopleSoft SCM do not distinguish between company, consumer, and site records. CUSTOMER_COMPANY, CUSTOMER_CONSUMER, and CUSTOMER_SITE EIP application messages to which these systems subscribe are all mapped to customer records with unique customer IDs in the PeopleSoft Financial Management Solutions and PeopleSoft SCM systems.

When customer records are added or modified in PeopleSoft Financial Management Solutions and PeopleSoft SCM, the system publishes application messages using the Customer EIP. These messages are mapped to companies in the PeopleSoft Enterprise CRM system.

When a record that is created in PeopleSoft Enterprise CRM is modified in PeopleSoft Financial Management Solutions and PeopleSoft SCM, the system uses the record key information (customer ID and setID) that is included in the application message that's reporting the change to derive the record's original business object ID in PeopleSoft Enterprise CRM. This enables CRM to apply the changes that are reported in the application message to the corresponding company, consumer, or site record.

To ensure uniqueness of customer ID and contact ID between multiple PeopleSoft Enterprise CRM databases, you must specify the system that owns the customer ID and contact ID and verify the automatic numbering for ID generation for each setID.

See Establishing Master ID Databases.

Note. The CUSTOMER_COMPANY, CUSTOMER_CONSUMER, CUSTOMER_CONTACT, and CUSTOMER_SITE EIPs enable you to maintain customer information in multiple databases. However, to simplify integration of customer information, choose one database as the system of record for customer maintenance, and use PeopleTools portal technology to support customer information inquiries from the other systems. If you maintain customer and contact information in multiple databases, you must consider additional design, planning, and integration steps.

Customer and Contact EIP Application Messages Processing Order

In PeopleSoft Enterprise CRM, because contacts can be associated with a company, consumer, or site, the company, consumer, or site record should be created before the contact record. When you implement the CUSTOMER_COMPANY, CUSTOMER_CONSUMER, CUSTOMER_CONTACT, and CUSTOMER_SITE EIPs, make sure that the application messages from the CUSTOMER_COMPANY, CUSTOMER_CONSUMER, and CUSTOMER_SITE EIPs are processed before application messages from the CUSTOMER_CONTACT EIP when performing a FULLSYNC process.

Maintaining Customer and Contact Information in Different Databases

In PeopleSoft, customers exist in PeopleSoft Enterprise CRM, PeopleSoft SCM, and PeopleSoft Financial Management Solutions. There are a number of ways to design the system to integrate between PeopleSoft Enterprise CRM, PeopleSoft SCM, and PeopleSoft Financial Management Solutions. The simplest way to integrate customer master information is to manage all customer maintenance out of one database and support inquiry only on the other databases. Then you can use PeopleTools portal technology to access either system.

You might have a compelling business reason to maintain customer and contact information in different databases. For example, you may elect to have your front office users create customers in the PeopleSoft Enterprise CRM database but want to use the Receivables payment processing options that are available only in Financial Management Solutions.

If you choose to maintain customer (company, consumer, and site) and contact information in different databases, you must:

• Define which database owns the customer and contact ID number assignment on the Master ID DB Setup page.

  By specifying an owner, the system will be consistent in assigning a unique customer or contact ID for a particular customer or contact across different databases.

• Set up defaulting for the CRM Name Type field on the Name Type Defaults page.

  You cannot add new contacts or customers to the PeopleSoft Enterprise CRM database through the CUSTOMER_COMPANY, CUSTOMER_CONSUMER, CUSTOMER_CONTACT, and CUSTOMER_SITE EIPs unless you complete this step.

• Set up at least one PeopleSoft Enterprise CRM market control code for interfacing CRM customer and contact data to other databases.

• Evaluate whether you plan to define customers as bill-to customers in PeopleSoft Enterprise CRM.

  In PeopleSoft SCM and PeopleSoft Financial Management Solutions, customers that you define as bill-to customers must also have a defined collector and credit analyst. To ensure that PeopleSoft Enterprise CRM passes these required fields to PeopleSoft SCM and PeopleSoft Financial Management Solutions, select the Collector/Credit Analyst Req (collector/credit analyst required) check box on the Installation Setup table. This ensures that PeopleSoft Enterprise CRM satisfies the required field edit that is needed to populate PeopleSoft Financial Management Solutions and PeopleSoft SCM. Set up defaulting of these values on the Interface Defaults page under Define Integration Rules.

• Manually keep the Collector and Credit Analyst table in PeopleSoft Enterprise CRM in sync with the PeopleSoft Financial Management Solutions and PeopleSoft SCM Collector and Credit Analyst table.

• Establish a default support team code in PeopleSoft Enterprise CRM for each setID to be used in when creating a customer.

  In PeopleSoft SCM and PeopleSoft Financial Management Solutions, a default support team code is required for each customer. To satisfy the required field edit, PeopleSoft Enterprise CRM enables you to set up a default value on the Interface Defaults page under Define Integration Rules. In addition, ensure that the value set up on the Default page also exists on the PeopleSoft SCM and PeopleSoft Financial Management Solutions system.

PeopleSoft SCM and PeopleSoft Financial Management Solutions Customer-Related Pages That Are Unavailable in PeopleSoft Enterprise CRM

These pages in the PeopleSoft SCM or PeopleSoft Financial Management Solutions Customer component are not available in CRM:

• Vendor Info.

• Credit Profile - General.

• Credit Profile - Credit Check.

• Region Code Info.

• Subcustomer Info.

• Customer Group Info.

• Customer VAT Info (customer value-added tax information).

• Customer Notes Info.

• Attachments.

• Messages.

• User-Defined 1.

• User-Defined 2.

• Payment Options.

• Write-Off Info.

• Hierarchy.

• Product Catalog.

• Product Aliases.

• Additional Ship To Options.

• Ship Exception Dates.

• Carrier Acct Number (carrier account number).

Note. If the PeopleSoft Enterprise CRM installation is integrated with either PeopleSoft SCM or PeopleSoft Financial Management Solutions, you can access these pages through those applications.

The Products component in PeopleSoft SCM and PeopleSoft Financial Management Solutions uses these customer components, which are not available in CRM:

• Dun & Bradstreet.

• MICR Information.

• Corporate Customer Tree.

• Vendor Information.

• Corporate Tree Messages.

• Customer EFT Name (customer electronic funds transfer name).

• Quick Customer Create.

Note. You can access these pages through PeopleSoft SCM or PeopleSoft Financial Management Solutions if the PeopleSoft Enterprise CRM installation is integrated with those systems.

See Also

Defining Consumer Information

Defining Purchasing Options for Companies, Consumers, and Sites

PeopleSoft Enterprise CRM 9.1 PeopleBook: Enterprise Components

Worker Data Integration

Use the Worker EIP to synchronize worker information with another system. In PeopleSoft Enterprise CRM, workers are people who work for you. When you implement the Worker EIP, application messages are published when a worker record in the PeopleSoft Enterprise CRM system is added or modified. PeopleSoft Enterprise CRM can also subscribe to Worker EIP application messages that are published when these records are modified in another system. The Worker EIP enables PeopleSoft Enterprise CRM to accept and create future dated workers that were created in another system and to which CRM subscribed.

Product Data Integration

Integrate product data using the PeopleTools 8.5 Integration Broker. This technology enables both synchronous and asynchronous messages to be transmitted using one technology. The PRODUCT_SYNC and PRODUCT_FULLSYNC messages are used to both publish and subscribe to data between PeopleSoft Enterprise CRM and PeopleSoft SCM or a third-party system.

Integrating from PeopleSoft SCM to PeopleSoft Enterprise CRM

PeopleSoft Enterprise CRM subscribes asynchronously to the PRODUCT_SYNC message that is coming from PeopleSoft SCM. This data is processed directly into the PeopleSoft Enterprise CRM product tables using Component Interfaces (CIs).

A product package header record is added for any kit components that are received from PeopleSoft SCM.

Integrating from PeopleSoft Enterprise CRM to PeopleSoft SCM

PeopleSoft Enterprise CRM publishes the PRODUCT_SYNC message whenever product data is added, changed, or deleted through the Product Definition (PROD_DEFN), Product Package (PRODKIT_SUMMARY), Pricing (PROD_PRICE), Package Pricing (PRODKIT_COMPS_PRICE), Notes (PROD_NOTE), Relationships (PROD_RELATIONS_CMP), and Product Attributes by UOM (product attributes by unit of measure; PROD_UOM) pages.

The Integration Broker processes the message and applies a transformation to remove the PRODKIT_HEADER.

Any package components that are themselves packages are also stripped from the message.

Because PeopleSoft SCM does not allow packages within packages, package components that are themselves packages are also stripped from the message.

This table shows how an order represents packages to PeopleSoft SCM:

Integrating from PeopleSoft Enterprise CRM to a third-party SCM database

PeopleSoft Enterprise CRM publishes the PRODUCT_SYNC message whenever product data is added, changed, or deleted through the Product Definition, Product Package, Pricing, Package Pricing, Notes, Relationships, and Product Attributes by UOM components. Integration Broker passes the message to the subscribing system.

Bill and Payment Data Integration

PeopleSoft Enterprise CRM integrates with Billing and Receivables to obtain billing information—invoices—and payments that are associated with a company, consumer, or contact. If a person is a contact of a company and that role is selected in the Role field in 360-Degree View, then the 360-Degree View EIPs retrieve invoices and payments for the company and not for the contact.

The PeopleSoft Enterprise CRM 360-Degree View can display invoices and payments under those nodes in the 360-Degree View tree. When you define these types of nodes on the Define Node page in PeopleSoft Enterprise CRM, you specify all of the necessary EIP details that are associated with that node.

To request invoices from PeopleSoft Billing, and for Billing to respond to the request, use the GET BILLS FOR 360 DEGREE VIEW EIP. This EIP consists of two application messages:

• BI_EIP360_REQ (request message)

• BI_EIP360_RSP (response message)

To request payments from PeopleSoft Receivables and for Receivables to respond to the request, use the GET ACCOUNT RECEIVABLES FOR 360 DEGREE VIEW EIP. This EIP consists of two application messages:

• AR_CRM_REQUEST (request message)

• AR_CRM_RESPONSE (response message)

All of the application messages that are used for integrating with 360-Degree View are synchronous.

PeopleSoft Enterprise CRM passes the request parameters for the request application message using an application class method. This table lists the application classes that PeopleSoft Enterprise CRM uses to pass the request parameters to Billing and Receivables:

See Also

PeopleSoft Enterprise CRM 9.1 Industry Application Fundamentals PeopleBook

Performance Considerations

When you integrate large amounts of data with other systems, system performance is slowed. The following tips might help.

Data Maintenance in Multiple Systems

If you have both PeopleSoft Enterprise CRM and PeopleSoft SCM databases, PeopleSoft recommends that you:

• Synchronize tables (such as Customer and Contacts) by running the FULLSYNC EIPs to perform a full batch publish to the subscribing system.

  Note. In general, FULLSYNC messages first delete all existing data in the target record and then load a copy of the source record. For Company, Consumer, Contact, and Site FULLSYNC messages that come into PeopleSoft Enterprise CRM, no delete occurs; the data is merged into the existing data instead. This ensures data integrity within the PeopleSoft Enterprise CRM system.

• Update databases in the subscribing system by running SYNC EIPs to perform incremental updates.

  SYNC messages modify, delete, or add only the data that a user affected while performing an individual transaction.

Cascading Addresses

You can set a system option that automatically updates addresses on related business objects whenever you update an address on a parent business object. When you enable this option, each update that occurs also triggers an EIP to publish the address change to PeopleSoft SCM.

See Maintaining Contact Information for Business Objects.

See Also

Establishing Master ID Databases

Setting Up Defaults for Integrating Customer and Contact Information

Market-Enabling Company, Consumer, Site, and Contact EIPs

Setting Up Defaults for Integrating Customer and Contact Information

To set up defaults for integrating customer and contact information, use the Collector (COLLECTOR_TABLE), Credit Analyst (CR_ANALYST_TABLE), and General Options (RB_INSTALLATION) components.

This section discusses how to define default values for integrating customer and contact information.

Pages Used to Set Up Default Values for Integrating Customer and Contact Information

Creating and Maintaining Collector Codes

Access the Collector page (Set Up CRM, Common Definitions, Customer, Collector).

Important! To ensure successful integration with PeopleSoft Financial Management Solutions and PeopleSoft SCM, you must synchronize collector codes manually between PeopleSoft Enterprise CRM and PeopleSoft Financial Management Solutions and PeopleSoft SCM. Customer (company, consumer, and site) EIP application messages that include codes that are not available in the subscribing system will fail.

Creating and Maintaining Credit Analyst Codes

Access the Credit Analyst page (Set Up CRM, Common Definitions, Customer, Credit Analyst).

Important! To ensure successful integration with PeopleSoft Financial Management Solutions and PeopleSoft SCM, you must synchronize credit analyst codes manually between PeopleSoft Enterprise CRM and PeopleSoft Financial Management Solutions and PeopleSoft SCM. Customer (company, consumer, and site) EIP application messages that include codes that are not available in the subscribing system will fail.

Creating and Maintaining Support Team Codes

Access the Support Team Code page (Set Up CRM, Common Definitions, Codes and Auto Numbering, Support Team Codes, Support Team Code).

Important! To ensure successful integration with PeopleSoft Financial Management Solutions and PeopleSoft SCM, you must synchronize support team codes manually between PeopleSoft Enterprise CRM and PeopleSoft Financial Management Solutions and PeopleSoft SCM. Customer (company, consumer, and site) EIP application messages that include codes that are not available in the subscribing system will fail.

Specifying Interface Defaults

Access the Interface Defaults page (Set Up CRM, Common Definitions, Integration Rules, Integration Defaults, Interface Defaults).

When you create a customer or site record using the Company, Consumer, and Site components in PeopleSoft Enterprise CRM, the system automatically populates the record with the values that you enter on the Interface Defaults page. Users can select alternate values for these fields using the Bill Options view of the Customer Roles page, which is available in each of the components.

Specifying Name Type Defaults

Access the Name Type Options page (Set Up CRM, Common Definitions, Integration Rules, Integration Defaults, Name Type Options).

PeopleSoft Enterprise CRM requires name type codes to create all business object records; however, PeopleSoft Financial Management Solutions and PeopleSoft SCM do not require name codes. To ensure that records that are received from PeopleSoft Financial Management Solutions and PeopleSoft SCM are populated with name types that are valid in CRM, you specify default name type values here.

See Defining Business Object and Name Types.

Specifying Default Exchange Rates

Access the General Options page (Set Up CRM, Install, Installation Options, General Options).

Important! You must manually synchronize exchange rate codes between PeopleSoft Enterprise CRM and PeopleSoft Financial Management Solutions and PeopleSoft SCM. Customer (company, consumer, and site) EIP Application messages that include codes that are not available in the subscribing system will fail.

Ensuring Required Code Availability

Access the General Options page (Set Up CRM, Install, Installation Options, General Options).

Select the Collector/Credit Analyst Req check box. This prevents Customer (company, consumer, and site) EIP application message failures in PeopleSoft Financial Management Solutions and PeopleSoft SCM that are due to missing collector or credit analyst field values.

Market-Enabling Company, Consumer, Site, and Contact EIPs

To market-enable company, consumer, site, and contact EIPs, use the Market Control Codes (RB_MKT_CTL_DFN) and Market Installation Options (RB_MKT_CTL_TBL) components.

This section discusses how to specify the markets that PeopleSoft Enterprise CRM integrates with.

Pages Used to Market-Enable Company, Consumer, Site, and Contact EIPs

Defining Market Control Codes

Access the Market Control Codes page (Set Up CRM, Common Definitions, Codes and Auto Numbering, Market Control Codes).

Enter a market control code name and a description. Use the Comments field to add any more information. These control codes are used on the Market Installation Options page.

Specifying Market Installation Options

Access the Market Installation Options page (Set Up CRM, Install, Market Installation Options).

Market Control Code	Select the market control code. Note. CDMINTFC is the market control code for CDM interface records.
Option Activated	Select to activate the code.

Note. Use this page for market-enabling credit card information as well.

Building Business Object Relationship Model Interface Records

Access the Build CDM Interface Records page (Set Up CRM, Common Definitions, Integration Rules, Integration Utilities, Request Processes, Build CDM Interface Records).

Click Run to run the Build CDM Interface Records process, which populates the interface records.

Establishing Master ID Databases

This section lists prerequisites and discusses how to set up master ID databases.

Prerequisites

You must first set up number type codes that relate object IDs to databases.

See Setting Up Automatic Numbering Rules.

Pages Used for Establishing Master ID Databases

Designating the Systems That Have Master Object IDs

Access the Master ID DB Setup page (Set Up CRM, Common Definitions, Integration Rules, Remote Data Access, Master ID Owner, Master ID DB Setup).

Important! Use the Master ID DB Setup page to indicate the location of the master database that is responsible for issuing identifiers for customers, contacts, and so on. You must do this on all databases in the community except the master. Failure to do so may result in duplicate customer and contact identifiers.

Testing Calls

Access the XML Test Utility page (Set Up CRM, Common Definitions, Integration Rules, Remote Data Access, XML Test Utilities, XML Test Utility).

Transaction

Enter the identifier for the object whose ID generation you want to test. Enter 1 for customers, 2 for contacts, 3 for sales orders, 4 for quotes, and 5 for products. When you press Tab to exit the field, the system enters default values in the first three unlabeled text boxes. The first unlabeled text box displays the setID or business unit for which the autonumber is to be generated; modify this if you like. Do not modify the other fields. The second text box displays the next number to be generated. This is always NEXT by default; do not change the value. The third field displays the zero padding indicator: Y (yes) to suppress leading zeros or N (no) to include leading zeros. You can modify this if you like. The last two unlabeled fields are not used when testing autonumber generation.

Test

Click the Test button to fetch the next ID number from the external system. The result appears in the Text field. If the object's autonumbers come from the PeopleSoft Enterprise CRM system (and not an external ID master), the Text field displays the word Local. Note. This test increments the number in the external system's database.

Mapping Message Data to PeopleSoft Enterprise CRM Records and Fields

This section discusses how to map message data to PeopleSoft Enterprise CRM records and fields.

Page Used to Map Message Data to PeopleSoft Enterprise CRM Records and Fields

Mapping Message Data to PeopleSoft Enterprise CRM Records and Fields

Access the Message Data Mapping page (Set Up CRM, Common Definitions, Process Automation, Message Mapping, Message Data Mapping).

Note. You can define message mapping for message with single-level hierarchy only.

Fields to Update

Record Identification

Message Row Identification

Message Mapping Example

Here is an example of a message:

<?xml version="1.0"?>
<KP_KPI_ASMT_FACTS>
  <Fieldpiece>
    <KP_KPI_PUBL_TBL class="R">
      <BUSINESS_UNIT type="CHAR"/>
      <PF_SCENARIO_ID type="CHAR"/>
      <FISCAL_YEAR type="NUMBER"/>
      <ACCOUNTING_PERIOD type="NUMBER"/>
      <KPI_ID type="CHAR"/>
      <OBJ_ID type="CHAR"/>
      <TRGT_RULE_TYPE type="CHAR"/>
      <PF_OBJECT_TYPE type="CHAR"/>
      <RESOLVED_VALUE type="NUMBER"/>
      <ASSESS_ID type="CHAR"/>
      <ASSESS_IMAGE_ID type="CHAR"/>
      <ASSESS_DESCR type="CHAR"/>
      <PERIOD_END_DT type="DATE"/>
      <PCT_OF_TARGET type="NUMBER"/>
      <STRETCH_GOAL type="NUMBER"/>
      <CURRENT_TARGET type="NUMBER"/>
      <CURRENCY_CD type="CHAR"/>
      <RESOLVED_IND type="CHAR"/>
      <KPI_CALCDTTM type="DATETIME"/>
      <KP_TREND_IND type="CHAR"/>
      <QTD_VALUE type="NUMBER"/>
      <YTD_VALUE type="NUMBER"/>
      <YEAR_OVER_YEAR_PCT type="NUMBER"/>
      <MONITOR_ONLY type="CHAR"/>
      <DESCR type="CHAR"/>
      <KP_USER_FLD1 type="CHAR"/>
      <KP_USER_FLD2 type="CHAR"/>
      <PS_OWNER type="CHAR"/>
    </KP_KPI_PUBL_TBL>
    <PSCAMA class="R">
      <LANGUAGE_CD type="CHAR"/>
      <AUDIT_ACTN type="CHAR"/>
      <BASE_LANGUAGE_CD type="CHAR"/>
      <MSG_SEQ_FLG type="CHAR"/>
      <PROCESS_INSTANCE type="NUMBER"/>
      <PUBLISH_RULE_ID type="CHAR"/>
      <MSGNODENAME type="CHAR"/>
    </PSCAMA>
  </FieldTypes>
  <MsgData>
    <Transaction>
      <KP_KPI_PUBL_TBL class="R">
        <BUSINESS_UNIT>FSI01</BUSINESS_UNIT>
        <PF_SCENARIO_ID>1</PF_SCENARIO_ID>
        <FISCAL_YEAR>1998</FISCAL_YEAR>
        <ACCOUNTING_PERIOD>1</ACCOUNTING_PERIOD>
        <KPI_ID>1</KPI_ID>
        <OBJ_ID>200022</OBJ_ID>
        <TRGT_RULE_TYPE/>
        <PF_OBJECT_TYPE>CUSTMASTER</PF_OBJECT_TYPE>
        <RESOLVED_VALUE>11</RESOLVED_VALUE>
        <ASSESS_ID>11</ASSESS_ID>
        <ASSESS_IMAGE_ID>PS_COMPANY_ICN</ASSESS_IMAGE_ID>
        <ASSESS_DESCR>Green</ASSESS_DESCR>
        <PERIOD_END_DT/>
        <PCT_OF_TARGET>11</PCT_OF_TARGET>
        <STRETCH_GOAL>0</STRETCH_GOAL>
        <CURRENT_TARGET>0</CURRENT_TARGET>
        <CURRENCY_CD>USD</CURRENCY_CD> 
        <RESOLVED_IND/>
        <KPI_CALCDTTM/>
        <KP_TREND_IND/>
        <QTD_VALUE>4670</QTD_VALUE> 
        <YTD_VALUE>4670</YTD_VALUE> 
        <YEAR_OVER_YEAR_PCT>0</YEAR_OVER_YEAR_PCT> 
        <MONITOR_ONLY/>
        <DESCR/>
        <KP_USER_FLD1>KPI</KP_USER_FLD1> 
        <KP_USER_FLD2/>
        <PS_OWNER/>
      </KP_KPI_PUBL_TBL>
      <PSCAMA class="R">
        <LANGUAGE_CD>ENG</LANGUAGE_CD>
        <AUDIT_ACTN/>
        <BASE_LANGUAGE_CD>ENG</BASE_LANGUAGE_CD>
        <MSG_SEQ_FLG/>
        <PROCESS_INSTANCE>0</PROCESS_INSTANCE>
        <PUBLISH_RULE_ID/>
        <MSGNODENAME/>
      </PSCAMA>
    </Transaction>
  </MsgData>
</KP_KPI_ASMT_FACTS>

From this message and the mapping that is provided, you can determine the:

• Message name - KP_KPI_ASMT_FACTS

• Record to update

  This message updates the BC table.

• Fields to update

  The BC table fields ASSESS_DESCR, ASSESS_ID, ASSESS_IMAGE_ID, KPI_ID, and PCT_OF_TARGET are updated with the values of XML tags <ASSESS_DESCR>, <ASSESS_ID>, <ASSESS_IMAGE_ID>, <KPI_ID>, and <PCT_OF_TARGET> in the message.

• Record identification

  Subscription code updates the row in the BC table if the CUST_ID field value equals the value of the XML tag <OBJ_ID> in the message.

• Message row identification

  Message rows qualify if the value of the XML tag <PF_OBJECT_TYPE> is equal to CUSTOMERMASTER; otherwise, the message rows are ignored.