Coupa Integration

Oracle (E-Business Suite 11i/R12) – Coupa (e-Procurement) Integration.

Are you looking for Oracle E-Business Suite 11i/R12 and Coupa Integration?

No Problem, we can help you.
Our (OptioSys Technologies) cloud integration team has done Oracle-Coupa integration with and wihtout third party application/service.
You can use your IT/consulating resource to get develop own integration process using oracle based web service solution like Oracle SOA, BPEL, Oracle’s utility (UTL_HTTP) or buy third party integration services like Dell Boomi, IBM Cast Iron etc.
If you want to develop your own integration program then get IT person who has following knowledge.
  • Oracle E-Business Suite (at least AP and PO)
  • Oracle PL/SQL programming
  • Web Services

 Now write a PL/SQL program, call Coupa’s web service API using oracle’s UTL_HTTP utility and integrate Coupa with your E-Business Suite application.

STEP 1: Write custom PL/SQL program to get approved invoices from coupa using UTL_HTTP

https://mycoupa.coupahost.com/api/invoices?exported=false&status=approved

STEP 2: Parse Coupa XML response and insert data into statging table
–xx_coupa_ap_inv_staging

STEP 3: Run data validation and insert validated staging data into AP interface tables
   – ap_invoices_interface
   – ap_invoice_lines_interface

STEP 4: Call AP Invoice Open Interface program to import interface data

STEP 5: Update coupa invoice with “exported = true”
(Invoices imported from coupa and created into AP module) 

STEP 6: Generate log/email alert and send to AP Admin/user

Coupa integration overview

You can sync following data between oracle and Coupa.

  • Suppliers
  • Addresses
  • Accounts
  • Currencies
  • Items
  • Requisitions
  • Purchase Orders
  • Inventory Transactions
  • Receipts
  • Invoices
  • Users

It is very simple, flexible, maintenance free and cost effective.

=========
Keywords
=========
Coupa Integration, Oracle (AP)-Coupa Integration, Supplier from Coupa, Vendor from Coupa,
Requisition from Coupa, Purchase Orde From Coupa, Invoice from coupa, Web Service Integration

This entry was posted in Oracle E-Business Suite, Web Service Integration.

One Response to Coupa Integration

  1. Anonymous says:

    I would like to say "Thank you very much" for this posting.

    It has been very helpful to me.

    Regards
    Michele