Information Technology, Control, Audit and Security Experience

As an IT control officer or an IT auditor you will at one time have the challenging opportunity of reviewing and evaluating the controls of your organisation's Oracle E-Business suite. This could really be a daunting task mostly if you have NOT been trained on Oracle E-Business suite administration. It can a times, presents itself as a complex application. This was my position at my workplace. I had to research and build a suitable control work plan/audit plan which of course  I will gladly share. Please note that this is compilation based on research and actual experience. I will however appreciate positive and constructive criticism/feedback on this post.

Of course we all know what an Index is and how it is used. We are already familiar with its usage while reading books of large page volumes. We also know how ridiculous it would look to index for example, a 5 page booklet. Well indexing also applies to tables in Oracle database and very much every other databases pout there. Indexes are objects in the database that provides a mapping of all the values in a table column, along with the ROWIDs for all rows in the table that contains the value for the column. A ROWID is a unique identifier for a row in an oracle database table. An example of a rowid is the matriculation number of a student in a particular school. Hence Indexes however are used to make searches on tables faster. It is mostly not needed on a small table as its effect will not be seen. There are 2 types of indexes: ·          B*Tree ·          Bitmap Let’s look at them one...