Integrating with the Oracle Supplier Network

This chapter provides an overview of the integration between PeopleSoft eProcurement, PeopleSoft eSettlements, and the Oracle Supplier Network and discusses how to:

• Set up the integration to the Oracle Supplier Network.

• Add requisition lines using the Exchange Oracle website.

• Send purchase orders and change orders to the Oracle Supplier Network.

• Receive purchase order acknowledgements from the Oracle Supplier Network.

• Receive advanced shipping notifications from the Oracle Supplier Network.

• Receive invoices from the Oracle Supplier Network.

Understanding the Integration Between the Oracle Supplier Network, PeopleSoft eProcurement, and PeopleSoft eSettlements

The Oracle eCommerce Market Place is composed of the Oracle Supplier Network (OSN) and the Oracle Exchange (Exchange.oracle.com website).

Exchange.oracle.com is a website containing supplier-hosted item catalogs. The PeopleSoft eProcurement Direct Connect feature enables you to integrate with the items in Oracle Exchange using:

• PunchOut: The punchout feature enables PeopleSoft eProcurement requisition users to interact directly with the Oracle Exchange website using XML. Using PeopleSoft Integration Broker, the user is sent from the PeopleSoft eProcurement requisition to the Oracle Exchange website where they can search the item catalogs of one or multiple suppliers and then select items to be placed on their requisition. When finished at the Oracle Exchange website, the user is transported back to the eProcurement requisition. The punchout feature is best suited for products requiring a high degree of configuration (such as computer hardware or office furniture) and specialized services (such as printing or media services).

• Transparent PunchOut: The transparent punchout feature enables PeopleSoft eProcurement requisition users to retrieve items (using XML) from Oracle Exchange without being transferred to the website. With transparent punchout, the requester does not visibly access the Oracle Exchange. Transparent punchout accesses the site in the background (using the PeopleSoft Integration Broker) and returns the search results directly to PeopleSoft eProcurement. Requesters do not leave the eProcurement requisition and do not need to perform additional navigation to return to PeopleSoft eProcurement. The transparent punchout feature is best suited for products with fluctuating prices, or extremely large or specialized catalogs, such as chemical supplies, that you want the supplier to manage.

The requisition is eventually converted to a purchase order, which can be dispatched to the Oracle Supplier Network.

The Oracle Supplier Network (OSN) is an hosted service offering in which buyers and sellers use a common hub for exchanging and monitoring transactions. The integration between OSN and PeopleSoft enables you to pass the following transactions:

• Purchase orders and change orders from PeopleSoft to the OSN supplier (outbound transactions). The purchase order is passed to suppliers through OSN. Suppliers can decide their delivery method, and monitor transactions on OSN.

• Purchase order acknowledgement (POA) or a POA with changes from the OSN supplier to PeopleSoft (inbound transactions). The supplier's POA is sent through OSN to PeopleSoft.

• Advanced Shipping Notification (ASN) from the OSN supplier to PeopleSoft (inbound transaction). The supplier's ASN is sent through OSN and loaded into PeopleSoft as an advanced shipment receipt (ASR) where you can create a receipt in PeopleSoft.

• Invoices from the OSN supplier to PeopleSoft (inbound transaction). The supplier's invoice is sent through OSN and loaded into PeopleSoft where you can create a voucher in PeopleSoft eSettlements.

The following diagram illustrates the communication protocols between PeopleSoft, the Oracle Supplier Network, and the OSN suppliers. PeopleSoft should use OAG (Open Applications Group) XML for the outbound transaction since OSN supports incoming OAG messages over HTTP. The OSN suppliers can send and receive messages using cXML or OAG.

Overview of PeopleSoft to Oracle Supplier Network Integration

For outbound transactions from the PeopleSoft eProcurement or Purchasing applications, the PeopleSoft Integration Broker (Integration Gateway) uses application engine transformation programs and the fscm_epo_OSNListeningConnector IB connector to convert XML messages that use the PeopleSoft format (PSXML) into OAG XML files. For inbound transactions from the Oracle Supplier Network to PeopleSoft eSettlements, OAG XML messages are sent to the PeopleSoft Integration Gateway where transformation programs and the fscm_epo_OSNListeningConnector IB connector convert the incoming files into the PSXML format.

