Oracle Applications

Performance Analysis for Oracle

previous page next page

Oracle Applications

In addition to standard Oracle dimensions, Performance Analysis details the following Oracle Applications dimensions:

OraApps User - Name used to log into Oracle Applications.
OraApps Module - Oracle Applications grouping of windows and forms that constitute a domain application solution. The displayed value is the Oracle Applications module name.

Note: If the StealthCollect agent has not been configured to report the Oracle Applications module name, the module ID will be displayed.
Note: To let the StealthCollect agent automatically report the Oracle Application module name, logon to the Oracle Applications database instance as the APPS account and issue the following SQL command:

grant select on fnd_application_vl to public;

Note: To translate the existing module IDs into module names, issue the following query against the Oracle Applications scheme:

SELECT application_name , application_short_name
FROM apps.fnd_application_vl
WHERE application_id= <MODULE#>

OraApps Responsibility - Oracle Applications user-assigned role.
OraApps Form - Oracle Applications form executing the SQL command.
OraApps Block - Name of the block (form subset), which executed the command.