Punchout Mapping cXml

Part of our procurement setup we have created a number of Item Category Name and linked to Charge account “Expense code” as per below:

Manage Supplier Content Map Sets:

UOM Mapping: This is mapped such

Category Mapping: the supplier has provided a single reference used, which I am attempting the map for 4 different Internal Category name

The system does not allow same External Category to be used more than once

How to Map Supplier Item Number Through Punchout to Item Number in Inventory (Doc ID 227268.1)

Punchout in Fusion Self Service Procurement Explained (Doc ID 1323912.1)

Run the following diagnostic on note if the Punchout is still not working after following the above notes : Punchout Connectivity ValidateDoc ID 1331902.1

Punchout: Directory to place supplier certification file also profile valueWe are doing fresh Fusion Implementation and we need to setup punch out to staples for a direct access to supplier hosted catalog ,cXML option .

1) I have configured content zone and catalog with the URL and credentials that the supplier provided and tested the connection ,however we need to know the directory or file path where the suppliers certification file should be placed in ?

(Punch out set up guide states that " Punchout from Oracle Fusion Self Service Procurement directly to Supplier-Hosted Catalog (XML or cXML), the supplier’s certification authority needs to be on the fusion_trust.jks file in Oracle Fusion Self Service Procurement"

In Oracle Fusion Self Service Procurement, the fusion_trust.jks file should be readable and accessible from the middle tier. If the Oracle Fusion Self Service Procurement implementation has multiple Java Virtual Machines (JVMs), the fusion_trust.jks file should be accessible from all the JVMs. )

2) Also we need to know the values to set up the following profile options for punch out
• POR : Proxy Server Name
• POR : Proxy Server Port

Answer

1) You can check where the jks file is and make sure that certifying authority of the supplier's certificate is part of this jks.

Steps to identify the location of the fusion_trust.jks:
a. Login to WLS console
b. Expand Environment -> Click Servers
c. Click the server which you are interested in -> Navigate to Keystore tab
d. You will find the trust store configured in "Custom Trust Keystore" attribute value.

oracle@syfar06080p05 edgg-test:ADMIN-APPS config]$ nslookup opc-proxy
Server: 10.192.9.101
Address: 10.192.9.101#53

opc-proxy.audc1.oraclecloud.com canonical name = sy3-opc-proxy.audc1.oraclecloud.com.
Name: sy3-opc-proxy.audc1.oraclecloud.com
Address: 10.192.9.102

Punchout setup

SETUP

Navigate: Purchasing -> Catalogs -> Manage Supplier Content Map Sets

(this is to map the UNSPC Codes with the Purchasing Category in fusion)

                     

Values are given as below(In JD Williams DEV Instance):

Catalog:  Office Team

Keywords: Stationery

Image URL: http://www.officeteam.co.uk/wp-content/themes/officeteam/images/content/facebook-og-image.png

Supplier: OFFICE TEAM LTD

Domain: DUNS

Identity: JDWIL

Supplier Name: Office Team

Supplier ID: 2010062

Punchout URL: https://www.officeteamconnect.co.uk/easyorder.cxml/xmlreceive?reference=JDWIL&message=PunchOutSetupRequest

Map Set: OFFICE TEAM

Password:  123er4Q