Skip Headers

Oracle E-Business Suite Integrated SOA Gateway Implementation Guide
Release 12.1
Part Number E12169-10
Go to Table of Contents
Contents
Go to previous page
Previous
Go to next page
Next

Logging for Web Services

Overview

To extend logging support to more granular level and provide inside-out views for Web service activities, Oracle E-Business Suite Integrated SOA Gateway leverages FND Logging Framework and provides an enhanced, flexible Web Service logging mechanism. It lets you easily monitor system activities, track log messages, and troubleshoot any issues encountered during service generation and deployment, as well as the invocation of Oracle E-Business Suite services by Web service clients. More importantly, logging can be enabled at the site level and user level either for all services or specific services or operations depending on your settings.

In other words, with proper logging setups and configuration, all design-time and run-time activities of all integration interfaces within Oracle E-Business Suite can be logged through this framework. You can configure and manage these log settings through a centralized user interface, and purge log messages through SOA Monitor if needed.

Note: Logging feature is supported for SOAP services only. This feature is not supported for REST services.

Key Features

The enhanced Web service logging feature not only inherits the key features of FND Logging Framework, but also includes the following features:

To better understand the logging feature, the following topics are discussed in this chapter:

Accessing the Log Configuration User Interface

Integration repository administrators can configure log settings at different log granularity level, and manage log activities including adding, updating and deleting services and operations through a centralized Log Configuration user interface.

To access the log settings page, log on to Oracle E-Business Suite as a user who has the Integration Repository Administrator role.

Select the Integrated SOA Gateway responsibility from the navigation menu and then select Log link from the Administration section. The Administration tab appears with the Log subtab.

Note: Only users who have the Integration Repository Administrator role can find the Administration section available after logging on to Oracle E-Business Suite with the Integrated SOA Gateway responsibility. All administrative tasks performed outside the Integration Repository user interface are now grouped under the Administration section and displayed in the Administration tab. These tasks include managing log setups in the Log subtab and managing SOAP requests in the SOA Monitor subtab.

the picture is described in the document text

The Log Setup Details page is the entry page to all logging setup and management activities. You can perform the following tasks through this page:

Viewing Existing Logging Configurations

Logging can be enabled through the site and user levels. Once you are directed to the Log Setup Details page, all existing configurations will be automatically displayed either in the Site region or the User region based on the level of the log has been set. For examples, all log settings are listed in the User region if they are enabled at the user level.

the picture is described in the document text

Each log entry listed in the table contains log severity, service details, or a specific username if it is enabled at the user level. All the log setups listed in the table format are registered for what will be logged.

From the configuration or log list table, you can perform the following tasks:

To view existing log configuration:

  1. Log on to Oracle E-Business Suite as a user who has the Integration Repository Administrator role. Select the Integrated SOA Gateway responsibility.

    From the navigation menu, click the Log link from the Administration section. The Log Setup Details page is displayed.

  2. All existing log configurations are automatically displayed and grouped by the level of the log has been set either at the site or user level.

  3. To update an existing configuration, click the Update icon for a desired setting.

    The Create Log Setup page is displayed where you can update the log severity for a selected log setting or add more services.

  4. To delete an existing configuration, click the Delete icon for a desired log setting.

  5. To add a new configuration, click Add Row to add a new log setting.

Adding a New Logging Configuration

After selecting the Log link from the navigation page, the Administration tab appears with the Log subtab selected.

Oracle E-Business Suite Integrated SOA Gateway allows logging feature to be enabled at the following granularity levels or log categories:

Note: Logs for actions such as Generate, Deploy, Undeploy, and Redeploy services should be written only if the logging is enabled for the service at the Site level. Without log configuration set, the logs will not be written.

Important: If a user had set up a log configuration for enabling all services at the site or user level, and then the user decides to update the configuration only for specific services or operations later on, the 'all services' level configuration will no longer be valid and will be overridden by the newer update. For the same reason if the situation is reversed (selected services/operations first, and then 'all services' later), the logging with all services will be acknowledged.

the picture is described in the document text

When adding a new configuration, you need to specify the log level for your log setting. The following table describes the available log levels used for the logging configuration:

Log Level
Severity Description Audience Examples
6-Unexpected Fatal errors that prevent system execution. It can be raised as alerts. Customer System Administrator, Support, Development Required file not found.
Database failure in placing an order.
5-Error End user errors. Customer System Administrator, Support, Development Authentication failure.
Invalid input value.
4-Exception Internal software failure condition. Customer System Administrator, Support, Development Detailed exception stack trace.
Handled Java exceptions.
3-Event Key progress events, and configuration. Customer System Administrator, Support, Development User authenticated. Starting business transaction.
2-Procedure API level flow of application and important events. Development Calling an API. Returning from an API.
1-Statement Low level detailed messages. Development Copying buffer x to y.

