Skip to Main Content
  • Questions
  • Multiple DB triggers on a table for a given ledger or OU or Inventory Org

Breadcrumb

May 4th

Question and Answer

Connor McDonald

Thanks for the question, Arun.

Asked: January 12, 2017 - 9:31 pm UTC

Last updated: January 17, 2017 - 1:20 am UTC

Version: EBS 12.1.3, Database: 11g : 11.1.0.7.0

Viewed 1000+ times

You Asked

Hi,

We have a requirement where the plan is to track any inserts/updates/deletes on some EBS tables. A company has operations across countries & continents. Can database triggers be created on the same table to track changes based on the Ledger (SOB) or Operating Units or Inventory Orgs. Any information would be highly appreciated.

Thanks

and Connor said...

*Can* triggers be created ? Yes.

Is it *supported* to do so ? I dont know - I'm not an EBS person.

But log a call with Support to clarify. If they give the nod of approval, then you could use triggers - you can have multiple triggers on the same table in all recent versions of the database.

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

EBS Question

John Keymer, January 16, 2017 - 11:03 am UTC

This looks like an E-Business Suite applications question. EBS has standard functionality for doing this, known as "AuditTrail" (different from database audit).

https://docs.oracle.com/cd/E18727_01/doc.121/e12843/T156458T156462.htm#I_ax2D10setup

Under the covers it creates the triggers and shadow objects for you.
Connor McDonald
January 17, 2017 - 1:20 am UTC

Thanks for your input John. Much appreciated.

More to Explore

PL/SQL demos

Check out more PL/SQL tutorials on our LiveSQL tool.

PL/SQL docs

PL/SQL reference manual from the Oracle documentation library