Prerequisites

To set up the connection between eProcurement, eSettlements, and the Oracle Supplier Network (OSN), you must register with OSN and invite your suppliers to register with OSN.

See Oracle Supplier Network User Guide

Common Elements Used in This Chapter

Setting Up the Integration to the Oracle Supplier Network

Complete the following tasks within PeopleSoft to enable the integration between PeopleSoft eProcurement and eSettlements to OSN or the Exchange.oracle.com website:

1. Review the Direct Connect Method page. The sample data contains the method, EXCH_ORACLE to setup the punchout to the Exchange.oracle.com website. Review this information and make any changes necessary for your environment.

2. Review the EDX PO Dispatch Types page. The sample data contains the EDX PO Dispatch Type of OAG72 for dispatching purchase orders to the Oracle Supplier Network. Review this information and make any changes necessary for your environment.

3. Use the Linked Suppliers page to connect PeopleSoft vendors to OSN suppliers. For each vendor, you can define the EDX PO dispatch type OAG72 (for OSN suppliers) and define OSN information to enable the connection.

4. In the PeopleSoft Integration Broker, review and activate the service operations used to integrate PeopleSoft to OSN and Exchange.oracle.com..

5. Create a node to connect to the Oracle Supplier Network and the Exchange.oracle.com. The PeopleSoft system is delivered with the PSFT_EXCH_ORACLE node for the Exchange.oracle.com website and the PSFT_ORACLE_SUPPLIER_NETWORK node for the Oracle Supplier Network.

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

6. Activate a routing to be used with the node. The PeopleSoft system is delivered with routings for each service operation needed to integrate with OSN or Exchange.oracle.com. These routings contain the transformation programs needed to convert messages from OAG to PSXML and vice versa. These routings can be altered to fit your environment.

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

7. Review or change queue definitions. The PeopleSoft system is delivered with queues for each service operation needed to integrate with OSN or Exchange.oracle.com.

   See PeopleTools PeopleBook: Integration Broker, "Managing Service Operation Queues"

8. Setup node connectors. The PeopleSoft system is delivered with the fscm_epo_OSNListeningConnector connector.

9. To integrate with Exchange.oracle.com, complete the direct connect setup steps located in the "Integration with Direct Connect Suppliers" chapter of this PeopleBook.

PeopleSoft users can leverage OSN's Transaction Monitor to view message statuses and errors, use self-service tools to connect to OSN, and test the ability to transmit inbound and outbound documents. Users can receive notifications of incoming messages that are applicable to them. For example, PeopleSoft eSettlements administrators can receive alerts for inbound invoices only.

Pages Used to Setup the Integration to the Oracle Supplier Network

Activating the Service Operations

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 these service operations 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

PeopleTools PeopleBook: Integration Broker

Adding Requisition Lines Using the Oracle Exchange Website

The direct connect feature enables PeopleSoft eProcurement requisition users to interact directly with the Oracle Exchange website that contains supplier-hosted item catalogs. While entering a requisition in PeopleSoft eProcurement, a user can to integrate with the items in Oracle Exchange using:

• PunchOut: The punchout feature enables PeopleSoft eProcurement requisition users to interact directly with the Oracle Exchange website using XML. Using PeopleSoft Integration Broker, the user is sent from the PeopleSoft eProcurement requisition to the Oracle Exchange website where they can search the item catalogs of one or multiple suppliers and then select items to be placed on their requisition. When finished at the Oracle Exchange website, the user is transported back to the eProcurement requisition. The punchout feature is best suited for products requiring a high degree of configuration (such as computer hardware or office furniture) and specialized services (such as printing or media services).

