Integrating with the Oracle Supplier Network
This section provides an overview of the integration with the Oracle Supplier Network and discusses how to receive Invoices from the Oracle Supplier Network.
Page Name |
Definition Name |
Usage |
---|---|---|
VCHR_BATCH_RQST |
Run this process to create voucher record sets from many sources including XML invoices. See Processing Batch Vouchers. |
|
AP_VOUCHER_INQUIRY |
Search for and review vouchers and any payment information. See Reviewing Voucher Information. |
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](img/i2a517932n-7073.png)
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:
The Oracle Supplier Network transmits the invoice from the OSN supplier.
The PeopleSoft connector, fscm_epo_OSNListeningConnector, catches the inbound message which is routed to the EM_VOUCHER_IN service operation.
The routing on the service operation contains the transformation program SAC_OAG72INV that converts the invoices in OAG XML to vouchers in PSXML.
The handler EmVoucherIn, that is defined on the service operation, is executed to update the voucher staging tables in PeopleSoft.
The Voucher Build process is then executed to create a voucher.
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
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
PeopleSoft Service Operation |
OSN Transaction Name |
cXML Equivalent |
---|---|---|
EM_VOUCHER_IN |
OAG Process Invoice 002 |
PeopleSoft eSettlements will receive XML invoices (cXML) Invoice Detail |