Q
Manage Learn to apply best practices and optimize your operations.

Why no integrity constraints in Oracle E-Business Suite?

Why doesn't Oracle's own E-Business Suite carry any integrity constraints?

Hi Brian, in response to your answer for the query of leaving the data integrity to the DB by creating foreign keys or managing them through the application logic, you answered DB integrity is the best option. But I wonder why Oracle's own E-Business Suite doesn't carry any integrity constraints across the whole suite! Oracle Applications manages everything by way of code and not imposing any constraints (I don't say there are no constraints, still there are but relatively few). What's your opinion on this?
Without knowing more about the product, I would tend to say that this is poor design. As I stated in my earlier response, leave the data integrity to the database. I have rarely seen a reason to code data integrity in the app with today's Oracle database. I am always leery of apps that do not have constraints in the database. For those systems, I make sure that any changes to the data are always done with the app, otherwise, I can easily bypass their data protection mechanisms.
This was last published in July 2007

Dig Deeper on Oracle E-Business Suite

PRO+

Content

Find more PRO+ content and other member only offers, here.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close