Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Ora Apps ERD's

Re: Ora Apps ERD's

From: Niall Litchfield <>
Date: Mon, 12 Feb 2007 06:31:57 +0000
Message-ID: <>

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

On 2/11/07, cosmin ioan <> 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.
> cheers,
> Cos
> John Kanagaraj <> 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
Received on Mon Feb 12 2007 - 00:31:57 CST

Original text of this message