Re: Ora Apps ERD's

  • From: "Niall Litchfield" <niall.litchfield@xxxxxxxxx>
  • To: cosmini@xxxxxxxxxxxxxxx
  • Date: Mon, 12 Feb 2007 06:31:57 +0000

Oracle E-Business Suite is the second ERP package that I have worked
with in anger. Neither of them use relational integrity constraints in
the database. At least one reason that was given to me was precisely
so that they could avoid their customers reverse engineering their
design. In addition it means that you pretty much have to used
published APIs and tools to work with the database.

We've had trouble at both sites with data integrity - though to be
fair you could probably assign 'blame' at
customisations/configuration. In the case of APPS I'd caution that you
get people who really know what they are doing working on any
customized workflows that you have, and ditto for any custom framework

On 2/11/07, cosmin ioan <cosmini@xxxxxxxxxxxxxxx> wrote:
<<Oracle Apps does not maintain PK/FK relationships>>

what?  isn't this against all modeling & design principles of databases?
putting PK/FK, constraints, etc  IN THE DATABASE?  am I or someone missing
something big here?    admittedly, I'm new at this Ora Apps thingie and I've
read some articles that there are some 14,000 tables or so, across the
spectrum.  I've downloaded the 26gb install but have not even started
entertaining installing this on Windows or Linux.     ...but not having
integrity across that many tables, if this is true, is asking for trouble
big time, in my opinion.


John Kanagaraj <john.kanagaraj@xxxxxxxxx> wrote:
 Unfortunately, except for a few tables in selected modules, Oracle
Apps does not maintain PK/FK relationships which these modelling
systems use to reverse engineer. There is some consistency in the
column and table naming, but I doubt this will provide limited help.
Another issue is just the massive number of tables in EBS and the
integration between modules that can prove to be more than daunting if
you attempt to draw a meaningful picture....

> I think Cosmin meant aligning the visual layout. You know, getting the
> boxes and lines on the ERDs unjumbled, relationship links lined up
> nicely with no crazy detours around the page, related tables drawn
> vaguely close to each other.
> The kind of alignment that any ER modelling system - ERWin,
> PowerDesigner, System Architect - is soooo good at doing for you ...
> NOT! :-)

Just my 2c!
John Kanagaraj <><
DB Soft Inc
Phone: 408-970-7002 (W)

** The opinions and facts contained in this message are entirely mine
and do not reflect those of my employer or customers **

Niall Litchfield
Oracle DBA

Other related posts: