Integrating with Direct Connect Suppliers

This chapter provides an overview of direct connect supplier integration and discusses how to:

• Set up direct connect.

• Connect to suppliers using PunchOut.

• Connect to suppliers using RoundTrip.

• Troubleshoot error messages.

Understanding Direct Connect Supplier Integration

This section discusses:

• Direct connect.

• Shared data synchronization.

Direct Connect

Direct connect enables PeopleSoft eProcurement requisition users to interact directly with a supplier's website. This interaction enables the user to browse and search the supplier's online catalog to select items to add back into the eProcurement requisition using an approved standard process such as PunchOut (Ariba's standard) or RoundTrip and OCI (Commerce One's standard.)

You set up direct connect methods and supplier details, such as URLs (uniformed resource locator). You then run through a series of background processes. eProcurement:

• Passes and receives strings of data which are transformed from XML into PeopleSoft service operations.

• Makes it possible for users to access and browse supplier catalogs.

• Adds requisition lines using supplier shopping carts.

• Sources purchase orders (POs) to suppliers.

The product or service items that you select are brought into a eProcurement requisition, which is processed through the approval workflow. The requisition is eventually converted to a purchase order, which can be routed to the supplier's website. This integration enables you to access multiple vendor catalogs in real-time, without loading or maintaining catalogs within PeopleSoft applications, including eProcurement.

Direct connect supplier integration enables you to create configured orders for products or services such as:

• Computer systems with various types of processors, memory requirements, and peripherals.

• Printing jobs with varying text, colors, types and sizes of paper, numbers of copies, and output formats.

• Catered events with different locations, times, types of food, and levels of service.

PeopleSoft eProcurement supports:

• RoundTrip integration that uses OCI (Open Catalog Interface) to format the data returned from the shopping session.

• PunchOut integration that uses cXML.

• RoundTrip to marketplace.

• PunchOut to Exchange.Oracle.com

Note. Using either RoundTrip or PunchOut, you can access a supplier's existing, web-based catalog from within eProcurement. You can add goods and services to a shopping cart, which is sent back to eProcurement for order fulfillment. You can access supplier catalogs and streamline the purchasing processes.

Note. The Direct Connect Supplier feature requires some set up by the organization. The steps for entering an order with a direct connect supplier vary according to the supplier and the set up. Because direct connect order processing involves integration with another website, the eProcurement change request feature might not be available for purchase orders that are created in this manner.

Note. The terms marketplace and marketsite are interchangeable in this PeopleBook and refer to conducting business using the internet.

Viewing and Editing Requisition Line Items

In addition to connecting to a supplier website to add new requisition line items, Direct Connect also supports the connection to the supplier's site to view and edit item details for items that have been added to a requisition using Direct Connect. This is accomplished by using the Description link on a requisition line. The Description link is available from many pages, and can be used for either viewing the item details or editing item information, such as quantity.

In order to accomplish this, the supplier must be set up with the ability to view and edit items, which is specified on the Supplier Properties page. If the supplier supports items to be viewed and edited, then the application connects to the supplier site and lets the site know whether the user is editing the line or viewing line details. Therefore, in addition to the supplier setup, there is one rule that eProcurement follows in order to determine which behavior (view or edit) to specify to the supplier. If the item Description link is in the Create Requisition component, such as the Submit Requisition page, then the user is able to edit the information on the supplier site. All other item description links, such as the links in the Manage Requisition component, are view only.

Note. In the RoundTrip standard, view mode is the only mode supported. Additionally, in the cXML and PunchOut specification, view mode is known as inspect mode.

Using Direct Connect Items on Favorites List or Templates

Items entered on a requisition using the direct connect method can also be saved as favorites or as items on a template. These methods save the requester time when creating additional requisitions for the same item. If you do not want this functionality for your requesters, you can deselect the check box, Allow Saving Direct Connect Items in Favorites and Templates, on the eProcurement Installation Options page.

See Selecting Favorite Items and Item Groups to Include in Requisitions.

See Using Template Items to Create Requisitions.

Shared Data Synchronization

To prevent validation errors when requisition information is passed between eProcurement and the direct connect supplier's website, the common control data should use these codes:

Setting Up Direct Connect

