Health Checks & Audits

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

 
 
Accounts Payable

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.
·           
·