• Transparent PunchOut: The transparent punchout feature enables PeopleSoft eProcurement requisition users to retrieve items (using XML) from Oracle Exchange without being transferred to the website. With transparent punchout, the requester does not visibly access the Oracle Exchange. Transparent punchout accesses the site in the background (using the PeopleSoft Integration Broker) and returns the search results directly to PeopleSoft eProcurement. Requesters do not leave the eProcurement requisition and do not need to perform additional navigation to return to PeopleSoft eProcurement. The transparent punchout feature is best suited for products with fluctuating prices, or extremely large or specialized catalogs, such as chemical supplies, that you want the supplier to manage.

The requisition is eventually converted to a purchase order, which can be dispatched to the Oracle Supplier Network.

For additional setup information, see the "Integrating with Direct Connect Suppliers" chapter of this PeopleBook.

See Integrating with Direct Connect Suppliers.

Sending Purchase Orders and Change Order to the Oracle Supplier Network

Purchase orders can be sent to OSN suppliers using the following steps:

1. The purchase orders are created and approved in either PeopleSoft eProcurement or PeopleSoft Purchasing. Attachments can be included with the purchase orders at either the header level or line level.

2. The purchase orders are dispatched to an OSN supplier using the electronic data exchange (EDX) method in either PeopleSoft eProcurement or PeopleSoft Purchasing. The dispatch process places the purchase orders in the PeopleSoft outbound staging tables.

3. The PeopleSoft Integration Broker picks up the purchase order data in the outbound staging tables and uses the service operation PV_ORDER to create the message. The routing on the service operation contains the transformation program PV_ORD_OAG that converts the purchase order from PSXML to OAG XML.

4. The connector address, fscm_epo_OSNListeningConnector, receives the XML message from PeopleSoft eProcurement, wrap the final message in a multipart MIME envelope, and then ships the message to OSN. This connector is also responsible for handling PO attachments and including them with the corresponding purchase order in the message to OSN.

5. The Oracle Supplier Network passes the purchase order to the OSN supplier.

Change orders follow the same business process flow but only the modified lines are sent to OSN and the XML document indicates that this is a change order instead of a purchase order.

In order to send a PeopleSoft purchase order or change order to the Oracle Supplier Network the OSN supplier must be defined on the Linked Supplier page with a EDX PO Dispatch Type of OAG72. The OSN supplier ID and supplier type are also on this page to link the PeopleSoft vendor ID to the OSN supplier.

The PeopleSoft system is delivered with the following setup for transmitting purchase orders to OSN, this data may need to be altered for your environment:

• Service operation: PV_ORDER

• Message: PV_ORDER version 1

• Application Engine transformation program: PV_ORD_OAG

• Routing: ORACLE_SN_ORDER

• Node: PSFT_ORACLE_SUPPLIER_NETWORK

• Queue: PV_MS_ORD_DISPATCH

• Connector: fscm_epo_OSNListeningConnector.

See Dispatching Purchase Orders in PeopleSoft eProcurement.

Receiving Purchase Order Acknowledgements from the Oracle Supplier Network

Purchase order acknowledgements (POAs) can be sent from OSN suppliers to PeopleSoft using the following steps:

1. The Oracle Supplier Network transmits the POAs from the OSN supplier.

2. The PeopleSoft connector, fscm_epo_OSNListeningConnector, catches the inbound message which is routed to the PURCHASE_ORDER_ACKNOWLEDGEMENT service operation.

3. The routing on the service operation contains the transformation program SAC_OAG72POA that converts the POAs from OAG XML to PSXML.

4. The handler PurchaseOrderAcknowledgement, that is defined on the service operation, is executed to update the POA tables in PeopleSoft.

5. POAs can be reviewed on the Manage PO Acknowledgements page in PeopleSoft (Purchasing, Purchase Orders, Acknowledgements, Manage PO Acknowledgements).

6. If the POA results in changes, a change order may be generated.

There are two options for receiving a purchase order acknowledgement from the 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) where you can view the status from the PO Dispatch Message page (eProcurement, Buyer Center, Dispatch Purchase Order, Dispatch Message Log).

The PeopleSoft system is delivered with the following setup for receiving purchase order acknowledgements from OSN, this data may need to be altered for your environment:

• Service operation: PURCHASE_ORDER_ACKNOWLEDGEMENT

• Message: PURCHASE_ORDER_ACKNOWLEDGEMENT version 1

• Application Engine transformation program: SAC_OAG72POA

• Routing: ORACLE_SN_POA

• Node: PSFT_ORACLE_SUPPLIER_NETWORK

• Queue: PURCHASE_ORDER

• Handler: PurchaseOrderAcknowledgement

• Connector: fscm_epo_OSNListeningConnector.

Receiving Advanced Shipment Notifications from the Oracle Supplier Network

Advanced shipping notifications (ASNs) can be sent from OSN suppliers to PeopleSoft where they are received as advanced shipping receipts (ASRs). The following steps are used:

1. The Oracle Supplier Network transmits the advanced shipping notifications from the OSN supplier.

2. The PeopleSoft connector, fscm_epo_OSNListeningConnector, catches the inbound message which is routed to the ADVANCED_SHIPPING_RECEIPT service operation.

3. The routing on the service operation contains the transformation program SAC_OAG72ASN that converts the ASNs in OAG XML to the ASRs in PSXML.

4. The handler AdvancedShippingReceipt, that is defined on the service operation, is executed to update the Receipt Load tables in PeopleSoft.

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

6. ASRs can be reviewed on the ASR Review page in PeopleSoft.

Note. A link to the PeopleSoft eSettlements application and to the PeopleSoft eSupplier Connection application is provided within the Oracle Supplier Network on the Trading Partners section.

The PeopleSoft system is delivered with the following setup for receiving ASNs from OSN, this data may need to be altered for your environment:

• Service operation: ADVANCED_SHIPPING_RECEIPT

• Message: ADVANCED_SHIPPING_RECEIPT version 2

• Application Engine transformation program: SAC_OAG72ASN

• Routing: ORACLE_SN_ASN

• Node: PSFT_ORACLE_SUPPLIER_NETWORK

• Queue: ADVANCED_SHIPPING_NOTICE

• Handler: AdvancedShippingReceipt

• Connector: fscm_epo_OSNListeningConnector.

Pages Used to Receive Advanced Shipment Notifications from the Oracle Supplier Network

Receiving Invoices from the Oracle Supplier Network

Invoices can be transmitted from OSN suppliers to PeopleSoft where they are received as vouchers in PeopleSoft Payables through PeopleSoft eSettlements. The following steps are used:

1. The Oracle Supplier Network transmits the invoice from the OSN supplier.

2. The PeopleSoft connector, fscm_epo_OSNListeningConnector, catches the inbound message which is routed to the EM_VOUCHER_IN service operation.

3. The routing on the service operation contains the transformation program SAC_OAG72INV that converts the invoices in OAG XML to vouchers in PSXML.

4. The handler EmVoucherIn, that is defined on the service operation, is executed to update the voucher staging tables in PeopleSoft.

5. The Voucher Build process is then executed to create a voucher.

6. The Voucher Inquiry page can be used to review vouchers.

Note. In order to receive invoices from OSN suppliers, PeopleSoft Payables and PeopleSoft eSettlements must be installed. A link to the PeopleSoft eSettlements application and to the PeopleSoft eSupplier Connection application is provided within the Oracle Supplier Network on the Trading Partners section.

The PeopleSoft system is delivered with the following setup for receiving invoices from OSN, this data may need to be altered for your environment:

• Service operation: EM_VOUCHER_IN

• Message: EM_VOUCHER_IN version 1

• Application Engine transformation program: SAC_OAG72INV

• Routing: ORACLE_SN_VOUCHER_IN.

• Node: PSFT_ORACLE_SUPPLIER_NETWORK

• Queue: EM_VOUCHER_IN

• Handler: EmVoucherIn

• Connector: fscm_epo_OSNListeningConnector.

Pages Used to Receive Invoices from the Oracle Supplier Network