Integrating with 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.

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.

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

Invoices can be transmitted from OSN suppliers to PeopleSoft where they are received as vouchers in PeopleSoft Payables through 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.

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

• 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