Adding a Site Level Log

In the Site region, click Add Row. This creates a row in editable mode. Select the log severity level. You can enable a site level log in the following ways:

Once the newly created record exists in the system, Add Row in the Site region is no longer displayed. The new log is shown in read-only mode.

Adding a User Level Log

To add a user level log configuration, click Add Row in the User region. This adds an empty row allowing you to enter the following basic log information.

Similar to the site level log configuration, a user can add site level logs in the following ways:

Adding Services to a Log Configuration

Log can be set at the Site and User levels. The administrator should be able to enable or disable logging for one or more services or operations contained in the selected services while configuring the log settings.

Click the Service Details icon in the log list table. The Log Configuration page is displayed with the selected log category indicating that the log is set at the Site level or at the User level with a specific username.

the picture is described in the document text

Searching for Services in the Search Region

The Search region contains the following search fields allowing you to locate the desired services based on your criteria:

After executing the search by clicking Go, all the services that match the criteria are displayed in the Search Result region.

Logging can be enabled at the service package level (such as Order Capture - PL/SQL API package) with all methods contained in the service or only with specific operation methods (such as 'Create_Quote and Update_Quote' methods in the Order Capture API).

Click Review to review your selected services or operations for the log settings. The Selected Services/Operations page is displayed with the selected service(s) or operation name(s), log level, and status information indicating whether each selected service or operation is a New selection or not.

Note: If the selected service or operation is already present, 'Existing' is displayed in the Status field. In this situation, that existing configuration will be overwritten by the new changes.

the picture is described in the document text

Click Submit to confirm the action and add the selected services or operations to your log configuration. A confirmation message appears indicating that the log setup information is successfully saved in the system.

the picture is described in the document text

The following icons in the Log Setup Details page become visible allowing you to perform further update on this log setup:

To add a new log configuration:

  1. Log on to Oracle E-Business Suite as a user who has the Integration Repository Administrator role. Select the Integrated SOA Gateway responsibility.

    From the navigation menu, click the Log link from the Administration section. The Log Setup Details page is displayed.

  2. To add a new configuration, click Add Row for the desired log level or category that you want the log to be configured.

    An empty row appears allowing you to enter the following log information:

  3. Click Apply to save and validate your log setting if you do not want to add service to your log.

    This enables all services for your log configuration.

  4. To add the service information to the new log configuration, click the Service Details icon to open the Log Configuration page.

  5. In the Log Configuration page, enter the following search criteria in the Search region:

    Clicking Go retrieves all the services that match the criteria.

  6. From the Search Result region with a list of matched services, configure your log in the following ways:

  7. Click Review to review your selected services or operations for your log settings. The Selected Services/Operations page is displayed with selected services or operations, log level, and status.

  8. Click Submit to confirm the action and add the selected services or operations to your log setting in the Log Setup Details page. A confirmation message appears indicating the log configuration is successfully saved in the system.

  9. To verify your configuration details, click the Service Details icon in the Log Setup Details page.

    The Log Service Details pop-up window appears with a list of enabled services and details including service names, operation names (All), and log severity.

  10. Click the Update icon to further edit your configuration.

Updating an Existing Configuration

From the Log Setup Details page, you can modify an existing log configuration including changing log severity and adding new services or operations.

To enable the update, click the Update icon for a given configuration. You should notice that the read-only text fields now become updatable and the Service Details icon is also enabled (with a '+' sign) allowing you to add new services or operations.

the picture is described in the document text

In the Log Setup Details page, you can perform simple update on the basic log setting such as log severity level or username if it is for a user level log. Click Apply to save and validate the change.

To add services or operations to the log setting, click the enabled Service Details icon to invoke the Log Configuration page where you can search and add desired services. After adding new services or operations to your log configuration, click Review to open the Selected Services/Operations page with selected services or operations, log level and status information indicating whether each selected service or operation is a new selection or not. Click Submit to confirm and add the selection to the log configuration and you are redirected back to the Log Setup Details page.

Click the Service Details icon to have a quick view on the selected service details.

Important: If a user had set up a log configuration for enabling all services either at the site or user level, and then the user decides to update the configuration only for specific services or operations later on, the 'all services' level configuration will no longer be valid and will be overridden by the newer update. For the same reason if the situation is reversed (selected services/operations first, and then 'all services' later), the logging with all services will be acknowledged.

