On 2/11/07, Niall Litchfield <niall.litchfield@xxxxxxxxx> wrote:
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.
I am somewhat familiar with SAP, Oracle Apps and Lawson Lawson - Legacy Mainframe app. V/ISAM files copied to tables SAP - Same as Lawson Oracle Apps - Not quite as sure about it, but I believe its origins predate the use of referential integrity in the database. I first started with Apps 9.x, but I don't recall too much of what the tables looked like. After upgrading from 10.7 to 11i, it doesn't appear that much has changed in the tables, at least the few tables I work with directly. Additions, yes, but I don't think wholesale changes to the schema This could be mistaken, as I am only familiar with some of the HR tables. Other modules may have much more change. -- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist