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.

Visit for more information http://blog.optiosys.com/