To set up direct connect, use the Direct Connect Methods (PV_DC_TYPE), and the Supplier Value Cross-Reference (PV_MERCHANT_XREF) components.

This section discusses how to:

• Set up direct connect suppliers.

• Activate the direct connect service operation.

• Set up a node.

• Set up node connectors.

• Set up a routing.

• Set up routing parameters.

• Define favorites and templates feature.

• Set up a linked supplier.

• Set up supplier properties.

• Map field values.

Pages Used to Set Up Direct Connect

Defining the Direct Connect Methods page

Access the Direct Connect Methods page (eProcurement, Administer Procurement, Maintain Supplier Integration, Direct Connect Methods).

Direct Connect Method	Identifies the type of connection to the supplier's website. Delivered options include: EXCH_ORACLE: to access the Exchange.oracle.com website PUNCHOUT: to access a vendor's website using cXML ROUNDTRIP: to access a vendor's website using OCI (Open Catalog Interface). ROUNDTRIP_MP: to access marketplace using roundtrip.
Root Package ID	Identifies the PeopleSoft application package used for this direct connect method.
Application Class Path	Identifies the PeopleSoft application class within the above application package.
Properties	Lists property values that the system uses for this direct connect method.

Setting Up Direct Connect Suppliers

There are several tasks that need to be completed before a vendor is enabled for direct connect.

1. Exchange contact information with the supplier.

2. Execute contractual agreements that are required between the supplier and your organization.

3. Set up the direct connect supplier as a PeopleSoft vendor.

   See Maintaining Vendor Information.

4. Activate the direct connect service operation.

   See Activating The Direct Connect Service Operation.

5. Create a node for the supplier that you will connect to.

   See Setting Up a Node.

6. Set up a routing that represents the direct connect supplier.

   See Setting Up a Routing.

7. Define the favorites and templates feature on the eProcurement Installation Options page.

   See Define the Favorites and Templates Feature.

8. Set up the supplier as a link supplier .

Obtaining Authentication From the Supplier

These steps describe the setup for direct connect suppliers:

1. The supplier creates an account for your organization.

2. Your organization's administrator and the supplier establish an organization wide password (shared secret) that authenticates XML service operations from eProcurement.

3. The supplier provides your organization with a URL, which is used when setting up the Vendor Information page.

Creating a Vendor Profile

If the supplier is not already a vendor, you need to create it. These are the fields for use when creating a linked supplier definition:

• Vendor SetID.

• Vendor ID.

• Vendor Location.

Note. Before you save an eProcurement requisition, you must first establish the supplier as a PeopleSoft vendor. After you establish the supplier as a vendor, the vendor ID is saved on the requisition line. When the requisition is converted to a purchase order, the supplier is listed as the vendor on the purchase order.

See Maintaining Vendor Information.

Activating The Direct Connect Service Operation

The direct connect service operation (PV_DC_CONNECT_REQST) enables eProcurement to interact with direct connect suppliers, allowing eProcurement users to browse, search, and select items from supplier catalogs. Items from the supplier catalogs are then added to the eProcurement requisition. XML based documents are passed between eProcurement and the supplier to authenticate and sign the user onto the supplier's website, and to transfer the ordered items back to eProcurement.

PeopleSoft delivers 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.

To setup this service operation use the information in this table and refer to the setup instruction in the PeopleSoft Supply Chain Management Integrations 9.1 PeopleBook, "Implementing Integrations" chapter, Setting Up Service Operations section.

See Also

Setting Up Service Operations

Enterprise PeopleTools PeopleBook: Integration Broker

Setting Up a Node

Access the Node Definitions page (PeopleTools, Integration Broker, Integration Setup, Nodes).

This node represents the direct connect supplier.

Within the sample data delivered with the system, the PSFT_EXCH_ORACLE node is designed for access to the Exchange.oracle.com website.

Enter this field value, which is specific to Direct Connect Suppliers:

See Enterprise PeopleTools PeopleBook: Integration Broker, "Adding and Configuring Nodes"

Setting Up Node Connectors

Access the Connectors page (PeopleTools, Integration Broker, Integration Setup, Nodes, Connectors) and follow these steps:

Enter these field values that are specific to eProcurement:

