Integrating PeopleSoft eProcurement Transactions with a Marketplace

This section provides an overview of transaction integration and discusses how to use the Marketplace Registration Wizard, test the transactional Marketplace integration, move from a test environment to the production environment, prepare to use Marketplace catalog search, and receive a purchase order acknowledgement.

Page Name

Definition Name

Usage

Administer Procurement Page

PV_ADM_MAIN

Access other procurement administration pages. This page consists entirely of links to other pages.

Maintaining Supplier Integration Page

PV_ADM_MARKETSITE

Access supplier integration pages. This page consists entirely of links to other pages.

Maintain Suppliers Page

PV_ADM_VNDR

Access supplier-related pages. This page consists entirely of links to other pages.

Maintain Business Units Page

PV_ADM_SETUP_BU

Access business unit-related pages. This page consists entirely of links to other pages.

Marketplace Test Page

SAC_MP_VERIFY

Use this page to verify that PeopleSoft eProcurement and the Marketplace are communicating.

Supplier Information - Summary Page

VNDR_ID1_SUM

This is the first page of the component where you create supplier records.

Linked Suppliers Page

PV_MS_SEC_SUPPLIER

Use the Link Suppliers page to tie Direct Connect and Marketplace supplier information to a supplier.

Supplier Properties Page

PV_MS_SEC_SUP_NV

Use the Supplier Properties page to identify information for the specific supplier location.

Marketplace Registration Wizard Page

SAC_MP_COMPANY

Set up the company's registration with the Marketplace.

Marketplace Buyer Setup Page

PV_MS_SEC_BUYER

Use the Marketplace buyer page to define the URL the system uses when contacting the Marketplace.

eProcurement Business Unit Options Page

PV_BUS_UNIT_PM

Configure the business unit to display the PO acknowledgements button and the advanced shipment notification (ASN) button.

Define Static Maps Page

SAC_MAP_VALUE_ONLY

Enter details that tell the system how to read data coming from the outside source and what value to use in the PeopleSoft format.

This overview discusses:

  • Marketplace catalog search integration.

  • Receipt of Purchase Order Acknowledgements from a Marketplace.

  • Receipt of an Advanced Shipment Notification (ASN).

  • Receipt of an Invoice.

Marketplace Catalog Search Integration

The Marketplace catalog search is an application that hosts multiple supplier catalogs within the Marketplace.

This diagram illustrates an overview of Marketplace catalog search launched by an PeopleSoft eProcurement user. Users are transferred to the MarketPlace catalog search, where they can search the aggregated supplier catalog and return results to the shopping cart within PeopleSoft eProcurement.

This diagram illustrates an overview of Marketplace catalog search launched by an PeopleSoft eProcurement user.

Marketplace Catalog Search by a user within PeopleSoft eProcurement

To set up and use the Marketplace catalog search, you must:

  1. Set up security that enables requesters to move from the eProcurement requisition into the Marketplace.

  2. Create supplier profiles and supplier locations, and link the properties of that supplier to the information that creates a link to a Marketplace.

    Note: Upon completion of this setup, a link will be provided in the eProcurement requisition. Selecting this link directs the requester to the Marketplace site.

  3. Set up background details that determine which supplier catalogs the requester can view.

    The Marketplace validates requester security and displays the catalogs that the requester can view. The requester selects catalog items and returns to the requisition. The system populates the selected items as requisition lines.

Receipt of Purchase Order Acknowledgements from a Marketplace

The purchase order acknowledgement (POA) is a collaboration among the supplier, the Marketplace, and the PeopleSoft application. To create and transmit a POA, these steps must occur:

  1. Once the purchase order has been dispatched from PeopleSoft, the supplier logs into the Marketplace and finds that the purchase order is available in a queue for that specific supplier. Suppliers can initiate a POA document from the Marketplace.

  2. The Marketplace then transmits xCBL formatted POA to PeopleSoft, where it is transformed to the PeopleSoft internal format PSXML.

  3. The inbound message populates the PO Electronic Commerce tables.

  4. If the POA results in changes; a change order may be generated.

This diagram represents the flow of the POA from the Marketplace.

