0 Replies Latest reply on Aug 17, 2013 1:32 AM by dario

    Database privileges for integration between EBS and Third Party software




      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 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.