Tag: Oracle Applications R12

I did some initial schema analysis on Oracle Apps R12 sample database, VIS.

VIS uses hardly any primary keys, many non unique indexes, and a LOT of package and triggers.

Lots of potential for data integrity and tuning issues.

Continue Reading →