Purchase Order Acknowledgement generated in Marketplace after receipt of a purchase order from PeopleSoft eProcurement.

Note: The POA is mapped to a line, not to a schedule within the Marketplace. Only one schedule is allowed within Marketplace POA integration.

Note: The Notes to Buyer from the Marketplace are not mapped to the PeopleSoft system.

Two options are available for receiving a purchase order acknowledgement from a supplier. The first is a POA, which uses the PeopleSoft Purchasing functionality and stores the status within Purchasing tables. The second is the POR (purchase order response), which is where you can view the status from the PO Dispatch Message page. eProcurement > Buyer Center > Dispatch Purchase Order > Dispatch Message Log.

Receipt of an Advanced Shipment Notification (ASN)

The supplier uses the advanced shipping receipt (ASR) enterprise integration point (EIP) to notify the PeopleSoft system that the order has been fulfilled. To complete the integration, these steps must occur:

  1. A supplier is able to enter advanced shipping notifications (ASNs) within the Marketplace site.

  2. Once submitted, Integration Broker transforms this data to the PeopleSoft inbound ASR message using the Advanced Shipping Receipt (ADVANCED_SHIPPING_RECEIPT) service operation in PeopleSoft.

  3. The message populates the Receipt Load tables.

  4. The Receipt Loader process is then run to create a receipt, which may then be approved by an administrator.

This diagram represents the flow of the supplier-entered ASN from the Marketplace.

Advanced Shipping Receipt (ASR) generated in Marketplace after receipt of a purchase order from PeopleSoft eProcurement.

Receipt of an Invoice

When an integrated supplier creates and invoice and sends it to the Marketplace, or when an invoice is created, the Marketplace sends the invoice to the Integration Broker. Integration Broker then transforms the invoice from xCBL 3.0 to the PeopleSoft inbound XML invoice message.

From the Integration Broker, the Marketplace partner ID (MPID) that is passed from the Marketplace is used to look up the supplier ID field using the Linked Supplier table. The supplier SetID and supplier ID are retrieved based on this information.

Once the supplier ID is established, the invoice is loaded to the voucher staging tables.

When the data is in the staging tables, these steps take place:

  1. Voucher build is run.

  2. Voucher is created.

  3. Matching may be run if the voucher has an associated purchase order or receipt.

  4. Paycycle process creates a payment.

This diagram represents the flow of an invoice from the Marketplace as defined in the above steps.

This diagram represents the flow of an invoice from the Marketplace.

Invoice Transactions generated in Marketplace after receipt of a purchase order from PeopleSoft eProcurement.

Note: The Marketplace invoice integration is not supported if PeopleSoft eSettlements is active.

PeopleTools: Integration Broker

Use the Marketplace Registration Wizard page (SAC_MP_COMPANY) to set up the company's registration with the Marketplace.

Navigation:

Click the Marketplace Registration link on the Maintain Supplier Integration page.

The wizard will guide you to enter this information before submitting the registration:

  • Company information.

  • Company contacts.

  • Gateway information.

This example illustrates the fields and controls on the Company Information – Marketplace Registration Wizard.

Company Information - Marketplace Registration Wizard

Enter the company information, including the User ID and Password to use when logging into the Marketplace.

Enter the Gateway production and test URL.

See Marketplace Test Page, Moving From a Test Environment to the Production Environment.

Use the Marketplace Test page (SAC_MP_VERIFY) to use this page to verify that PeopleSoft eProcurement and the Marketplace are communicating.

Navigation:

Click the Marketplace Test link on the Maintain Supplier Integration page.

Before using the production environment, you should elect to submit a test. This test verifies that PeopleSoft eProcurement is communicating with the Marketplace test environment by sending a predefined purchase order with a predefined test supplier. The purchase order will be a generic, nonconfigurable, purchase order. It will only be used to test the connectivity; it will not be fulfilled.