See Enterprise PeopleTools PeopleBook: Integration Broker, "Adding and Configuring Nodes"

Setting Up a Routing

Access the Routing Definitions page (PeopleTools, Integration Broker, Integration Setup, Routings) and follow these steps:

There are two routings that are delivered with in the sample data for direct connect; the PV_DC_CONNECT_REQST routing can be altered to connect to a supplier's website, and the EXCH_ORACLE routing is designed to connect to the Exchange.oracle.com website.

Enter these field values that are specific to eProcurement:

See Enterprise PeopleTools PeopleBook: Integration Broker, "Managing Routing Definitions"

Setting Up Routing Parameters

Access the Parameters page (PeopleTools, Integration Broker, Integration Setup, Routings, Parameters).

Enter these field values that are specific to the routing definition PV_DC_CONNECT_REQST or EXCH_ORACLE for eProcurement Direct Connect:

Inbound Response Type

Outbound Request Type

See Enterprise PeopleTools PeopleBook: Integration Broker, "Managing Routing Definitions"

Define the Favorites and Templates Feature

Access the eProcurement Installation Options page (eProcurement, Administer Procurement, Maintain Overall System Options, eProcurement Installation Options).

Allow Saving Direct Connect Items in Favorites and Templates

Select this check box to allow direct connect items to be saved as favorites or as items on a template. This method saves the requester time when creating additional requisitions for the same item. Deselect this check box to prevent direct connect items from being added as favorites or template items. Each time the direct connect item is ordered, the requester must use the Web page of the Create Requisition component to access the supplier's online catalog, select the item, and then return to the eProcurement requisition.

Mapping Field Values

Access the Supplier Value Cross-Reference page (eProcurement, Administer Procurement, Maintain Supplier Integration, Supplier Value Cross-Reference).

When using direct connect, there are times that the data sent by the supplier needs to be translated to the desired data value for the PeopleSoft database. Use this page to map PeopleSoft eProcurement values to values with the same meaning but with different field names that the supplier uses. The most common use of this mapping is when a unit of measure, such as dozen is described by PeopleSoft as DZ and the supplier as DOZ.

There are several fields that might need to have some translation, or mapping, done. These fields may include:

• Unit of Measure

• Currency code

• Country Code

• Category ID

• Vendor ID

Translation always occurs after the item data is received from the supplier and transformed into the PV_DC_ITEMS (Direct Connect Items) message format. On each line of this message, every field in the PV_DC_REQ_LINE (Direct Connect Requisition Line) record is examined to determine if translation is required. The system then queries the data within the Supplier Values Cross-Reference page to determine if the field name and value passed need translation. If the system finds translation is needed, the field is updated with the corresponding PeopleSoft Value.

If no data is sent by the supplier for a particular field, you can assign default values. These values are configured on the Supplier Properties page.

The system uses values that you define on this page both for sending and receiving direct connect supplier data. You can add or change the cross references. Before you access this page, you first select the field to which the mapping applies.

Setting up a Category Cross-Reference

Category cross-references have their own process. The system goes through these steps to translate a category ID value that is sent by a supplier:

1. The system looks up the Category field in the Item Category table to determine if any category codes match the value sent by the supplier.

2. If the value sent by the supplier is not matched, then the supplier cross reference data is queried to determine if there is a matching category ID for this supplier.

3. If the supplier value cross reference does not contain the category either, the default value is taken from the linked supplier properties.

Setting Up a Vendor Cross-Reference

There are times when the supplier is a marketplace and they broker items from many vendors. The result of this scenario is a different vendor ID for each item is provided by the supplier. When this happens, the supplier sends only one field value to identify the vendor for the item using direct connect. There are three keys that identify the vendor within PeopleSoft:

• Vendor SetID

• Vendor ID

• Vendor Location

The Supplier Value Cross-Reference page is used to store the mappings from the supplier's value to the three PeopleSoft values.

The system goes through these steps to match vendor IDs for the supplier:

1. The supplier value cross-reference data is queried to determine if there is a matching vendor ID for this supplier.

   If there is a match, then, instead of using the PeopleSoft Value, all three vendor keys are placed into the PV_DC_ITEMS service operation.

2. If no match is found, then the three vendor keys that are specified as default values in the linked supplier properties are placed into the PV_DC_ITEMS service operation.

Connecting to Suppliers Using PunchOut

This section provides an overview of definitions and relationships and discusses how to:

• Define linked suppliers for PunchOut.

• Define linked suppliers properties for PunchOut.

Overview of Definitions and Relationships

This section discusses:

• Integration Broker definitions and relationships.

• Direct connect supplier transformations.

• Process flow for direct connect supplier integration using PunchOut.

Integration Broker definitions and relationships

Using broker definitions and relationships, you define the parameters for communicating with external suppliers using PunchOut. eProcurement requires at least one local gateway through which it can send and receive service operations.

You set up suppliers as a node in the integration profile. Nodes are locations from which the system sends or receives service operations. Nodes can also be an application, a database, or a server. Multiple nodes can share the same local gateway, which might be the only gateway you will need for all integrations. When a node is linked to a particular service operation, the relationship is called a routing.

A relationship reconciles incompatible parameters to transmit data successfully from the source to the target. Each integration requires at least one routing at each PeopleSoft Integration Broker node. One node uses a routing to send a message, and one or more nodes use routings to receive the message. The sending node might apply a routing with different parameters than those applied by the nodes that receive the message, with respect to routing, transmission type, message structure, or message content.

Direct Connect Supplier Transformations

Before defining direct connect supplier relationships, you need to create transformations. They convert an XML document from one format to another. Since the transformation is associated with a relationship, there can be a separate transformation for each supplier relationship. The system creates transformations using the Application Engine definition.

The system uses a step type of XSLT along with PeopleCode steps to perform the transformation. XSLT documents are tools that hold the structure of a document, as well as the rules of how to transform a XML document from one format to another.

There should be at least one transformation for each message. This transformation follows the standard defined for each XML document (for example, PunchOutOrder Message).

For some suppliers, you might need to change the standard transformation to support extrinsic values or other departures from the standard. In most cases, the modified logic should be saved as a separate name from the standard transformation, and the newly named transformation should be associated with the relationship.

When you create a transformation that follows a newly published version of the standard, you should save the new transformation with the standard's version name suffixed at the end (for example, PunchOutOrder Message). You can use only 10 characters. When determining whether to use PeopleCode or XSLT, make the decision on a transformation-by-transformation basis.

For punchout to a direct connect vendor, the following transformations are already created in PeopleSoft Application Designer:

• PV_DC_POSR (direct connect request) applies to the PV_DC_CONNECT_REQST service operation (authentication on start of direct connect session).

• PV_DC_POSRSP (direct connect response) applies to the PV_DC_CONNECT_RESPONSE service operation (response from supplier of authentication request).

• PV_DC_POOM (direct connect items) applies to the PV_DC_ITEMS service operation (shopping cart information sent by supplier upon return to eProcurement).

For punchout to exchange.oracle.com, the following transformations are already created in PeopleSoft Application Designer: and

• PV_POSR_EXCH (direct connect request) applies to the PV_DC_CONNECT_REQST service operation (authentication on start of direct connect session).

• PV_RSP_EXCH (direct connect response) applies to the PV_DC_CONNECT_RESPONSE service operation (response from supplier of authentication request).

• PV_POOM_EXCH (direct connect items) activated by the LoadItems method from the class SCM_PV_EXTERNAL_APP.DirectConnectExch. This is launched by the PV_DC_CATCHER.Activate page when the shopping cart information is sent to eProcurement requisition.

Note. The RoundTrip direct connect method does not use transformations.

Process Flow for Direct Connect Supplier Integration Using PunchOut

This illustration describes the process flow of the integration between PeopleSoft eProcurement and a direct connect supplier who uses PunchOut. Detailed steps below this illustration described the process flow:

The process flow of the integration between PeopleSoft eProcurement and PunchOut using cXML.

Warning! PeopleSoft and the direct connect suppliers might have site time-outs that could cause you to lose unsaved state information.

This list illustrates the steps in the previous diagram for using PunchOut to create an eProcurement requisition:

1. The system saves all levels of the current requisition to a global rowset. This preserves the state of the requisition so that changes made since the creation or the last save of the requisition are not lost. Then, based on the supplier, the system selects the proper connection method, and the code transfers to the component that handles the method.

