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