Once you have successfully tested the PeopleSoft test environment, the administrator performs these tasks to move the buyer setup data into the production database:

  1. Log in to Data Mover for the source and test database.

  2. Use Marketplace script upd304852_01.dmsto export relevant Marketplace definitions:

    • Marketplace buyer.

    • Marketplace registration information.

  3. Log in to Data Mover for the target and production database.

  4. Use Marketplace script upd304852_02.dmsto import relevant Marketplace definitions:

    • Marketplace buyer.

    • Marketplace registration information.

  5. When you are ready for production, navigate to the Marketplace buyer page and change the URL to the Marketplace production URL.

    See Marketplace Buyer Setup Page.

Before you begin using Marketplace catalog search, you must create a link to the Marketplace. This link will appear on the requisition for users to access the supplier catalogs:

  1. Create a generic supplier profile for the Marketplace that is then tied to a link supplier configuration. This combination is used to link to the Marketplace website to the requisition.

  2. Set up logins for each location, and register each within the Marketplace.

  3. Create a supplier profile for each supplier the company does business with.

  4. Associate each supplier location with its individual linked supplier; this includes all supplier locations for the Marketplace supplier profile.

  5. Create a node for each login ID that is passed from eProcurement to the Marketplace.

Setting up Supplier Profiles

Access the Supplier Information - Summary page.

Navigation:

eProcurement > Administer Procurement > Maintain Suppliers > Supplier Information

To enable the Marketplace integration, you must complete these tasks:

  1. Create a supplier profile for the Marketplace.

  2. Create supplier locations for every login ID you have with the Marketplace.

  3. Create supplier profiles for each supplier you do business with within the Marketplace.

  4. Create link supplier identifiers for each supplier location.

See Understanding Supplier Maintenance.

Using Rule-Based Catalogs with the Marketplace

Rule-based catalogs are a form of security within PeopleSoft eProcurement. As an administrator, you have the option of allowing requesters visibility of catalogs, as well as the links to the direct connect suppliers, based on the criteria you define within the catalog security. The Marketplace is considered a direct connect supplier in this case. You can determine requester access based on role, business unit, or a specific requester ID. Think of each Marketplace catalog search link as a different catalog. Use rule-based catalogs to help in determining which catalogs requesters are capable of viewing upon login to the Marketplace.

See Understanding Catalog Security.

Use the Define Static Maps page (SAC_MAP_VALUE_ONLY) to enter details that tell the system how to read data coming from the outside source and what value to use in the PeopleSoft format.

Navigation:

Click the Integration Data Value Mappings link on the Maintain Supplier Integration page.

This example illustrates the fields and controls on the Define Static Maps page.

Define Static Maps page

PeopleSoft is delivered with POA statuses mapped from the Marketplace header and line formats. If you add a new status in the Marketplace, you can add the mapping to the PeopleSoft status codes.

These are the POA header status mappings:

Marketplace Value

xCBL 3.0 Value

PeopleSoft Value (ACK_Status)

Accepted

Accepted

AT (Accepted)

Accepted with Changes

AcceptedWithAmendment

IC (Accepted with Changes)

Cancelled

NotAccepted

RD (Rejected)

Completed

AcceptedWithAmendment

IC (Accepted with Changes)

Not Accepted

NotAccepted

RD (Rejected)

Other

AcceptedWithAmendment

IC (Accepted with Changes)

Payment Required

AcceptedWithAmendment

IC (Accepted with Changes)

Processing

AcceptedWithAmendment

IC (Accepted with Changes)

All Other Statuses

All Other Statuses

ZZ (mutually defined)

The POA line status mapping options are:

Marketplace Value

xCBL 3.0 Value

PeopleSoft Value (ACK_Status)

Accepted

ItemAccepted

AT (Accepted)

Accepted with Changes

AcceptedWithAmendment

IC (Accepted with Changes)

Cancelled

NotAccepted

RD (Rejected)

Completed

AllreadyDelivered

IC (Accepted with Changes)

Not Accepted

ItemNotAcceptedByTheSeller

RD (Rejected)

Other

AcknowledgeWithDetailAndChange

IC (Accepted with Changes)

PrePayment Required

Other

ZZ (mutually defined)

Processing

Pending

ZZ (mutually defined)

All Other Statuses

All Other Statuses

ZZ (mutually defined)