2. Based on the direct connect method registered to the selected supplier, the system loads the appropriate application class and runs the code to connect to the supplier. This code uses requisition data and properties for the supplier to populate a PeopleSoft service operation. The Integration Broker then transforms the service operation into the XML PunchOutSetupRequest, which contains authentication information to facilitate a single sign-on into the supplier's system.

   If a supplier implements the sign-on differently than the standards for the selected method, you should code the supplier's sign-on logic in a separate direct connect method application class or Integration Broker transformation. This XML also contains a PeopleSoft eProcurement component URL to which the supplier posts the results of the shopping cart in step 8.

3. After building the XML, the system sends it to the supplier's URL as defined in the supplier's node definition. The supplier receives this request document and authenticates the user.

4. The system returns a response to eProcurement, if the user is successfully authenticated, that contains the supplier's URL for redirection.

5. eProcurement receives this XML-based response through Integration Broker. Integration Broker runs a transformation from the PunchOutSetupResponse to the service operation behind the scenes.

   Note. The system synchronously returns the response from the original authentication request. It is not a separate process. The supplier's URL is extracted from the service operation.

6. PeopleSoft eProcurement redirects the user to the URL sent in the response from the supplier.

7. The user browses the supplier's site and places an order. Based on sign-on information, the supplier can maintain customer specific pricing. Typically, this is done at a business level, not at a user level.

8. After the order is complete and the user checks out, the supplier's site packages the shopping cart into an XML string and places it in an HTML hidden form field. The user is redirected to the eProcurement component URL specified at sign-on in step 2.

9. The eProcurement component that has been redirected to extract the XML string from the hidden form field. The string is parsed into a PeopleSoft service operation using another Integration Broker transformation. Just as in the authentication process in step 2, the application class or transformation might need to be customized if the supplier does not follow the standard document structure or has unique extrinsic fields. The user is transferred to the originating requisition.

10. When the requisition component is reinitialized, the global rowset from step 1 containing the original requisition information is reloaded. The items from the external item service operation, containing the shopping cart data, are added as new rows to the requisition. These lines inherit the requisition's line default values just as any other item being added. The system displays the requisition Summary page to the user.

Note. Items that are selected on a supplier's website are not transmitted to eProcurement unless the connection is initiated through the supplier's link in eProcurement.

Using Extrinsic Values

The cXML extrinsic elements that are part of the PunchOutSetupRequest and the PunchOutOrderMessage can be used to send and receive data that does not fit in the other elements in the message.

For example, in the PunchOutSetupRequest, the extrinsic element can be used to send data that further identifies users, such as:

• User department / cost center

• Region

• Supervisor

• Default currency

The data is sent, essentially, as a name/value pair, as shown in this sample PunchOutSetup request below.

<Request>
                
 <PunchOutSetupRequest operation="edit">
                
 <BuyerCookie>1CX3L4843PPZO</BuyerCookie>
                
 <Extrinsic name="UserEmail">jsmith</Extrinsic>
                
 <Extrinsic name="UniqueName">John_Smith</Extrinsic>
                
 <Extrinsic name="CostCenter">610</Extrinsic>
                
 <BrowserFormPost>
                
  <URL>https://psftserver/psc/ps/EMPLOYEE/ERP/c/PV_MAIN_MENU.PV_DC_⇒
CATCHER.GBL?Page=PV_DC_CATCHER&MSGNODENAME=WORKCHAIRS</URL>
                
 </BrowserFormPost>
                
 <SupplierSetup>
                
 <URL>http://www.workchairs.com/punchout.asp</URL>
                
 </SupplierSetup>
                
 <ItemOut quantity="2">
                
 <ItemID>
                
 <SupplierPartID>220-6338</SupplierPartID>
                
<SupplierPartAuxiliaryID>E000028901</SupplierPartAuxiliaryID>
                
 </ItemID>
                
 </ItemOut>
                
 </PunchOutSetupRequest>
                
</Request>

The PunchOutOrderMessage includes the following cXML extrinsic elements:

• Message/PunchOutOrderMessage/Extrinsic/@name

• Message/PunchOutOrderMessage/Extrinsic

