Jaggaer eProcurement Software

GitLab

Procedures

  • PPRD & PROD

    • NSU_JAGGAER.NSU_JAGGAER_UPDATE_INVOICE_DELTA

    • NSU_JAGGAER.NSU_JAGGAER_UPDATE_USER_DELTA

Tables

  • PPRD & PROD

    • NSU_JAGGAER.NSU_INVOICE_FEED_XML_DELTA

    • NSU_JAGGAER.NSU_USER_IMPORT_XML_DELTA

Argos

  • Server: Unique (Test-MAPS) & Server: TQ-MAPS

    • Data Feeds.Jaggaer.Invoice Feed XML

    • Data Feeds.Jaggaer.User Import XML

    • Finance.Jaggaer.Department Feed

    • Finance.Jaggaer.Supplier Feed

Scripts

  • MAPS.Pre-Production.TQP-MAPS01 & MAPS.Production.TQ-MAPS01

    • C:\Argos_Utils\Jaggaer\jaggaer_invoice_feed

      • app.py

      • argos_start_script.bat

      • EchoArgs.exe

    • C:\Argos_Utils\Jaggaer\jaggaer_user_import

      • app.py

      • argos_start_script.bat

      • EchoArgs.exe

Import Process

User & Invoice Feed

  • Every day at 3:00 AM the Argos Schedule runs Invoice Feed XML and User Import XML datablocks.
  • The query for each is ran against the corresponding Delta Table, to ensure we are only sending them new data.
  • The XML is then sent to our Scripts on MAPS.Production.TQ-MAPS01.
  • App.py will parse the XML to see if there is new data, if no new data is found then a message will be sent to the logs in the same folder and the process will stop.
  • If new data is found then the DOCTYPE will be added and it will be sent through Jaggaer’s API. We get a response back from Jaggaer and parse it, the results are added to the logs as well as emailed to jaggaer_feed@groups.nsuok.edu.
  • If the response was an error then the process will end.
  • If the response was successful then the Delta Table will be updated through the corresponding Procedure.

Known Issues

  • 201: Success but with an error. This usually happens when the user is uploaded to a department that isn’t active for us in Jaggaer. Austin will need to do a manual import of departments.
  • 403 & 500: Errors with our authentication or the XML formatting. The Argos Datablocks and Scripts will need to be checked for the error.
  • Other errors can be found at: https://www.w3.org/Protocols/rfc2616/rfc2616-sec10.html#sec10

Supplier & Department Feed

These reports are manually run by Austin as needed, he then uploads them to Jaggaer manually.

Lucid Chart Diagram  

https://lucid.app/lucidchart/6e99793c-d02e-471a-abfe-4636cbb88924/edit?beaconFlowId=7567AA89EBC98A4D&invitationId=inv_2769f475-e66e-4731-b7e2-a60b57d56b44&page=dQT0ABlkK2XS#

Details

Article ID: 140632
Created
Thu 1/13/22 2:43 PM
Modified
Tue 1/18/22 3:07 PM