Oracle Financials Health Checks, Audits & Security Reviews

An Oracle system needs regular servicing just like a car, and that servicing is most effective when the technician knows what to look for.

Our health checks focus on reviewing Setup & configuration within the applications, data review, and reporting.

Each item has an expected elapsed time and you can buy a system audit in individual components, as long as they total a minimum of 8 hours.   This will allow you to just spend in the areas that you are most concerned about.

A standard health check will include the following

System Administration

Description	This will Cover	We require from you	Estimated Time
Review of users & responsibilities	·          Review of access against user types. ·          Inconsistent menus between operating units & countries ·          Inconsistent or missing profile options ·          Assignment of security rules to users & responsibilities ·          Table level auditing	·          1-2 hour meeting to discuss your data access policy & procedures. ·          Access to SQL & front end applications on a recent copy of production	4 hours
Key & descriptive flexfields structures	·          This item is only really necessary if you have made extensive use of DFF’s across modules and are having problems with inconsistencies. ·          Review of you Key & DFF structures for inconsistencies and incomplete setup	·          1-2 hour meeting to discuss how you DFF’s are used ·          Access to SQL & front end applications on a recent copy of production	4 hours
Unix & SQL access policy	·          This is more about prompting you to think about security weak spots and Sarbanes Oxley, FSA & Audit risks ·          Discussions on password policy for UNIX and SQL access.	·          1 hour meeting with IT that would have knowledge of this detail.	1 hour

General Ledger

Description	This will Cover	We require from you	Estimated Time
Chart of account structure	·          Review parent accounts to ensure they are complete and there are no overlaps ·          Recommendations for best use of an existing chart of accounts structure. ·          Maintenance & design of summary accounts	·          2 hour meeting to discuss your chart of accounts structure, and any forthcoming business requires that may impact this ·          Access to SQL & front end applications on a recent copy of production	4 hours
FSG Reports	·          Review for incorrect, overlapping or just confusing FSG reports, with recommendations on how to make best use out of the FSG product. ·          Checking standard Management reports across charts of accounts for inconsistencies.	·          2 hour meeting to discuss how you use FSG reports, and how they are designed & maintained. ·          Access to SQL & front end applications on a recent copy of production	4 hours (1 CoA and 20 reports 8 hours (>1 CoA and over 20 reports
Accounting Security	·          Review security rule definitions. ·          Review security rule assignments. ·          Security rules & custom reports ·          Comparison of security rules against business requirements	·          1 hour meeting to discuss how your security rule requirements ·          Access to SQL & front end applications on a recent copy of production	2 hours
Cross Validation Rules :	·          Checking for invalid accounts ( standard Oracle process ), review of business requirements along with recommendations on how the rules can be improved.	·          1 hour meeting to discuss how your security rule requirements ·          Access to SQL & front end applications on a recent copy of production	2 Hours
Currency	·          Revaluation & Translations ·          Scan your foreign currency journals for patterns of invalid exchange rates. ·          Exchange rate type configuration & usage	·          Access to SQL & front end applications on a recent copy of production	2 Hours

Description	This will Cover	We require from you	Estimated Time
Payables Configuration	·          Particularly useful if you have multiple ( 5 or more ) operating units and want to review for consistency ·          We will review & document your payables & financial options across all operating units ( upto 30 operating units ) and point out any inconsistencies.	·          Access to SQL & front end applications on a recent copy of production	2 hours
Tax Codes VAT/GST/TVA/IVA Consumption Tax & Withholding Tax	·          This is useful if you have a Pan-European Review all VAT codes across operating units. ·	·