SciQuest - KFS Technical Details

Owned by Kathleen Avery (Deactivated)
Last updated: Jun 14, 2017

 

SciQuest Support:

SciQuest can be contacted thru customer support 1-800-223-1121 or support@sciquest.com.  If asking for help via email, indicate if the system is Test or Prod.  Usually you will need to request the logs for the day and time of the error. 

Punchout (Purchase Requisitions)

UConn sends credentials (handshake) to SciQuest:

      work/src/edu.uconn.kuali.kfs.module.purap.util.cxml/PunchOutSetupCxml.java

      work/web-root/static/xsd/purap/b2bPunchOutOrder.xsd 

UConn retrieves Shopping cart from SciQuest and processes into a requisition:

     work/src/edu.uconn.kuali.kfs.module.purap.document.service.impl/B2BShoppingServiceImpl.java 

     work/web-root/static/xsd/purap/b2bPunchOutOrder.xsd

PO Export

All purchase orders are sent to SciQuest.  SciQuest will read the cxml, evaluate and return a status code to UConn.  UConn evaluates the status code and updates the purchase order.  If there is no errors the Purchase Order will have a status of open.  If an error is returned, the status will be cxml error.  

      work/src/edu.uconn.kuali.kfs.module.purap.document.service.impl/B2BPurchaseOrderSciquetsServiceImpl.java

      work/web-root/static/xsd/purap/b2bPOResponse.xsd

      work/web-root/static/xsd/purap/purchaseOrder.xsd   

eInvoice

Electronic invoices are sent from SciQuest to prdkfs_rmt /srv/uconn_configs/kfs-config/work/prd/kfs/staging/purap/electronicInvoice/*.xml, where * is the invoice number. PRD-KFS-SciQuest_data_xfer is a Control-M job is run each morning at 8:15am to transfer all electronic invoices found on the batch server to kfs-prd /srv/uconn_configs/kfs-config/work/dev/kfs/staging/purap/electronicinvoice.   ElectronicInvoiceExtractJob will run to process the retrieved invoices.  Results are placed in prd /srv/uconn_configs/kfs-config/work/dev/kfs/staging/purap/electronicinvoice/accept or prd /srv/uconn_configs/kfs-config/work/dev/kfs/staging/purap/electronicinvoice/reject.  Emails are sent out to functional SME's indicating any rejects. If there are no issues a payment request is created and routed thru RICE.

       work/web-root/static/xsd/purap/electronicinvoice.xsd

       work/src/edu.uconn.kuali.kfs.module.purap.service.impl/ElectronicInvoiceHelperServiceImpl.java