The use of extrinsic elements can be unique to each supplier; therefore, a separate object can be associated with each direct connect supplier to handle logic specific to the supplier. To use extrinsic elements for a direct connect supplier, complete the following setup steps:

1. Create a new application package and class to extend the class to the SetReqstExtrinsic() method. Be sure to add code into the SetReqsrExtrinsic() method that adds values to the extrinsic rowset in the rowset object that is passed into the method.

2. Register the application class as a new direct connect method within the PeopleSoft eProcurement application. Go to eProcurement Administration, Maintain Supplier Integration, Direct Connect Methods and:

   1. Add the new direct connect method.

   2. Associate the new method with the application package that was just created by entering the Root Package ID and Application Class Path that were created in step 1. The Description field is helpful to identify the uniqueness of this particular Direct Connect type, such as support for a new cXML version or addition of a supplier's Extrinsic values.

   3. Assign the list valid properties for the 'PUNCHOUT' method to this new method. Since this is simply an extension of 'PUNCHOUT', all the properties should match.

3. Associate the new direct connect method to the supplier. Go to eProcurement Administration, Maintain Supplier Integration, Linked Suppliers and select the vendor. Add the new method in the Direct Connect Method field.

Pages Used to Link to Suppliers Using PunchOut

Defining Linked Suppliers for PunchOut

Access the Linked Suppliers page (eProcurement, Administer Procurement, Maintain Supplier Integration, Linked Suppliers. Select the Marketplace Suppliers type on the Linked Suppliers page in Add mode).

Use this page to associate suppliers to nodes and then associate suppliers and nodes to their PunchOut direct connect method. Then use the Supplier Properties tab to store authentication and behavioral properties specific to the method for this supplier and node.

Enter these field values that are specific to Direct Connect Suppliers that use PUNCHOUT:

See Using the Linked Suppliers page.

Defining Linked Supplier Properties for PunchOut

Access the Supplier Properties page (Select the Supplier Properties tab on the Linked Supplier page).

Use this page to set up or change properties for a PunchOut supplier connection. Before defining properties, you should have already discussed descriptions for the fields with the supplier. For example, the authentication paths should be familiar to you because the supplier should have communicated the values they require for these paths in the XML.

Note. Make sure that you select the PUNCHOUT value for the Direct Connect Method field on the Linked Suppliers page to populate PunchOut property values on this page. When you click the Load Direct Connect Properties button, the system populates this page with predefined properties for the PunchOut method.

This table lists property values that the system uses for the PunchOut direct connect method:

See Also

Setting Up Marketplace Suppliers and Buyers

Connecting to Suppliers Using RoundTrip

Setting up RoundTrip methods are similar to those for PunchOut. The key differences between RoundTrip and PunchOut are the authentication method, format of the shopping cart data, and the format of the purchase order.

This section discusses how to:

• Define linked suppliers for RoundTrip.

• Define linked supplier properties for RoundTrip.

Pages Used to Link to Suppliers Using RoundTrip

Defining Linked Suppliers for RoundTrip

Access the Linked Suppliers page (eProcurement, Administer Procurement, Maintain Supplier Integration, Linked Suppliers. Select the Marketplace Suppliers type on the Linked Suppliers page in Add mode).

Enter these fields that are specific to Direct Connect Suppliers that use RoundTrip:

Note. After you complete a transaction using RoundTrip, you can return to view the shopping cart contents, but you cannot return to the supplier's shopping cart and make changes to the order.

See Using the Linked Suppliers page.

Defining Linked Supplier Properties for RoundTrip

Access the Supplier Properties page (Select the Supplier Properties tab on the Linked Suppliers page).

Use this page to set up or change properties for a RoundTrip supplier connection. Before defining properties, you should have already discussed descriptions for the fields with the supplier. For example, the authentication paths should be familiar to you, because the supplier should have communicated the values they require for these paths.

Note. Make sure that you select the ROUNDTRIP value for the Direct Connect Method field on the Linked Suppliers page to populate RoundTrip property values on this page. When you click the Load Direct Connect Properties button, the system populates this page with predefined properties for the RoundTrip method.

This table describes property values the system uses for the RoundTrip direct connect method:

Troubleshooting Error Messages

There are several errors that can occur during the direct connect process. This table contains a list of potential errors, and the means to resolve the error.