This discussion is archived
0 Replies Latest reply: Aug 16, 2013 6:32 PM by dario RSS

Database privileges for integration between EBS and Third Party software

dario Newbie
Currently Being Moderated

Hi,

 

We have engaged a third party invoice scanning software vendor that wants to install database components on our existing EBS database.

 

We run Oracle EBS 11.5.10.2 on a 10g database. The third party software vendor wants privileges like select, update, insert, delete on Oracle EBS tables like ap_invoices_all, po_distributions_all, gl_code_combinations, and all important workflow tables.

 

The third party software vendor says the privileges are needed for their APIs and I have refused to grant the privileges. My employer now wants me to justify my refusal.

 

Does anyone know if Oracle have documents that say that direct updates on Oracle EBS Application tables is not acceptable? The manuals have the “Do Not Use Database Tools to Modify Oracle Applications Data” section but is there anything else?

 

Thanks for any suggestions.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points