How to add new services or operations, see Adding Services to a Log Configuration.

To update an existing logging configuration:

  1. Log on to Oracle E-Business Suite as a user who has the Integration Repository Administrator role. Select the Integrated SOA Gateway responsibility.

    From the navigation menu, click the Log link from the Administration section to open the Log Setup Details page.

  2. To update an existing configuration, click the Update icon for a desired configuration.

    The read-only text fields now become updatable allowing you to update basic log information such as log severity or username if it is a user level log. Click Apply to save and validate the change.

  3. To add new services or operations to the selected setting, click the enabled Service Details icon (with a '+' sign) to open the Log Configuration page allowing you to add more services.

    Once desired services or operations are selected, click Review to open the Selected Services/Operations page with selected services or operations.

    Click Submit to confirm and add the selection to the log setting.

Deleting an Existing Configuration

If an existing log configuration is no longer needed, you can remove it directly from the Log Setup Details page.

To delete a configuration, click the Delete icon for a desired configuration that you want to delete. This removes the record from the table and system. A confirmation message appears indicating that the selected log setup is successfully deleted. This disables the logging feature for the selected services or operations contained in the removed log setting.

If the deletion is at the site level, the Add Row button appears in the Site region allowing you to configure site level log setup.

To delete an existing logging configuration:

  1. Log on to Oracle E-Business Suite as a user who has the Integration Repository Administrator role. Select the Integrated SOA Gateway responsibility.

    From the navigation menu, click the Log link from the Administration section to open the Log Setup Details page.

  2. To delete an existing configuration, click the Delete icon for a desired configuration. The selected configuration should be removed from the list and system.

Viewing, Deleting, and Exporting Log Messages

Integration repository administrators can view, delete, and export the log messages recorded for the associated services or operations that have logging enabled properly.

Please note that sensitive information such as passwords, and security credentials in unencrypted plain text will not be logged.

Viewing Generate and Deploy Time Logs and Service Processing Logs

To effectively troubleshoot or debug any error occurs at each stage of service development life cycle, logs can be viewed and downloaded for further analysis. Based on your log configuration and setups, the logging framework will filter the logs specifically for the design time and run time for the services that have logging enabled properly.

At design time during service generation and deployment, logs can be captured through the Integration Repository user interface if logging is enabled (at any log severity level) for specific services or all services at the Site level only. Administrators can find View Log in the Interface Details page for the services (or all services) that have logging enabled properly.

To view and download the log messages, click View Log to open the Log Details page where you can find a list of log messages compiled in a table.

Please note that if logging is enabled for 'All Services' at the Site level, then View Log will be shown in the Interface Details page for all interfaces that can be service enabled. If the logging is enabled at the Site level for specific operations, then there will be no log generated and you will not find View Log in the Interface Details page. This type of log that is written during service generation and deployment is only available if the logging is enabled for specific services or all services at the Site level.

Note: You will not find View Log available in the Interface Details page for a given service if the logging is enabled at the user level. Only site level logging configuration with specific services or all services will have Generate and Deploy time logs captured.

Generate and Deploy Time Logs

the picture is described in the document text

At run time during the invocation of Oracle E-Business Suite services by Web service clients, if a service has logging enabled, the associated log messages are captured and can be viewed through SOA Monitor. If log messages are available for an instance, the Log icon appears in the search result table for that request in SOA Monitor. Click the Log icon to open the Log Details page where you can view logs recorded for the request against a specific instance.

Service Processing Logs

the picture is described in the document text

Deleting and Exporting Logs Listed in the Log Details Page

After viewing log messages retrieved for a service in the Log Details page, you can delete them if needed by clicking Delete All. A warning message appears alerting you that this will permanently delete all the logs retrieved in the page. Click Yes to confirm the action. An empty log table appears in the page after logs are successfully deleted.

Note: Please note that the log records deleted here are instance specific, whereas the Purge program from the SOA Monitor requiring you enter specific date range in executing the concurrent request is not. The purge concurrent request through SOA Monitor will delete only the service processing logs for which the service is completed with a status of 'SUCCESS'. It does not delete the logs for the service with 'FAILURE' status.

For more information on purging logs through SOA Monitor, see Purging SOAP Messages, Audits, and Logs.

Before deleting the logs, you can save a backup copy by clicking Export. This allows you to export the records listed in the Log Details page to Microsoft Excel and save them to a designated directory and use it later.

For more information on viewing logs recorded during service generation and deployment through Integration Repository, see Viewing Generate and Deploy Time Logs.

For more information on viewing log messages recorded while processing service requests, see Viewing Service Processing Logs.