E-Business Analysis
The E-Business analysis reports on key Oracle E-Business operational areas including application performance and security characteristics and can be used for a general E-Business health check review.
These key areas include the following:
Application Site Profile
This report provides a high-level overview of the installed application.
This overview includes the following:
Installed version
Application Attributes
Critical Site Level Profile Options
Server Summary
Installed Product Summary
The information in this report is used as the starting point of any application analysis or debugging effort. The version number and optimizer mode are used to determine the level of object statistics that should be collected.
The following topics are included in this report:
Oracle E-Business Suite Environment
Optimizer mode
Profile Options
Invalid Objects
This report details the numbers of invalid objects related to the Oracle E-business and registered custom applications installation.
A registered application is any application that is registered through the Oracle E-Business application.
It is important to know whether there are any objects that have become invalid over the past 1 – 2 months, as these objects may be used as part of a business process that will fail if and when the object is used. This may be a major problem if the result of encountering the object causes any delay and forms part of the highly visible month end-processing schedule.
An invalid object is any database object Function, View, Stored Procedure, etc. that has been marked (internally) with a status of Invalid. In an Oracle E-business environment there are over 45,000 objects, many of which are interrelated and some of which are dependent on shared modules (not fully installed). So it is common for there to be a number of invalid objects that will never be "fixed". There are many causes of objects invalidation. The main cause is version patching.
The following topics are included in this report:
Identifying New Invalid Objects
Findings
Recommendation
Security Overview
Many users from different organizations and possibly even users outside your corporate firewall may use the Oracle E-Business Suite. For this reason, maintaining application security is essential. This report provides a high-level starting point to identify security issues within the application.
An application user is any user that has been registered in the application and has not been end dated. New users are often added, but the user maintenance process generally falls down when the user leaves the organization and they are not removed from the application (end dated).
This report provides an overview of the user activity and identifies all the users who are candidates for removal (end dating). This report also identifies the users that have Systems Administrator or Application Developer responsibilities (this help you to locate users who should not have these responsibilities). Finally this report will identify common security issues that are easy to remedy.
The following topics are included in this report:
Aged Users
Accounts with Special responsibilities
File Permissions
Database account with special privileges
Database Account access
Password complexity
Recommendations
Monitoring
Notes
Audit Space Management Optimization (Purge)
The purpose of this report is to identify high priority purge programs which the Applications System Administrator should run to ensure a proper working environment.
This report checks to see whether specific Oracle supplied purge programs should be run. It checks to see if these Oracle purge programs are scheduled and then determines the volume of data that can potentially be purged based on best practices. This report also lists some key indicators about the range of data that can be purged.
The Applications Administrator should also review the purge programs available in the various functional areas installed.
The purge programs listed below represent a small portion of the purge programs available in the Oracle E-Business Suite.
The following topics are included in this report:
Concurrent Request and Concurrent Queue information
Sign on Audit information
Temporary Table information
Workflow Runtime Data
Generic File Manager information
Purge Debug log
Order management Message information
Recommendations
Monitoring
Application Performance
This report details the top batch processes in the Oracle E-Business Suite Environment. These programs should be examined for possible fixes either in the form of Oracle performance patches, custom programming fixes or modification of business practices around these areas.
The concurrent programs running in the Oracle E-Business Suite environment can have a significant impact of the performance and/or perception of performance of the environment. Understanding what programs are running the most and if these patterns change is a necessary part of maintaining the Oracle E-Business Suite environment. This report provides a view of the top consumers of system resources. It also shows the administrator the distribution of concurrent jobs over time to help the administrator balance schedule processes to balance the system load over the day and weeks.
Quest Software's Spotlight on Oracle Applications can be used with these reports to more closely examine these jobs and their impact. Spotlight on Oracle when used with Spotlight on Oracle databases and SQL Lab is a complete solution from Quest Software to identify and resolve performance problem with the Oracle E-Business Suite. Additionally, Quest Software's Foglight can be used to proactively monitor specific programs and assist with the tuning effort.
The following topics are included in this report:
Top 50 concurrent programs by runtime
Program schedule distribution
Concurrent Manager tuning
Sleep times
Database initialization parameters for Oracle Applications version 11i
Statistics
Resolving overloaded server problems
Monitoring